Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Articles
Understanding the Implications of ANSI SQL92 SET Options
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,887 reads
New Certification - MS System Administrator
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
2001-10-18
1,223 reads
A Few Meta Data UDFs
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,126 reads
Executing a script from SQL Server
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,648 reads
2001-10-15
3,991 reads
2001-10-15
1,871 reads
2001-10-12
3,613 reads
Common SQL Server and Windows Clustering Questions and Problems
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,685 reads
Review: Total SQL Analyzer
Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the product and some of it's features.
2001-10-10
8,222 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers