Tara Kizer Blog

Tara Kizer

Backup transaction log stored procedure

EDIT: This stored procedure has been updated. The below stored procedure will backup the transaction log for each of the databases that aren't being log shipped (you don't want to break log shipping by running a transaction log backup outside of the log shipping plan) and also aren't using SIMPLE for the recovery model. Read more →

SQL Server Yukon CLR for the DBA

PASS Webcast: SQL Server Yukon CLR for the DBA   Tuesday, June 15, 2004 (12:00 pm EDT) In this session you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Read more →

Reporting Services Tip #1

I've been working on SQL Server 2000 Reporting Services for the past couple of weeks. I plan on blogging about my experience by providing tips. Reporting Services Tip #1: If you've created a report that you would like to deploy to a server without using Report Designer, you can upload the rdl file in Report Manager. Read more →

It's hot here!

Well it's over 90 degrees in San Diego, CA this week. I went to the beach yesterday to escape the heat as did thousands of others (I should have sold my parking spot when I left). Read more →

xp_cmdshell

Why is it that you can pass a built string to xp_cmdshell but you can't build your string at the same time. What I mean is this: This is legal: Read more →

Analog Clock

Duane Dicks has a script that can display an analog clock in Query Analyzer. Make sure your results are in text and your font is Courier. Read more →

SQL Server Books Online January 2004 Update

MS updated SQL Server 2000 Books Online again: http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en Legacy Comments DavidM 2004-01-21 re: SQL Server Books Online January 2004 Update Thanks Tara! Marcus Tucker 2004-01-24 re: SQL Server Books Online January 2004 Update Thanks for the heads-up! Read more →

MSDN Webcast: Microsoft Tools for .NET Performance Tuning

This webcast wouldn't benefit me (I'm a DBA), but... MSDN Webcast: Microsoft Tools for .NET Performance Tuning 1/28/200411:00AM-12:30PM Pacific Time, US & Canada (GMT-8)David McKinstry, Senior Consultant, BORN Applications are usually developed with specific performance and scalability requirements in mind. Read more →

DBCC DBREINDEX

There are several things that a DBA sets up in a production environment, one of these things is rebuilding the indexes. This is done with DBCC DBREINDEX. Some systems can not afford the locks that are held for long periods of time with DBCC DBREINDEX so they use DBCC INDEXDEFRAG instead. Read more →