SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Some Useful Undocumented SQL Server 2000 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000. Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can […]

Manage Multiple SQL Server Installations and Databases with OSQL

At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will show you […]

Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)

Over the last few years, I have been a roving SQL Server DBA contractor, tending to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I […]

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator’s Guidebook

Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to this book, he has authored an article on […]

Understanding SQL Server’s DBCC SHOWCONTIG

DBCC SHOWCONTIG is a wonderful tool which helps you to understand quite a bit more about your system than is obvious at first glance. And, frankly, the documentation doesn’t use terminology that makes it very obvious either. So, this article will focus on a few of the big ideas behind the tool using SQL Server, […]

Some Useful Undocumented SQL Server 7.0 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 7.0 trace flags, and how you can use them for administration and monitoring. Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set trace flags by […]

Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands

In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring.DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they […]

Who Needs SQL Server Change Management?

You’ve spent thousands of dollars on that cool technology; clustering, redundant controllers, redundant disks, redundant power supplies, redundant NIC cards, multiple network drops, fancy tape backup devices, and the latest and greatest tape technology. You’re all set. There’s no way your going to have downtime. But one day something does go wrong, is it the […]

How to Script User and Role Object Permissions in SQL Server

From time to time, I need the ability to “reverse engineer” SQL Server object permissions, for either users or roles, from one database, and then “move” them to another version of the database on another server. For example, I have a development database which developers use to experiment with various Visual Basic applications they write. As […]

Auditing Your SQL Server Environment Part I

Over the last few years, I have been a roving SQL Server DBA contractor, tending to work contacts in small and mid-size companies that involved organizing, documenting and tuning/optimizing existing SQL Servers in those companies. During this time, I have noticed one very disturbing truth over the years; no one seems to document anything. In […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |