SQL ConstantCare® Population Report: Winter 2020
Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out.
2020-03-23
Additional Articles
What’s New in SQL Monitor 10?
New release: SQL Monitor 10
SQL Monitor 10 has landed! You can now integrate SQL Monitor alerts with your ticket management system, so chosen alerts are automatically raised as tickets. New suppression options give you granular control over what alerts are raised during specific times, such as maintenance windows. And, you can now annotate the server activity graph with specific events, so you can measure their impact on your servers.
Discover the new features
2020-03-23
Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins
Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.
2020-03-20
Verifying Object Exists and Dropping Object with One Statement
For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
2020-03-19
Securely Manage Database Credentials Using Visual Studio Manage User Secrets
In this tip we cover how to manage application secrets in a development environment to securely store database credentials.
2020-03-18
Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints
Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.
2020-03-17
Overview of Azure Cache for Redis
Caching data is one way to improve application performance. In this article, Chandra Kudumla explains a service for caching data found in Azure called Azure Cache for Redis.
2020-03-16
Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY
I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. To make that easier, I’m running the Fundamentals of Index Tuning class this week on the blog.
2020-03-13
Enterprise Insights from the 2020 State of Database DevOps report
17% of Enterprise respondents in this year's State of Database DevOps survey reported that DevOps has been adopted across all projects in their organization. This year’s State of Database DevOps report gave us some great insights into the landscape of Database DevOps. Kendra Little walks us through those insights specific to Enterprise organizations.
2020-03-12
Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause
I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class.
2020-03-12
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers