The database design for Dynamics / Great Plains is well known to be incredibly poor. Now I’ve run into another reason why the program sucks. As per best practices, I’ve got alerts set up on all my SQL Servers. One of these alerts is for severity 20 errors. I have a server that is host […]
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 […]