For those that missed the Steve Ballmer Keynote for the release of SQL Server 2005, Visual Studio 2005, and BizTalk Server 2006 it can be viewed from the following link:
Author Archives: WARDY IT Solutions
The example below shows a workaround for a Divide by zero error encountered. error by using the NULLIF Function.
The October edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The Date for Monday and Friday of the current week can be determined as illustrated below.
SELECT GETDATE() + (2 – DATEPART(WEEKDAY, GETDATE())) AS MONDAY,
After a long wait the final build of SQL Server 2005 was released to manufacture (RTM) last Friday (28th October 2005).
Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog.
The installation path for SQL Server 2000 can be determined using the undocumented sp_msget_setup_paths Stored Procedure.
Below is an example of how to use a Trigger to audit who updated, deleted or inserted data. The trigger also captures the old and new values when an update is performed:
The September edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The SQL Script below can be used to remove non-printable characters from a string such as CRLF etc.