Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've...
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
Mastering SQL Server Profiler - Part 2: Profiler Architecture
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.
Blogs
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...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
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...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
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