Powershell: Failover a SQL Service in a Failover ClusterIs this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize...
Automate SQL Server InstallI couldn't find a relevant photo for this post. But you can enjoy a nice cup of coffee in the morning when you automate stuff. As always,...
Book Review: SQL Server Query Performance Tuning by Grant FritcheyMy war torn copy. I spent the last few months looking like a total dork reading this book on the train. But I'm a rockstar when I get to...
Cloud Series: High Availability in Azure SQLAzure provides built in high availability. In a given server region, you are provided with three local copies of the Azure SQL Database....
Detecting Storage I/O Problems in SQL ServerSo here's a scenario. You have a client that has implemented SAN storage for your SQL Servers (could be virtual or physical). Your...
Consulting Series: Dumping a ClientHow to go about dropping less than ideal clients in your practice.
Cloud Series: Restore Database in AzureOne of the great things about Azure is that backups are automated as part of the service. Azure for SQL touts a 12 hour RTO and a 5...
Cloud Series: Create and Azure SQL DatabaseGoing to the Azure Portal, creating our first SQL Database.
Cloud Series: Intro to Azure SQLIf only I could upload my brain to the cloud. BaaS anyone? What is Database as a Service (DaaS)? Azure SQL Database is Microsoft's...
Parameter SniffingNot always optimal... What is it? Let’s say you have a parameterized proc, and it creates and caches an execution plan based on certain...