Restore a DTS package from a DTS Store
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
2004-04-08
9,879 reads
Articles
Review of Guru's Guide to SQL Server Architecture and Internals
If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!
2004-04-07
6,654 reads
Beginning ADO.NET
One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.
2004-04-01
295 reads
The Need For Speed - Upgrading Your Servers
Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.
2004-03-30
6,477 reads
SQL Server Auditing and Notification
As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!
2004-03-29
9,192 reads
Review of Review of SQL Server 2000 Administrators' Companion
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
2004-03-26
4,142 reads
Working with the Registry
It's not often you'll need to access the registry from SQL, but when you do - these functions make it happen!
2004-03-23
9,593 reads
SQL Server 2005 Feature Survey Results
A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article.
2004-03-22
11,220 reads
Yukon Passwords
Some good info on password changes in Yukon (SQL 2005). Based on the beta, but worth taking a look at.
2004-03-19
8,925 reads
Null Functions (Arent those Meetings?)
Dinesh did a little research on nulls and was kind enough to package it up for us. How many of you know or use NULLIF? Or COALESCE? Handy stuff!
2004-03-18
10,165 reads
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