How to troubleshoot orphan users in SQL Server databases?

This article explains how orphan users get created, and provides you with troubleshooting information. A bonus stored procedure called ShowOrphanUsers is included, that goes and searches all the databases and generates a complete list of orphan users.

Working with email addresses in SQL Server!

This article shows you how to design the storage for email addresses, how to validate email addresses, how to retrieve demographic information from email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.

Free SQL Server 2000 Certifications

Certy.com has just released SQL Server 2000 certifications. These certifications are 100% free and a must for any DB developer & DBA.

Unauthenticated System Compromise of SQL Server 2000

Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.

SQLClean 2.0 Released

SQLClean is a SQL Tool that automatically creates a dependancy analysis of your SQL Server Database including tables, views, triggers, defaults, procedures etc. SQLClean will also analyze a client application for depenandies on SQL Objects allowing you to detect and eliminate unused SQL objects that are unreferenced by either the client app. or database itself.

Security Update for SQL Server SP2

Microsoft has release a cumulative security update for SQL Server with SP2. Read , download and update your SQL Server!

SQL Server Best Practices web seminar offered by NetIQ

Join NetIQ on July 17, 2002 for a free web seminar on "SQL Server Best Practices -- Tools and Techniques for Improving Production Operations". The event is being offered three times at 9:00 AM ET, 12:00 Noon ET, and 4:00 PM ET.

Sproc to shrink transaction log

This script creates a stored procedure to shrink the transaction log in the database it is created in. The stored procedure shrinks each transaction log file in the database, to the size specified.

In the Trenches: Getting the Most Out of SQL Server

This e-seminar will discuss how Quest's performance diagnostic solutions for SQL Server can help you get the most out of your database. Learn, through real-world scenarios, how to increase database performance and ensure optimal availability of your SQL Server environment. This free e-seminar will teach you how to:

* Proactively diagnose and resolve bottlenecks
* Ensure high levels of performance and availability
* Maintain SLAs

Reader's Choice Award Winners Announced

Thanks to the more than 1,300 people that voted in the 2002 SQLserverCentral.com Reader's Choice Awards. Now that the voting is complete, find out who you voted to be the best SQL Server product and book.