Basics for working with DATETIME and SMALLDATETIME
Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.
Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I
This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wrong
Solid State Replacements - Database Weekly (August, 18, 2008)
New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
Solid State Replacements - Database Weekly (August, 18, 2008)
New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
Solid State Replacements - Database Weekly (August, 18, 2008)
New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
Detaching Databases - SQL School Video
One very handy technique for dealing with the need to copy or move a database involves detaching the database from your instance. MVP Brian Knight shows how easy this can be to perform on your server.
Identifying Queries Running Slower Than Normal
The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.
Multiple Server Queries with SSMS 2008
This short article shows how to run the same query against multiple servers and aggregate the results into one set with SSMS 2008
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers