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,124 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
9,977 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,947 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,549 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)
37,692 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,296 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,154 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,141 reads
Blogs
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Forums
Restore dbs
The below code works for backup files only from local drives. When replaced with...
Fine-tune SQL for better performance
I have been asked to fine-tune the following SQL that was written by a...
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers