Welcome to EMC Consulting Blogs

July 2008 - Posts

• SQLBits III - Registration is open!!!

  This morning the guys opened up registration for SQLBits III to be held in Hatfield on 13th September. In an incredible morning there has been over 100 successful registrations on the site - that's great going over 25% full on day 1. Just to remind you Read More... Posted 18 July 2008 14:33 by James.Rowland-Jones | 1 Comments Filed under: SQLBITS, Community, UK SQL Server User Group

• ISNULL() <> COALESCE(). Discuss.

  Crikey.  That title sounds like an essay I had to write when I was at school and that was a long time ago... Jamie Thomson raised an important point in a comment on a blog I posted yesterday entitled " Getting rid of getdate() ".  Read More... Posted 18 July 2008 10:30 by James.Rowland-Jones | 4 Comments Filed under: Database Development, SQL Server, T-SQL

• Here and Now()

  AAAaaaaah...Yesterday was just one of those days.  I was trying to do something very simple in a script task - assign the current datetime value to one of my variables - and was pulling my stubbly hair out trying to do it. I am happy to confess to Read More... Posted 17 July 2008 10:39 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, SSIS, Database Development, .NET

• Getting rid of Getdate()...

  Ok I admit - I use it. Pretty much everyone I know uses it and yet I feel dirty when I do.  Why? Well it's not portable SQL and most certainly not ANSI standard.  I need to get the datetime I hear you say.  How do I do this without getdate()?  Read More... Posted 17 July 2008 10:32 by James.Rowland-Jones | 3 Comments Filed under: Database Development, SQL Server, SQL, T-SQL

• SQL Server Database Recovery Model: How do you set yours?

  We had the classic situation come up on a project the other day.  The recovery models on the databases were set to full and yet the backup strategy didn't reflect this.  Needless to say, we ran out of disk space on our build server.  In Read More... Posted 15 July 2008 10:07 by James.Rowland-Jones | 4 Comments Filed under: SQL Server, Database Administration

• Synchronous and Asynchronous Shopping

  A couple of days ago I was asked to explain the difference between synchronous and asynchronous I/O.  This was something that I covered last year at SQLBits II in my presentation " I/O! I/O! It's off to work we go... ". However, when I Read More... Posted 11 July 2008 10:06 by James.Rowland-Jones | 1 Comments Filed under: SQL Server, SQLBITS, Community, I/O

• SQL Security Patch Build is CU6+ but not quite CU7

  So as suspected when I installed the new Security patch released by Microsoft for SQL 2005 sp2 that I mentioned this morning my build number has indeed shot up to 3233.  This places me somewhere between CU6 and CU7. Build 9.00.3228 was CU6 and 9.00.3239 Read More... Posted 10 July 2008 11:40 by James.Rowland-Jones | 4 Comments Filed under: SQL Server 2005, sp2, SQL Server, Security

• SQL Server and Windows Security patch posted

  And so the great run comes to an end... For the full details of this incident please click here . N.B. This also affects Windows. However this is released under a different KB article. For the SQL 2005 sp2 KB article look at this link http://support.microsoft.com/kb/948108 Read More... Posted 10 July 2008 09:33 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, sp2, SQL Server, Security

• Resources for Spatial Data in SQL Server 2008

  As you may be aware we recently hosted a meeting of the UK SQL Server User Group featuring Michael Rys . For those of you who weren't able to jot down the resources he mentioned in his presentation I have copied and pasted them in below. Thanks to Michael Read More... Posted 09 July 2008 09:14 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, Community, SQL Server 2008, UK SQL Server User Group, Spatial Data

• VISIO 2007 add-in for SQL Server Infrastructure Diagrams

  Here's a little freebie from Microsoft for those of you who have the job of drawing out infrastructure diagrams of SQL Server farms. Ok that already sounds like a pretty niche market.  How about here's a little freebie from Microsoft for those of Read More... Posted 09 July 2008 00:33 by James.Rowland-Jones | 2 Comments Filed under: SQL Server, Database Administration

• Using a Bitmask - a practical example

  A colleague of mine asked for a simple example to get him up and running with the basics of bitmasking.  Since I had gone to the effort to create the example I thought I might as well blog it :o). This example uses the logical AND operator &. Read More... Posted 04 July 2008 23:28 by James.Rowland-Jones | 3 Comments Filed under: Database Development, SQL Server, SQL, T-SQL

• SQLBits III Session Submissions Deadline Update

  In an earlier post I mentioned that the 4th July had been set as the deadline for submission of session abstracts.  This deadline has now been extended till July 11th as there are still a number of people who we are waiting to hear from.  For Read More... Posted 04 July 2008 21:40 by James.Rowland-Jones | 0 Comments Filed under: SQL Server, SQLBITS, Community, SQL Server 2008, UK SQL Server User Group

• Spatial Data Eye Candy

  In an earlier post I mentioned the new visualisation functionality for spatial data.  Michael Rys kindly pointed me in the direction of Isaac's blog that has some pictures of the new "Spatial Data" tab and resulting visualisation.  Read More... Posted 04 July 2008 09:40 by James.Rowland-Jones | 0 Comments Filed under: Database Development, SQL Server, SQL Server 2008, Spatial Data

• Want an XBOX 360 for free? Then enter the SQLBits Logo Competition...

  That's right! The prize for coming up with the winning logo for SQLBits is an XBOX 360! Not only do you get the console but also the satisfaction of seeing your logo emblazoned across the internet and also (hopefully) sunny Hertfordshire on 13th September Read More... Posted 03 July 2008 18:35 by James.Rowland-Jones | 1 Comments Filed under: SQLBITS, Community, UK SQL Server User Group

• T-SQL IDENTITY : Fun and Games with DBCC CHECKIDENT

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       Read More... Posted 03 July 2008 18:26 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, Datadude, Database Edition, SQL, T-SQL

• Conchango hosts UK SQL Server User Group with Michael Rys

  Monday 30th June 2008. On Monday evening we were very fortunate to have Michael Rys present to the UK SQL Server User Group hosted at Conchango's offices here in London.  Michael has one of the longest job titles I have ever seen.  He's the Read More... Posted 03 July 2008 09:42 by James.Rowland-Jones | 1 Comments Filed under: SQL Server 2005, Community, SQL Server 2008, UK SQL Server User Group Attachment(s): June30.zip