The December edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
Monthly Archives: December 2005
The following Microsoft KB article details how to shrink a Transaction Log using DBCC SHRINKFILE http://support.microsoft.com/kb/272318/en-us.
The SQL Server 2005 System Table Map shows the system tables included in SQL Server 2005, and the relationships between them.
The following VBScript code snippet can be used to script all SQL Server Jobs on a SQL Server instance:
There are other tools such as SQLPing (sqlsecurity.com/DesktopDefault.aspx?tabid=26) that can be used to scan an IP address range for SQL Server instances.
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.
Below are the steps to generate a deadlock so that the behaviour of a deadlock can be illustrated:
— 1) Create Objects for Deadlock Example
An update to the SQL Server 2005 Books Online (BOL) has been released and can be downloaded from http://www.microsoft.com/
The November edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.