Tony Rogerson's ramblings on SQL Server

Relational Database pioneer Chris Date is giving a seminar 13th/14th May Edinburgh on "SQL and Relational Theory - How to Write Accurate SQL Code"

tonyrogerson — Mon, 15 Mar 2010 07:21:00 GMT

One of the pioneers of the Relational Database, Chris Date is giving a 2 day seminar in Edinburgh (13th and 14th May 2010) based around his new book "SQL and Relational Theory - How to Write Accurate SQL Code" which if you don't already...(read more)

Database Design - Surrogate keys: Part 1 of many (Rules for Surrogate Keys, E. F. Codd and C J Date research and problems they solve)

tonyrogerson — Sat, 13 Mar 2010 13:42:00 GMT

I started writing an article for my blog on surrogate keys drawing in the original research by E F Codd and C J Date, its getting a bit big :) so I'm going to chop it up into a number of posts over the coming weeks depending on my time. I'm interested...(read more)

What is Granularity?

tonyrogerson — Fri, 05 Mar 2010 15:02:00 GMT

Granularity defines “the lowest level of detail”; but what is meant by “the lowest level of detail”? Consider the Transactions table below: create table Transactions ( TransactionID int not null primary key clustered, TransactionDate date not null, ClientID...(read more)

2 Hours spent trying to get Visual Studio 2008 to Build my project off a server mapped drive in Windows 7

tonyrogerson — Thu, 25 Feb 2010 18:25:00 GMT

Ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh I am so "unhappy" {toned down} that this is not more clear and perhaps even something built into the dam product. I got this error on build: Error 1 'Request for the permission...(read more)

UK Tech-Days 2010 Registration is up there now - a day on SQL Server 2008 R2

tonyrogerson — Wed, 17 Feb 2010 17:30:00 GMT

Get in quick because this will fill up: http://www.microsoft.com/uk/techdays/Registration.aspx Event Overview This is the UK launch event for SQL Server 2008 R2. The R2 release showcases Microsoft’s continued commitment to business intelligence and mission...(read more)

UK SQL UG - Meetings in Cardiff, Edinburgh, Manchester, London - Online stuff; Social evenings starting - get involved!

tonyrogerson — Mon, 15 Feb 2010 20:56:00 GMT

Already into February and after a nice long break we are ramping up the user group meetings again - physical and offline. There is a lot coming up in 2010 including the R2 release in May which should be good; lots of new tools on the market especially...(read more)

How to create a One to One relationship in SQL Server using DRI, Triggers and Views

tonyrogerson — Sat, 23 Jan 2010 10:36:00 GMT

It's beyond me to create a one to one relationship in SQL Server if you are inserting directly into the related tables; in this article I discuss just how you go about actually implementing a workable one to one relationship. Please feel free to comment...(read more)

Dundee SQL User Group Meeting this Wed (20 Jan 10) - Tony Rogerson and Allan Mitchell

tonyrogerson — Mon, 18 Jan 2010 08:20:00 GMT

Allan Mitchell and I are starting our Business Intelligence Masters this week at the University of Dundee, as we are up here anyway it seemed a good idea to put on a user group meeting, so, details below - it's this Wednesday in the Queen Mothers...(read more)

Removing blank line in SSMS (Management Studio) Find and Replace dialogue

tonyrogerson — Mon, 11 Jan 2010 08:20:00 GMT

Yes, copying between word and email always puts an extra line between code lines which makes the code hard to read. The answer is simple; in Management Studio go into Find and Replace, in "Find Options" check "Use" and select "Regular...(read more)

Tonights London UG meeting - starts at 5.30pm; 6 sessions of content from 15 mins - 45 mins

tonyrogerson — Thu, 26 Nov 2009 07:53:00 GMT

You are registered for tonights London UG, if you are not coming then please unregister now so I don't send you a bill for £20! The agenda tonight is cracking - so much going on, so much in fact we have to start early tonight - don't worry though...(read more)

Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping what's happened

tonyrogerson — Tue, 24 Nov 2009 15:19:00 GMT

Table Variables are not Transactional, that is to say BEGIN TRAN....ROLLBACK has no effect on them; we can use that to our advantage. Have you ever been in the situation where you use a log file within your application to log progress, unfortunetly because...(read more)

This Thurs - London SQL UG, also Edinburgh SQL UG

tonyrogerson — Tue, 24 Nov 2009 12:57:00 GMT

This Thursday 26th is the London SQL User Group and also the Edinburgh UG; in London we have Tony Rogerson doing a session on Internals Basics aimed at people who aren't experts but will likely benefit as a reminder for those who are, we have a Nugget...(read more)

SQL 2008 SP1 CU5 is now out and fixes the OPTION(RECOMPILE) Parameter Embedding Optimisation problem - properly!

tonyrogerson — Wed, 18 Nov 2009 08:59:00 GMT

SQL Server 2008 SP1 Cumulative Update (CU5) link: http://support.microsoft.com/kb/975977/LN/ Details on how they have fully fixed the OPTION( RECOMPILE ) Parameter Embedding Optimisation : http://support.microsoft.com/kb/976603/ What is Parameter Embedding...(read more)

SQL Server Virtualisation - Licencing, Management, Performance and Support

tonyrogerson — Mon, 02 Nov 2009 11:43:00 GMT

Andrew Fryer has done a number of blog posts on Virtualisation for DBA's for SQL Server - very good and informative. http://blogs.technet.com/andrew/archive/2009/10/16/virtualisation-for-the-dba-part-1-are-you-bovvered.aspx http://blogs.technet.com...(read more)

London UG this Thurs (29th Oct) on BI - Deploying SSRS Reports using MSBuild, WhereScape and BI 2.0 - I'm searching give me a minute.

tonyrogerson — Tue, 27 Oct 2009 07:58:00 GMT

This Thursday 29th is the London SQL User Group at Microsoft where we have Jamie Thomson talking about "Deploying SSRS Reports using MSBuild", we have one of our meeting sponsors Steve Hitchman from WhereScape demonstrating their Data Warehouse...(read more)