With just over 3 months until Tech-Ed Australia early bird booking have opened. Tech-Ed is being held on the Gold Coast from the 7th-10th of August.
I recently came across a scenario where the description in a column was being stored in a comma delimited column as illustrated by the Products table below.
The March 2007 edition of the WARDY IT Solutions SQL Server Newsletter has been e-mailed to everyone on the distribution list.
Common Table Expressions (CTE’s) are a new structure in SQL Server 2005 that can be used to assist with performing recursive operations.
The WARDY IT Community Dinner is a great opportunity to network with other IT professionals in order to share knowledge, information and experiences.
If you have already installed SQL Server 2005 Service Pack 2 it is recommended that you apply the Critical Update referenced in KB933508.
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.
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.
The February 2007 edition of the WARDY IT Solutions SQL Server Newsletter has been e-mailed to everyone on the distribution list.
In SQL Server 2000 setting a trace flag was really obvious. In Enterprise Manager you could right click on a Server and select properties and then add a Startup Parameter.