Cross-posted from a Goal Keeping DBA blog: Just recently, my oldest son entered the ranks of the teenagers. I shouldn’t actually...  Read more...

After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...  Read more...

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...

After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.  Read more...

Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...  Read more...

We often take the advice given to us on forums or in articles at face value. Even though the authors...  Read more...

Our home desktop was several years old and due for replacement. I still have my Dell laptop, and it's still more than...  Read more...

We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.  Read more...

I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...  Read more...

Inside the SQL Server Tacklebox you'll find day-to-day tools and techniques to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to your servers and fight off the data corruption monster.  Read more...

New author Jason Crider brings us a few tricks and tips that can help you be a more efficient DBA, or a more efficient employee in general using technology.  Read more...

After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.  Read more...

This 3-part sponsored article surveys several different methodologies for database development, examines their strengths and weaknesses, and illustrates how Red Gate's comparison tool, SQL Compare, can be incorporated into each model.  Read more...

This 3-part sponsored article surveys several different methodologies for database development, examines their strengths and weaknesses, and illustrates how Red Gate's comparison tool, SQL Compare, can be incorporated into each model.  Read more...

This video by Richard Waymire will describe how to install and configure SQL Server 2005 to support Visual Studio Team Edition for Database Professionals database projects.   Read more...

Mairead introduces you to how to create your database project using the latest edition of Visual Studio Team System - Team Edition for Database Professionals. Check out this quick 10 minute demo to get a whirlwind tour of project creation within VSTE for DB Pro.   Read more...

In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.   Read more...

SQL Server 2005 comes with a built-in answer to this problem: the Database Engine Tuning Advisor. Combining a simple user interface with a deep knowledge of SQL Server, this utility can help you tune your databases for peak performance.  Read more...

SQL Server 2005 has deprecated osql and isql as command line tools and replaced them with SQLCMD. Haidong Ji brings us an introduction to this new tool and a few tricks to make you more productive when using it.   Read more...