Free Stuff - Category Archive
The following is a list of all entries from the Free Stuff category.
Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3
Database Maintenance, Free Stuff | November 26, 2009 | 10:31 amOla 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
Database Administration, Free Stuff, PASS, SQL Server News | November 7, 2009 | 2:01 pmYou 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
Books, Conferences, Free Stuff, PASS | November 1, 2009 | 7:52 pmRed 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
Database Administration, Free Stuff | October 27, 2009 | 12:12 pmWhile 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”
Books, Database Administration, Free Stuff | October 22, 2009 | 10:10 pmRodney 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
Books, Database Administration, Free Stuff | October 15, 2009 | 8:44 pmWhether 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
Database Administration, Database Maintenance, Free Stuff, Performance Tuning | October 13, 2009 | 5:36 pmI 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
Database Administration, Database Maintenance, Free Stuff | September 23, 2009 | 9:01 amGreg 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.
