SQL ConstantCare® Population Report: Spring 2020
Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the spring 2020 version of our population report. Our SQL ConstantCare® service lets users send …
The State of Database Monitoring in 2020
The post The State of Database Monitoring in 2020 appeared first on SQLServerCentral.
Installing SQL Server 2019 using the Azure Cloud Shell
Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate t …
Updated First Responder Kit and Consultant Toolkit for May 2020
The post Updated First Responder Kit and Consultant Toolkit for May 2020 appeared first on SQLServerCentral.
Recycle Fulltext Catalog Log Files
It’s not often that I have the need or opportunity to work with FullText Indexes, and it’s also not often that I come across a new thing to add to regularly schedule maintenance tasks in SQL Server. Today I happened to do at the same …
How to Create an Ubuntu PowerShell Development Environment – Part 3
The series so far: How to Create an Ubuntu PowerShell Development Environment – Part 1 How to Create an Ubuntu PowerShell Development Environment – Part 2 How to Create an Ubuntu PowerShell Development Environment – Part 3 Over the la …
[Video] Watch Brent Write Queries
This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a vari …
Storage 101: Convergence and Composability
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …
The Basics of Using a Sequence as a Table Default
The Sequence object was introduced in SQL Server 2012. This is a separate schema object that produces a sequence of numeric values, similar to the way an identity works. A sequence is a separate object, however, and it produces values independent of a …
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 …