March 2007 - Posts

• Find Gaps in a Range

  Common Table Expressions (CTE's) are a new structure in SQL Server 2005 that can be used to assist with performing recursive operations. The following example demonstrates how a CTE can be used to find the gaps in a range. Consider the following table: Read More... Posted Wednesday, March 28, 2007 12:47 PM by peter@wardyit.com | 0 Comments

• April WARDY IT Community Dinner

  The WARDY IT Community Dinner is a great opportunity to network with other IT professionals in order to share knowledge, information and experiences. The April WARDY IT Community Dinner is being held on Monday the 16th of April. To RSVP to be at this Read More... Posted Wednesday, March 28, 2007 12:44 PM by peter@wardyit.com | 0 Comments

• Critical Update for SQL Server 2005 SP 2

  If you have already installed SQL Server 2005 Service Pack 2 it is recommended that you apply the Critical Update referenced in KB933508 http://support.microsoft.com/kb/933508 . There is an issue in SP2 that causes maintenance plan cleanup tasks to remove Read More... Posted Wednesday, March 07, 2007 6:20 AM by peter@wardyit.com | 0 Comments

• GRANT EXECUTE to all Stored Procs

  Often when a new login has been created and the user mapped to a login the next step is to grant EXECUTE to all Stored Procedures in a database. The following script illustrates how to generate a script to that will grant EXECUTE on all Stored Procedures Read More... Posted Tuesday, March 06, 2007 3:02 PM by peter@wardyit.com | 0 Comments

• SQL Server Virtualization Licensing

  More and more organisations are looking at Virtualization as a solution to managing the growth in the number of SQL Server instances that today's IS departments need to support. However there is still a lot of confusion surrounding the licensing for virtualized Read More... Posted Thursday, March 01, 2007 12:20 PM by peter@wardyit.com | 0 Comments