-
SQL Saturday Edinburgh Agenda...
-
Presentation and Slides from the Leeds User Group 7th May...
-
Introduction As all of us do when confronted with a problem, the resource of choice is to ‘Google it’. This is where the plot thickens. Recently I was asked to stage data from numerous databases which were to be loaded into a data warehouse. To make a...
-
Walking the Walk at SQL Saturday Edinburgh in aid of *** cancer....
-
I've decided to implement a new blogging infrastructure based on WordPress; the community server stuff I'm using has got a bit tired and WordPress offers a wealth of plug-ins to do pretty much everything I want. So, see http://dataidol.com/tonyrogerson...
-
Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query...
-
Restoring databases to a set drive and directory Introduction Often people say that necessity is the mother of invention. In this case I was faced with the dilemma of having to restore several databases, with multiple ‘ndf’ files, and having to restore...
-
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find a new home. From now on (along with a few others of the UK SQL Server community) I shall be blogging on dataidol.com. My page will be at http:/...
-
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided that it is only necessary to process some data under a certain condition. By way of example, something like this : Create...
-
In the last few months I’ve been presenting a new session at community events that’s had a positive reception that I’m pleasantly surprised at. It’s had several titles, but currently its “How to be a more successful architect” and I originally created...