I’m pleased to announce that I am now offering SQL Server consulting services! I specialize in helping companies with no DBA or small IT staffs with little to no SQL Server experience. Check out my consulting page for more info and my information page to find out more about me.
I’ve been working lately on creating some automated check scripts, similar to Brent Ozar’s great sp_Blitz script. I’m intending my script to be able to be run against SQL 2005, 2008, and 2008 R2 servers (I just got my hands on SQL 2012, so my next pass will be to make sure everything works on […]
Most DBAs know about this undocumented stored procedure. It loops through all the databases on a server and allows you to execute T-SQL statements against each one. I have feeling some people think this is better than writing your own cursor that does the same thing. It’s really not. In fact, if you go into […]
I installed my first SQL 2012 server recently and came across an interesting issue I thought I’d share. When you connect to a SQL 2012 server using SSMS from SQL 2008 R2 and view the database options page, you do not see options for the database compatibility level. Here is a look at the compatibility […]
When it comes to deploying new versions of SQL Server, we never do in-place upgrades. Management just feels there’s too much risk involved and if something goes wrong, it’s too hard to roll back to the older version. So we build a test system, copy the databases over to it, test the software against that […]