Get Alerted When Your SQL Server Restarts with sp_SendStartupMail
When your SQL Server restarts, how do you find out? I’ve seen a few senior DBAs do a really smart trick: they write a stored procedure to send them an email, and then they mark that stored procedure as a startup stored procedure so that it runs a …
What If You Really DO Need to Shrink a Database?
You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it …
Basic Git for DBAs: Making Changes in GitHub
This is the fourth article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches In the fir …
Using SQL Data Compare to Sync Reference Data
The post Using SQL Data Compare to Sync Reference Data appeared first on SQLServerCentral.
Using SQL Server Query Store & Plan Guides to Fix Problem Queries
The post Using SQL Server Query Store & Plan Guides to Fix Problem Queries appeared first on SQLServerCentral.
Where is the SQL Server Community Networking Online?
You’ve stumbled upon this blog, and you’re having a pretty good time. Now you’re wondering, “Where else can I network with database folks, get to know them, and talk shop?” You’re not getting out due to the quarantin …
SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies
The post SQL Prompt Snippets to Drop Columns and Tables and Handle Associated Dependencies appeared first on SQLServerCentral.
Loading data in Azure Synapse using Copy
Introduction Azure Synapse Analytics (formerly SQL DW) )is the next evolution of Azure SQL Data Warehouse. It is a combination of enterprise data warehousing and Big Data Analytics. A Synapse SQL Pool is the enterprise data warehousing feature tha …
Updated First Responder Kit for July 12, 2020: Fixing sp_BlitzFirst @ExpertMode
I don’t normally do multiple releases per month, but sp_BlitzFirst had a pretty big bug in the last release for those of us who do live performance tuning. In the July release, a well-meaning contributor tried to make sp_BlitzFirst faster wh …
Handling System-named Constraints in SQL Compare
The post Handling System-named Constraints in SQL Compare appeared first on SQLServerCentral.
Want Your Own Private Conference?
Your team has been reading my blog, watching my free public streams, and using the First Responder Kit scripts for years. They’ve gone as far as they can go on their own, learning from Google, and now they’re ready for the next level. I can …
Using SQL Source Control projects in Azure Data Studio
The post Using SQL Source Control projects in Azure Data Studio appeared first on SQLServerCentral.
Implementing Restart Ability For Shell Scripts
Introduction Shell Scripts are widely used in various systems, whether it be for system administration or performing ETL processing. Shell Scripts are mostly designed to perform specific capabilities that an administrator needs. For example, let’s …
The 201 Buckets Problem, Part 2: How Bad Estimates Backfire As Your Data Grows
In the last post, I talked about how we don’t get accurate estimates because SQL Server’s statistics only have up to 201 buckets in the histogram. It didn’t matter much in that post, though, because we were using the small StackOverfl …
Simple Database Development with SQL Change Automation
The post Simple Database Development with SQL Change Automation appeared first on SQLServerCentral.