Rewiring Your Culture for an AI-Augmented Future with Intelligent DataOps
The post Rewiring Your Culture for an AI-Augmented Future with Intelligent DataOps appeared first on SQLServerCentral.
Attention Season Pass Holders: New Fundamentals of Parameter Sniffing Videos Available!
If you’ve got a Recorded Class Season Pass or Live Class Season Pass, time to get your learn on: yesterday’s Fundamentals of Parameter Sniffing class recordings are now available in your account here. As a reminder, here’s the class a …
How Many Databases Can You Name?
The post How Many Databases Can You Name? appeared first on SQLServerCentral.
Improve Row Count Estimates for Table Variables without Changing Code
You probably have heard that table variables work fine when the table variable only contains a small number of records, but when the table variable contains a large number of records it doesn’t perform all that well. A solution for this problem h …
Microsoft SQL Server Utilities and Tools
Useful free and paid Microsoft SQL Server utilities and tools – a complete list of 275 SQL Server Utilities updated on Jan 24, 2019. Utility types (main purpose), in braces {} current counts: : Backup solutions {6} [BI]: Business Intelligence Solutions …
SQL ConstantCare® Now Tells You Which Indexes to Drop.
Indexes slow down data changes. SQL Server doesn’t have the concept of asynchronous indexes – copies of the data that it could update later when it’s bored. It has to keep every nonclustered index up to date, every single time you cha …
Adding a Database with Polybase External Tables to Always On Availability Group
Introduction I was asked to add a database with PolyBase External Tables to Always On Availability Group. I thought it would be a straightforward approach, but it got tricky when I learned that one of the prerequisites of PolyBase is that a master key …
[Video] Watch Brent Write T-SQL
This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write t …
How to Move System Databases to a New Physical Directory
I was recently on a very challenging project where we had to do some SQL tasks that were both new to me as a DBA and proved to be challenging. I found myself doing certain tasks over and over. When this happens, I usually find myself automating, creati …
Learning New Skills
The post Learning New Skills appeared first on SQLServerCentral.
New release: SQL Clone 4.4 supports your Database DevOps process
The post New release: SQL Clone 4.4 supports your Database DevOps process appeared first on SQLServerCentral.
Azure Database Migration Guide
The post Azure Database Migration Guide appeared first on SQLServerCentral.
Heaps in SQL Server: Part 1 The Basics
The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are …
[Video] How to Think Like the SQL Server Engine: All-Demo Edition
You’ve heard of my free How to Think Like the Engine class, and maybe you even started watching it, but…it has slides, and you hate slides. Wanna see me do the whole thing in Management Studio, starting with an empty query window and …
Hands-On with Columnstore Indexes: Part 1 Architecture
Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced i …