Change Management
This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.
Analyzing and Optimizing T-SQL Query Performance on SQL Server
This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes
Autoclose for Databases - Part II
In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.
Managing Jobs Part 3
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
Migrating To A New Server : Moving Logins
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
Introduction to English Query and Speech Recognition
The first part of this series provides a road map for a very cool application using an under-utilized companion of the SQL Server 2000 database platform.
Analyzing and Optimizing T-SQL Query Performance Part 1
In this series by Quest Software's Kevin Kline, he shows you some tips to performance tuning T-SQL. This was contributed by Quest from their recent webcast. This white paper discusses various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.
Who Owns That Database?
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
SQL Server Upgrade Recommendations and Best Practices - Part 1
This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.
Ways to Determine the Version and SP of SQL Server
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers