Elegant Software Solutions' Blogs: Tom Hundley

Author:	Thomas Hundley	Created:	4/21/2007 12:22 AM
This blog will be used to post technical problems and solutions that we have encountered with SQL Server.

KB948109 Security Hotfix Fails

By Thomas Hundley on 7/12/2008 9:19 PM

A security update from MS broke the production server for the first time in who knows how long. The automatic installation of the hotfix for KB948109 failed and messed the SQL services up. I rebooted and tried to reinstall it and the same thing happened, although this time simply restarting SQL worked to fix it.

I'm going to look into this a bit later and get it fixed on but wanted to throw this up on the blog. It also brought to light that I need to get a monitoring system put back on this server. I used Alert Site in the past and they were great and were reasonably priced, so I'll probably go with them again.

Anyway, cheers for now... Tom Hundley Elegant Software Solutions, LLC

...

Comments (1)

Truncate SQL Transaction Log and Shrink Database

By Thomas Hundley on 6/14/2008 8:48 PM

I only need to do this every so often, but I always forget how to and end up looking it up. Thus, I'm posting it here for reference.

USE DatabaseName

GO

BACKUP LOG DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(TransactionLogName>, 1)

Tom Hundley Elegant Software Solutions, LLC

...

Comments (1)

Rebuild all Indexes in SQL Database

By Thomas Hundley on 6/14/2008 8:39 PM

Here is a script to rebuild all of your indexes on your database. I find that indexes are often ignored once an application moves to production. It's a good idea to evaluate your usage patterns and setup automated maintenance jobs to proactively rebuild indexes before fragmentation has a chance to adversely effect performance. This is especialy important if you are using guids as primary keys and don't move the clustered index to a more logically sequential column.

-- Show fragmentation for all tables EXEC sp_MSforeachtable @command1="print '?' DBCC SHOWCONTIG('?')"

--Rebuild all indexes (note this method locks the tables while the indexes are being rebuilt)

USE [myDatabase]

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM information_schema.tables

WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName

...

Comments (0)

Connecting to SQL Server 2005 with SSL

By Thomas Hundley on 2/3/2008 4:12 PM

Did you know you can connect to SQLServer from your application using SSL?

Comments (0)

Microsoft SQL Sever 2005 Encryption

By Thomas Hundley on 2/3/2008 4:10 PM

Quick reference to the Microsoft SQL Server 2005 Whitepaper

Comments (0)

Editing existing SSIS Packages in SQL Server 2005

By Thomas Hundley on 4/21/2007 12:44 AM

Viewing and editing an existing SSIS package is limited to SQL Server Business Intelligence Development Studio (SSBIDS) or Visual Studio 2005 Team Suite (VSTS).

Comments (0)

Finding SSIS Packages in SQL Server Management Studio (SSMS)

By Thomas Hundley on 4/21/2007 12:42 AM

I used SQL Server Integration Services (SSIS) Import & Export Wizard from SQL Server Management Studio (SSMS) to create an SSIS package and saved it to the server. I beat my head against the wall trying to find it via SSMS after I saved it.

Comments (0)