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
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
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
10,012 reads
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
7,989 reads
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,668 reads
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)
37,983 reads
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,312 reads
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,181 reads
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,236 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,530 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Comments posted to this topic are about the item Fabric Mirroring
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers