Security Alerts and Information
A new security alert affecting SQL Server was released on June 12, 2001
2001-06-14
3,617 reads
Security
2001-06-14
5,612 reads
2001-05-25
3,999 reads
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,070 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,712 reads
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,535 reads
Using the Public Role to Manage Permissions
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,551 reads
Rants about the sa account!
Using the sa account in development is just plain dumb. Here are some reasons why!
2001-05-08
6,806 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers