Archive for August, 2009

How to Load Test a Stored Procedure with Benchmark Factory

Posted 8/24/2009 at 1:37 PM by Brent Ozar

Quest’s Benchmark Factory load tests your stored procedures and your database server to find out how many users you can support.  Learn how to set up a stored procedure load test in this 8-minute video.

Get the Flash Player to see the wordTube Media Player.

Check for Weak SQL Server Passwords with Discovery Wizard

Posted 8/24/2009 at 1:29 PM by Brent Ozar

Some SQL Server instances are set up with the username SA and a blank password.  In other shops, previous DBAs used easy-to-guess back door accounts to make management easier.  To secure your environment, you can use Quest’s free Discovery Wizard to look for common usernames and passwords.  In this short video, we show you how to get started.

Get the Flash Player to see the wordTube Media Player.

Introduction Tutorial for Quest Discovery Wizard

Posted 8/24/2009 at 1:28 PM by Brent Ozar

How many SQL Servers are in your datacenter?  Find out fast with Quest’s free Discovery Wizard.  In this short video, we show you how to get started.

Get the Flash Player to see the wordTube Media Player.

Capture an Inventory Baseline with Discovery Wizard

Posted 8/24/2009 at 1:27 PM by Brent Ozar

Keep track of your ever-changing SQL Server inventory with Quest’s free Discovery Wizard.  In this short video, we show how to set a baseline and find out when servers have been added, removed or changed.

Get the Flash Player to see the wordTube Media Player.

How to Find Out Where LiteSpeed Is Installed with Discovery Wizard

Posted 8/24/2009 at 1:18 PM by Brent Ozar

Quest’s free Discovery Wizard tool helps you discover and report on your SQL Server instances.  One of the things it checks is for the installed version of Quest LiteSpeed for SQL Server.  If you need to find out where LiteSpeed is installed, watch this short tutorial video to learn how.

Get the Flash Player to see the wordTube Media Player.

Recovering a Single Table From a Backup with LiteSpeed

Posted 8/24/2009 at 12:55 PM by Brent Ozar

Need to recover just one table?  Or maybe someone dropped a stored procedure?

LiteSpeed’s Object Level Recovery helps you restore individual objects from a SQL Server backup – either native or LiteSpeed.  Brent Ozar shows how in this short video.

Get the Flash Player to see the wordTube Media Player.

How to Restore a Database with LiteSpeed for SQL Server

Posted 8/24/2009 at 12:38 PM by Brent Ozar

LiteSpeed’s built-in wizards make it easy to restore a database.  No matter what combination of full backups, differential backups, and transaction log backups are involved, it’s point-and-click easy.  LiteSpeed even generates the right combination of RESTORE DATABASE scripts.  Brent Ozar shows how in this short video.

Get the Flash Player to see the wordTube Media Player.

Welcome to the Inside Quest: SQL Server blog.

Posted 8/18/2009 at 1:58 PM by admin

Welcome to the Inside Quest: SQL Server blog.  Here, you’ll find video tutorials, user tips, and inside information about Quest Software’s database management products like LiteSpeed for SQL Server, Toad for SQL Server, Capacity Manager, Change Director, and more.