How to receive Deadlock information automatically via email
Receive Deadlock info from the SQL Error Log every time a deadlock occurs.
Keeping Track of your SQL Servers with a DBA Configuration Repository
SQL Server DBAs are often responsible for managing large number of database instances. This article talks about the concept of a Configuration Repository where DBAs can manage all the information related to their SQL Servers
Free eBook: 45 Database Performance Tips for Developers
As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.
SQL Server 2014 In-Memory OLTP Architecture and Data Storage
Microsoft is releasing SQL Server 2014 with a new set of In-Memory OLTP features to significantly improve the OLTP performance and reduce the processing time for servers with a large amount of memory and multi-core processors. Check out this tip to learn more.
Using Extended Properties To Keep Everyone Informed
Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.
SQL Server Optimizer – Under the Hood Part 1
In this series of short articles, we lift the hood of the SQL Server Optimizer to examine a few of the many clever tricks used to optimize query performance. In Part I, we look at partial aggregate operators – an extremely clever way of downsizing certain large joins into much smaller (and faster) joins.
2013 in Review
Steve Jones looks back at 2013, starting with his predictions on Jan 1 and looking at how data and SQL Server impacted our community.
Set Up And Schedule a Server Side Trace
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
Blogs
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
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...
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