Fixing Your Identity
If you use identity values, chances are that at some point you will need to find more information about the next value or reset the seed. This article looks at how you can accomplish this.
2001-12-31
7,157 reads
Administration
nternet Data Center 1.5 - Reference Architecture Guide
This document (divided in chapters for your convenience) describes how to design a secure, scalable, highly available, and manageable Internet data center that is based on Microsoft products. This documentation examines the major challenges to consider when designing an Internet data center architecture and how this design addresses these challenges.
2001-12-30
967 reads
Web Data Administrator
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser.
2001-12-14
4,151 reads
SQL Server 2000 Undocumented System Tables
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
10,017 reads
SQL Server 7.0 Undocumented Extended Stored Procedures
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
7,990 reads
DBA Job Description: What type of DBA are you?
One of the common questions that Brian Knight sees in the newsgroups is what is a DBA officially supposed to be doing? In this article, Brian covers the many hats a DBA can and does wear.
2001-11-05
19,688 reads
Push FTP with SQL Server
DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.
2005-07-01 (first published: 2001-11-01)
38,025 reads
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,316 reads
Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
2001-10-30
6,193 reads
Worst Practices - Making Databases Case Sensitive (Or Anything Else)
Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!
2005-07-08 (first published: 2001-10-29)
29,258 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...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
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...
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