SQL Server DBA Blog, with straightforward advice, quality resources and musings about SQL Server
Well I suppose it was both inevitable and only a matter of time before I became the next victim of Stackoverflow addiction!
I hold BrentO fully responsible for this devourer of my valuable free time. For it was he who introduced me to what is quite possibly one of the best technology forums on the [...]
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.
Have you ever wondered what is the optimal configuration for your tempdb database within SQL Server?
There is often significant debate surrounding this subject and so Paul S. Randal, discusses using multiple files for a user DB on a multi-core box in an effort to set the record straight.
I have been doing some very extensive digging [...]
No matter how good a T-SQL programmer you think you are, it is always good to revisit the basics every once in a while and to ensure that you keep your high quality coding standards in check.
One of my favourite series of articles regarding good T-SQL coding practices is by Jeff Moden over at SQLServerCentral.com. [...]
When you try to execute the Performance Dashboard Reports for the first time, you may be presented with an error of the form:
“the difference of two datetime columns caused overflow at runtime”
This is because the DATEDIFF function returns an int value and once you have a connection that is more than 24 days or so [...]
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. [...]
An essential skill trait for a good DBA in my view is being organised. With the responsibility of administering and managing vast numbers of servers/jobs/processes simultaneously across the globe, it goes without saying that being organised can come in handy.
What with so much going on at any given time, it can be tricky to [...]