December 2005 - Posts

• December SQL Server Newsletter

  The December edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/dec2005.htm Read More... Posted Monday, December 26, 2005 11:32 AM by admin | (Comments Off)

• Shrinking the Transaction Log with DBCC SHRINKFILE

  The following Microsoft KB article details how to shrink a Transaction Log using DBCC SHRINKFILE http://support.microsoft.com/kb/272318/en-us . Read More... Posted Friday, December 23, 2005 11:35 AM by admin | (Comments Off)

• SQL Server 2005 System Table Map

  The SQL Server 2005 System Table Map shows the system tables included in SQL Server 2005, and the relationships between them. A PDF version of the system table map can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en Read More... Posted Thursday, December 22, 2005 11:13 AM by admin | (Comments Off)

• SQLDMO Script SQL Server Jobs

  The following VBScript code snippet can be used to script all SQL Server Jobs on a SQL Server instance: ~~ Const ForWriting = 2 Dim job Dim oFSO Dim oFSOWrite Dim oSQLServer Set oFSO = CreateObject("Scripting.FileSystemObject") Set oSQLServer = CreateObject("SQLDMO.SQLServer") Read More... Posted Tuesday, December 20, 2005 3:25 PM by admin | (Comments Off)

• Scan an IP Range for SQL Server Instances

  There are other tools such as SQLPing ( http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26 ) that can be used to scan an IP address range for SQL Server instances. However if you need to also accurately determine the build of each SQL Server instances Read More... Posted Monday, December 19, 2005 9:39 AM by admin | (Comments Off)

• SQL Wish Email Alias

  For as long as I can remember the sqlwish@microosft alias has been used for submitting features and ideas to the Microsoft SQL Server team. However I noticed that Greg Low has a blog post http://msmvps.com/blogs/greglow/archive/2005/12/14/79146.aspx that Read More... Posted Friday, December 16, 2005 9:59 AM by admin | (Comments Off)

• Creating a Deadlock

  Below are the steps to generate a deadlock so that the behaviour of a deadlock can be illustrated: -- 1) Create Objects for Deadlock Example USE TEMPDB CREATE TABLE dbo.foo (col1 INT) INSERT dbo.foo SELECT 1 CREATE TABLE dbo.bar (col1 INT) INSERT dbo.bar Read More... Posted Monday, December 12, 2005 11:00 AM by admin | (Comments Off)

• SQL Server 2005 BOL Update (December)

  An update to the SQL Server 2005 Books Online (BOL) has been released and can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en Read More... Posted Sunday, December 11, 2005 8:29 PM by admin | (Comments Off)

• November SQL Server Newsletter

  The November edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/nov2005.htm Read More... Posted Thursday, December 01, 2005 11:49 AM by admin | (Comments Off)