John Sansom – SQL Server DBA in the UK Rotating Header Image

Posts under ‘Uncategorized’

Something for the weekend 10/07/09

What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on [...]

Reporting Services date control issue using Analysis Services data source

Here’s a solution to an issue that you may have come up against when designing a SQL Server Reporting Services (SSRS) report requiring Datetime parameters, that uses a SQL Server Analysis Services (SSAS) data source. What’s the problem? When you create a dataset from a SSAS data source, by default the date values returned from [...]

New SQL Server Resources

One of the joys of working with SQL Server technologies is that there are some truly great knowledge resources available for use. You just have to know where to look. With the volume of information available it can be difficult to sift out the really good stuff. I know throughout my time as a database [...]

Here is a Wordle for this site

Wordle seems to be doing the rounds on the SQL Server blogs and community resources at the moment so I thought I would knock one up for this site.

What makes an exceptional DBA?

When attempting to define what makes a good Database Administrator, understandably the focus is often placed on the technical skills that are deemed to be required. There are plenty of great resources available on the net that can be used to research this aspect. For instance, Brent Ozar has some excellent material on his site. [...]