You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]
To celebrate the release of my first published work, I’m giving away a copy of Tribal SQL. To have a chance of winning, just leave a comment on this post before November 11, 2013 6:00 AM Mountain Standard Time. I’ll assign a number to each comment in the order they were received and use www.random.org […]
Note: For more details about this script and the variables and outputs, see my post here. I’ve made two changes to my script that checks for new database objects to compress. First, it will now enclose table and index names in square brackets to prevent errors with object names that are also keywords or include […]
Sharepoint and SQL Server have a somewhat rocky relationship. Sharepoint likes to use GUIDs everywhere and likes to handle database maintenance on its own. It sometimes seems like the database design was specifically concocted as an example of how NOT to design databases for best performance. On the other hand, Sharepoint is really good about […]
I don’t spend a lot of my time tuning queries. Many of the databases in my company are used by third party products and we have limited control over the changes we can make to those. However, we do have several databases that are used by home-grown applications and these we have much more latitude […]