Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.   Read more...

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.   Read more...

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...

Check constraints can be added to a table to enforce specific rules on one or more columns. This article shows you how to use them to enforce simple and more complex rules.   Read more...

If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!   Read more...

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.   Read more...

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.   Read more...

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...

SQL Server DBAs are often curious about the inner-workings of SQL Server. Indeed, it can save your job during disasters to know what's going on inside SQL Server. This article shows you how to use some of the SQL Server internal views to view some meta data about your servers.   Read more...

Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.   Read more...

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...