SQL Aloha

Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3

Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of SQLBackup 6.3.
For those of you who are not familiar with Ola’s database maintenance scripts, they are designed to help you backup, optimize indexes, and perform integrity checks on all your databases. These are highly polished ...read more

Give SQL Server 2008 R2 CTP a Quick Try for Free

You have probably heard that the SQL Server 2008 R2 CTP is available, but you may not have given it a try yet because it is such a pain to download the huge install file, find a test server to run it on, and then install it. Under the best of conditions, this is at ...read more

Free Books at Red Gate Booth at PASS Summit

Red Gate Software will be handing out a limited number of free paperback books at their booth at the 2009 PASS Community Summit. They include:

Protecting SQL Server Data by John Magnabosco
SQL Server Tacklebox by Rodney Landrum
How to Become an Exceptional DBA by Brad M McGehee

If you can’t make the PASS Summit, or the booth runs ...read more

Get Your SQL Server Questions Answered at ASK.SQLServerCentral.com

While the SQLServerCentral.com forums have always been a popular way to get your SQL Server questions answered, and to participate in the greater SQL Server Community, SQLServerCentral.com is now offering a new feature called Ask.SQLServerCentral.com, which is a new way to find answers to your SQL Server questions. You can either find a question that ...read more

Download the Free eBook “The SQL Server Tacklebox”

Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts for the Day-to-Day DBA. This 240 page book, and accompanying scripts, is chock full of advice for DBAs, from novice to experienced.

Free E-Book on XSD SQL Server Schema Collections

Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about XML and XSD (XML Schema Definition Language). XML has become, and continues to grow, as a popular format for exchanging data. If you are not up to speed on this technology, check out the ...read more

Free T-SQL Database Maintenance Scripts

I often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There seem to be a lot of DBAs who need more flexibility than what the Database Maintenance Wizard offers to perform database maintenance, which means they must user either T-SQL or PowerShell scripts in order to ...read more

Free SQL Server Dashboard

Greg Larsen, a SQL Server DBA, and the owner of the website SQLServerExamples.com, has released a free plug-in for SSMS called the SQL Server DBA Dashboard. The useful tool produces a multitude of reports to help both DBAs and Developers in their quest to see inside of SQL Server, and how it is performing.