Updated First Responder Kit and Consultant Toolkit for January 2022
In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and more. Wanna watch me use it? Take the class.To get the new version: Download the updated FirstResponderKit.zip Azure Data …
SQL Server Dacpac in Azure Data Studio
Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a …
Where’s the best place to live as a DBA?
The post Where’s the best place to live as a DBA? appeared first on SQLServerCentral.
Power BI Zoom and Focus
The post Power BI Zoom and Focus appeared first on SQLServerCentral.
Error Handling Quiz Week: Where Are You Handling Errors?
This week’s series on error handling has been an eye opener for many of us. We’ve laughed. We’ve cried. We’ve screamed in horror. We’ve read the documentation. I don’t blame you. This is a really confusing topic, and …
Quantifier predicates
The post Quantifier predicates appeared first on SQLServerCentral.
Performance Tuning Using Free Tools, Part 2
Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware or paying Azure SQL bills. You can keep the cost under control by improving the efficiency of your databases. You can improve your databases usin …
A Database DevOps Workflow Using Redgate Deploy
The post A Database DevOps Workflow Using Redgate Deploy appeared first on SQLServerCentral.
Error Handling Quiz Week: Making a Turkey Sandwich with XACT_ABORT
CAN YOU BELIEVE THAT HOT MESS IN YESTERDAY’S POST?!? I know, right? You thought that by combining try/catch with a transaction, you’d get robust error handling. Instead, you ended up with half the tables populated, and a leftover open …
A Fond Farewell
If you haven’t guessed from the title, I’m writing this post because I am leaving SQLskills. This Friday, January 14th, is my last day, and I am currently a mess of emotions. I am leaving on the best terms possible, and it’s bec …
The Curious Case of… tracking page compression success rates
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Error Handling Quiz Week: Combining Transactions And TRY/CATCH
In yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not solve our problem – and in fact, it makes things worse. With yesterday’s code, we still got rows inserted into the Pa …
Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment
The post Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment appeared first on SQLServerCentral.
Automating Flyway Undos
The post Automating Flyway Undos appeared first on SQLServerCentral.
Error Handling Quiz Week: Will a Transaction Help?
In yesterday’s post, we tried a TRY/CATCH, and those of us who actually ran the demo scripts were disappointed. We found that a TRY/CATCH alone doesn’t fix it: we end up getting rows in the Parent table, but no rows in the Child table. It t …