I have recently been re-listening to some of the older .Net Rocks (http://www.dotnetrocks.com) episodes whilst travelling to a remote client site.
Category Archives: SQL Server
The example below illustrates how to UNPIVOT a table. The example can be used in both SQL Server 2000 and 2005.
A question I have been asked a lot lately is “where has the Import Export Wizard gone in SQL Server 2005”.
The April 2006 edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The Microsoft Knowledge Base Article 246133 – How to transfer logins and passwords between instances of SQL Server details how to create the Stored Procedure sp_help_revlogin.
One of the emails I received whilst on leave was asking if it is possible to check if a database has been marked suspect using SQLDMO.
I will be attending the Queensland SQL Server User Group on Thursday the 27th April 2006 to present on the SQL Management Object (SMO).
Often the use of an auxiliary table can assist you to write more efficient code than a solution that doesn’t.
The Community Technology Preview (CTP) of SQL Server 2005 Service Pack 1 is now available for download from http://www.microsoft.com/sql/ctp_sp1.mspx.
A question that was asked during the SMO presentation in Adelaide last week was how to use the Replication Management Object (RMO) in SQL Server 2005 to programmatically control replication.