Like many people who work in IT departments, my company gives me two accounts to their network. One is a “regular” user account – one with the standard permissions every employee gets. The other is one I can use to do my IT work – it has administrator privileges to many systems, including all our […]
I submitted a script to SQLServerCentral.com and it’s been published today. The script automatically re-trusts foreign keys or constraints. It will also report any that could not be re-trusted. Discussion about the script can be found here. I have post here about how your foreign keys and constraints might become untrusted and why it is […]
I think most DBAs by now know that heaps, tables without a clustered index, are bad and should be avoided, but the word hasn’t seemed to have trickled down to software developers yet. I still come across to many vendor databases that contain hundreds, if not thousands, of heaps. In fact, what prompted me to […]
Back in December, a couple of checks I wrote were included in Brent Ozar Unlimited’s sp_Blitz script. I was chagrined to see that some people discovered some bugs in my code and submitted fixes. To be fair, one was a bug in SQL 2008 & 2008 R2 where DBCC DBINFO WITH TABLERESULTS returned the dbccLastKnownGood […]
My co-worker showed me a SQL Server requirements document that he found online somewhere and modified at a previous company. He would give this document to vendors who said they needed a SQL Server and they would need to select the appropriate answers before he would let them install their product. I think this is […]