-
Managing a large SQL Server estate If size matters Martin Cairney would have the bragging rights!! Martin Cairney Martin Cairney has over 10 years experience as a SQL Server DBA. In his time he has worked for one of the largest IT services companies in...
-
What are SQL Nuggets?...
-
We'll be announcing the date and venue for the next SQLBits on Monday So keep posted, we've got some really exciting news. I am really excited about the whole event. Its going to be bigger and better than the others.
-
New documentation on ROW CONSTRUCTORS indicate the feature has had a name change to Table Value Constructors...
-
Don't forget if you are in the Cambridge area on Monday (6th July 2009) we are doing another usergroup meeting. This one is going to be on SQL Server 2008 features. We are holding this at the head quarters of Redgate software who are kindly sponsoring...
-
Martin is continuing to post some great new posts on his blog. I thought the last one is a real nasty one. http://sqlblogcasts.com/blogs/martinbell/archive/2009/06/29/After-disabling-tde-you-still-requires-certificates-to-restore-the-database.aspx If...
-
Many years ago I was working on a project that had some large batch processing in it. To do this processing we had some dedicated servers, one of which sat under the desk next to me. Apart from the noise of the fan soudning like we had actually bought...
-
Missing certificates can cause problems when restoring databases even if they are not being used!...
-
There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning.... read more !
-
One feature introduced in SQL Server 2005 is reporting in management studio. You have a set of standard reports that allow you to see in a nice report format output from dmvs and the default system background trace. Whats neat is that you can write your...
-
Just noticed that there is a MS new paper on Disk Partition Alignment. http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5b343389-f7c9-43d0-9892-ddcf55890529 Happy weekend reading
-
I always like working at home with my patio door open, we had a really heavy rain shower and I got a visitor. Anyway, this video is one of the instances of me chasing him/her out of my office. So much for prepping for my LiveMeeting this afternoon :)...
-
Hi, I just finished my first live meeting for the UK SQL Server user group on the subject of creating a star schema and OLAP cubes. I think it went well, it was recorded so Ill let you all be the judge of that - presentation to follow. I spoke way too...
-
After taking the usual database backups etc. I went to install SP1 on a SQL 2008 server (RTM) following the normal routine of stopping the sql server services and firing up the service pack install. All went fine, and the service pack finished. Anyway...
-
How do you start a SQL Agent job in SQL? I recently found myself wanting to be able to do this and it turns out it's really easy: exec msdb.dbo.sp_start_job 'Check Integrity' It returns as soon as the job has started, without waiting until...