How to create SQL Server virtual appliances for Hyper-V
Creating a private SQL Server VAP will reduce the time it takes to deploy additional SQL Server machines in your environment.
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
SQL Backup 6: Wind of Change
One could be forgiven for thinking that there's little more you can do with third-party backup software than just ...er... backup databases. Shawn McGehee gives us his personal take on the implications of the improvements that have been made to SQL Backup for version 6.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
DBA: Mentor vs. Protector
To mentor or to protect data, what is the role of the DBA? A guest editorial from Matt Simmons.
Disk Partitiona Alignment Best Practices for SQL Server
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.
Evil Code
/*
A couple
of years ago, when I wrote the Simple-Talk Prettifier that is really no more than a stored
procedure...
How to Specify Command Line Parameters for DTEXEC Using Command Files
Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?
Blogs
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,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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