SQL Aloha

Searching for Objects or Text Strings Using SQL Search

As a DBA, at one time or another, you will need to quickly find an object within a database, such as a table, view, or stored procedure. In other cases, it is handy to be able to search objects to locate specific text strings. Depending on which version of SQL Server you are using, you ...read more

SQL Search 1.0 Beta Available

Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you to easily search for “text strings”, allowing you to quickly find objects stored within a SQL Server instance.

Have You Checked Out the Upcoming SQLSaturday Events for 2010?

2010 is beginning to look like a great year for SQLSaturday events this year. Already, there are nine planned, and many more in the works. These free, one-day events are a great way to hone your DBA knowledge, and to develop new contacts. If you are interested in speaking at an event, its also ...read more

Free Tool for SQL Server Encryption Key Management

Devenius Software is offering a free tool to help you manage SQL Server encryption keys. Its called the SQL Encryption Assistant (Basic Edition), and it allows you to create, modify, and drop encryptions keys and certificates. There are two versions of the software, one each for SQL Server 2005 and SQL Server 2008.
Devenius Software is ...read more

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