In a previous blog post, I talked about the benefits of using cluster shared volumes (CSVs) for your SQL Server 2014 and higher failover clustered instances (FCIs). It’s also interesting how SQL Server Microsoft Certified Master and Microsoft MVP Argenis Fernandez (blog | Twitter) responded to a Twitter post I shared about the blog post […]
PostHow My Visits to the Hospital Helped Me Become a Better SQL Server DBA
My personal calendar for the past few weeks have been filled with visits to hospitals, clinics and other medical professionals after what happened to my wife last March. Growing up, I hated visits to hospitals. It’s probably because of all the medications I have had to take to treat primary complex. Show me a syringe used for […]
PostHow Attention To Detail Can Make Your Systems Highly Available
As my son was struggling to figure out how to download the Amazon Kindle app on his iPad, I can’t help but notice the email he got from Amazon. The email contains the URL link where to download the Kindle app. And the message said something like this: [callout]Download the free Kindle reading app on your […]
Post3 Ways To Master A New SQL Server Feature
With the announcements for making SQL Server 2022 available for public preview, it’s challenging to catch up with all the learning. This is one of the reasons why we still see software applications that do not support features of the latest SQL Server versions even though they are already running on top of it. Developers […]
Post3 Types of Microsoft High Availability Technologies
Every now and then I get questions about how to implement load balancing with SQL Server databases. Because organizations want to maximize their IT investments, a standby server is almost always a red flag – it’s an idle asset. Hence, the questions about load balancing workloads on SQL Server databases to maximize the resource utilization on […]
PostImplementing Instant File Initialization on SQL Server with SMB File Share
We were taught early on that when you heat water to 212 F (100 C,) it starts to boil. Oh, those memorable science experiments we did in high school. We put a thermometer in a water-filled flask and light up a burner to heat the water in the flask. We watch as the thermometer records the temperature […]
PostWhy SQL Server Professionals Need To Learn Cloud Computing
Growing up, my mom required us to help with household chores. And, I’m so glad she did. I remember doing my own laundry when I was 9 years old – with no washing machine nor dryer. Being in a private school didn’t help either – I had to get my school uniform ready before the […]
PostTSQL Tuesday #77 – Favorite SQL Server Feature: SQL Server Logging
It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|Twitter) started. This month’s episode is hosted by Jens Vestergaard (blog | Twitter). The topic: Favorite SQL Server Feature. And my favorite SQL Server feature is not any of the latest and greatest ones. That might come as a surprise but at the end of the blog […]
Post5 Reasons Why Microsoft Azure Can Be A Cost Effective Data Center Solution For Small and Medium-sized Businesses
Do you still remember the very first time you have had your hands on a mobile phone? I sure do. Because back in those days, you need to sign up with a mobile phone service provider to have a phone and use their service. You choose from the different plans available from the service provider […]
PostThe Feature Was There All Along
SQL Server Availability Groups have been around for a while. A lot of organizations are still in the process of implementing them as they upgrade their database platforms to the latest version of SQL Server. As more and more organizations move away from older versions and into the newer ones, Availability Groups will become much […]
