SQL Server 2008 Service Pack 1 Released
Service Pack 1 for SQL Server 2008 has been released. Follow the link for more information.
Working with Amazon Simple DB
This article explores the concepts and methods necessary to create, manipulate, and work with Amazon Simple DB.
Keep It Simple
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
Removing Audit History - SQL School Video
MVP Andy Warren continues his series of videos on auditing with a look at removing old data. In this video, learn how to develop an easy system to keep a rolling history, removing anything older than a set number of days.
Report Templates Using Stylesheets
In the third article in his series on styling reports, Aaron Akin takes a look at using templates to ease and speed development.
Database Mirroring FAQ: Why is my mirror database in a restoring state?
Question: Why is my mirror database in a restoring state? Hi, I am still working on DB mirroring with prinicpal and mirror. There will be no Witness. This is what I did and
SQL Server 2008 Integration Services Tasks
This article is the first in a series of articles that will be covering all the Control Flow Tasks and Maintenance Plan Tasks in SQL Server 2008 Integration Services
Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008
A tip from MSSQLTips that shows a few ways for implementing paging on large tables.
Guest Editorial: Improving Northwind
The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers