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 […]
PostEvery Vote Matters In Your SQL Server Availability Group
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 […]
PostOutsourcing Your SQL Server Data Archival Process
When I first started driving in North America, one of the things that I noticed along the freeway is a self-storage facility. Having not seen one before, I asked my dad what they were for – they are space rented out on a short-term basis where you can keep your personal stuff. If people don’t have enough space […]
PostThe Lifeblood Across The Wire
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 […]
PostMuch Ado About DNS
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 […]
