Category: SQL Server

Stupid SQL Things To Do: Backup to NUL

Occasionally I’ve come across a site where backups are taken to disk = ‘NUL’. Note that’s NUL with 1 L and not NULL with 2 L’s. I’ve seen it recommended in a few places online as a quick fix where a log file has grown out of control and at least one SQL backup utility actively uses it under the guide of ‘truncating the transaction log’.

Read More →

Nelson SQL Server User Group

Wanted to take a moment to announce the great news that Nelson now has it’s own SQL Server User Group.  You can join in at the Nelson SSUG page. Even better news is we have Paul Randal lined up as our first presenter.  The session is at 6pm on the 17th September at the #GIGATOWNNSN […]

Read More →