Nov 15, 2012 | Consulting, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 |
SQL Server Version Upgrade – You have SQL Server running nicely with no issues or problems. The trouble is its SQL Server 2005 and you know you need to consider migrating or upgrading to a later version of SQL Server but you don’t know where to begin? We can...
Nov 14, 2012 | Consulting, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Virtualization |
SQL Server Virtualisation – Lots of companies and organisations are adopting a virtualisation first approach to the installation of new servers in their data centres. This can and will include SQL Server. Many DBAs perceive virtualisation as a bad thing for...
Jan 9, 2012 | DavidP, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerPedia Syndication |
It’s always handy to know if there any problems with your servers before you get into work in the morning. This is why I wrote a program that goes round all our SQL instances at 7am and checks they are all up. If it doesn’t get a reply from one it emails or pages me...
Aug 8, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 |
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They were trying the restore for themselves and a few of them got an error about not having exclusive access: Msg 3101, Level 16, State 1, Line 5Exclusive...
Jul 27, 2011 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 |
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses when someone asked ‘How do you search for a wild card character when using a LIKE based WHERE clause fro string comparisons. I must have looked stumped for...
Jul 18, 2011 | Security, SQL Server 2005, SQL Server 2008 R2 |
Written by David Postlethwaite Security of the SQL database is becoming more and more important these days yet I’m finding that vendors often overlook setting minimum required privileges on a database. Many database I’ve been given to install just assign db_owner to...
