Sites anglophones


Get Alerted When Your SQL Server Restarts with sp_SendStartupMail

Publié le 15 juillet 2020 sur brentozar.com
 

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?

Publié le 14 juillet 2020 sur brentozar.com
 

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

Publié le 14 juillet 2020 sur sqlservercentral.com
 

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

Publié le 14 juillet 2020 sur sqlservercentral.com
 

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

Publié le 14 juillet 2020 sur sqlservercentral.com
 

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?

Publié le 13 juillet 2020 sur brentozar.com
 

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

Publié le 13 juillet 2020 sur sqlservercentral.com
 

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

Publié le 13 juillet 2020 sur sqlservercentral.com
 

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

Publié le 12 juillet 2020 sur brentozar.com
 

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

Publié le 10 juillet 2020 sur sqlservercentral.com
 

The post Handling System-named Constraints in SQL Compare appeared first on SQLServerCentral.

Want Your Own Private Conference?

Publié le 9 juillet 2020 sur brentozar.com
 

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

Publié le 9 juillet 2020 sur sqlservercentral.com
 

The post Using SQL Source Control projects in Azure Data Studio appeared first on SQLServerCentral.

Implementing Restart Ability For Shell Scripts

Publié le 9 juillet 2020 sur sqlservercentral.com
 

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

Publié le 8 juillet 2020 sur brentozar.com
 

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

Publié le 8 juillet 2020 sur sqlservercentral.com
 

The post Simple Database Development with SQL Change Automation appeared first on SQLServerCentral.


Pages :