SQLServerCentral.com Content tagged SQL Server 7, Other

Real World Query Plans

Thu, 09 Jun 2005 06:00:00 UT

The SQL Server 2000 Query Optimizer is one of the more complicated things that a SQL Server DBA deals with. For most of us, we just let it work and do not give it a second thought. But when a crisis occurred, Andy and Steve had to dive in to learn a few more things about it.

SQL Server Needs Incremental Updates

Thu, 29 Apr 2004 06:00:00 UT

Although Brian likes that Microsoft delayed the next release of SQL Server for quality, he disagrees with the release strategy. See his opinion and argue your own!

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

From the soapbox: Does anyone know what disaster recovery is?

Wed, 28 Jan 2004 07:00:00 UT

New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think.

Point-Counterpoint - Why you Should be Certified.

Tue, 13 Nov 2001 07:00:00 UT

In this view, Steve thinks that certifications are invaluable (especially in this economy).

Removing NT Administrators as Sysadmins

Fri, 25 May 2001 06:00:00 UT

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.

Compare and sync databases with SQL Compare
“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.

Keeping Your Developers Under Control

Wed, 25 Apr 2001 06:00:00 UT

Everyone needs a stable environment. This article discussed ways to keep your team on the same page.