The Brisbane Sharepoint User Group had their inaugural meeting Yesterday. The group plan to meet between 12:00-13:30 on the 2nd Wednesday of each month.
Microsoft SQL Server Management Studio Express provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances.
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:
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: