2002-11-27
7,432 reads
Administration
2002-11-22
14,574 reads
How to Diagnose and Fix Wait Locks
This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.
2002-11-21
36,247 reads
Review of Real-World SQL-DMO
Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!
2002-11-19
5,269 reads
Removing Orphan Users from All Databases on Server
In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server.
2002-11-18
16,121 reads
Move Your Master
How often do you move your master database? Hopefully never, but this article looks at an easy technique should you need to perform this trick.
2002-11-12
10,014 reads
Worst Practice - Not Having An Archive Plan For Each Table
We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?
2002-11-11
9,238 reads
SQL Server Notification Services Documentation
Microsoft has released the "Books Online" equivalent for Notification Services. Browse through and take a look to see if this service is useful to you.
2002-11-01
694 reads
Hidden Connections
Ever have strange DTS errors after moving a package? You changed all the connection strings, but still get connection errors. Steve Jones did and tracked down one potential culprit.
2002-10-29
4,388 reads
Alternatives to SQL Backups
All of do us regular backups. Ok, all of us SHOULD do regular backups. In this article Andy comments on why having a backup plan isn't enough and why you should look at some other options for when you need to fix data errors. This really speaks to the goal of minimizing down time using low tech, readily available solutions. If you're not interested yet, we'll add this - one of the alternatives he suggests is Microsoft Access!
2002-10-28
8,430 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers