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.
The 201 Buckets Problem, Part 1: Why You Still Don’t Get Accurate Estimates
I’ll start with the smallest Stack Overflow 2010 database and set up an index on Location:USE StackOverflow2010 GO CREATE INDEX Location ON dbo.Users(Location); GO SELECT COUNT(*) FROM dbo.Users; GO There are about 300,000 Users – not a lot …
Automating Oracle Database Deployments using the Hybrid Approach
The post Automating Oracle Database Deployments using the Hybrid Approach appeared first on SQLServerCentral.