Category Archives: DBA

Distribution database causing high disk IO, many reads / sec.

Playing around with VMWare performance data, i found a server with unusual high disk IO, and by that I mean registering around 300 MB/sec all the time. This server was a SQL Server 2008 R2 with some tables being replicated … Continue reading

Posted in DBA, SQL Server | Leave a comment

Review of Ola Hallengren’s Scripts

Ola Hallengren is a Swede (I presume) who have developed these nifty scripts for performing backups, index maintenance and database checks. I’ve been using them for some years now and really favour them opposed to the built in Maintenance jobs … Continue reading

Posted in DBA | Leave a comment

Attaching database that wasn’t detached

I recently had an interesting issue where a Virtual SQL Server was deleted from VMWare, just like that with no nice shutdown and certainly no last backup & detach database commands. We were fortunate to locate and mount the data … Continue reading

Posted in DBA, SQL Server, VMWare | Leave a comment

Matching physical names with databases in SQL Server

Sometimes you find yourself looking for which database use a specific data file on your filesystem. This may happen when restoring/renaming a SQL database on your server and not following your naming convention. This usually ends up with different physical … Continue reading

Posted in DBA, SQL Server, Tips | Leave a comment

Search for text in Stored Procedures

Very handy when you are asked to create a trace for a stored procedures that update text in a specific table. Then you want a way to search fast within all sp’s in your database. SELECT distinct sysobjects.name FROM sysobjects … Continue reading

Posted in DBA, SQL Server | Leave a comment

Connecting to SQL Server with Windows Authentication to a different domain

How do you solve the problem of connecting from say your office computer in the office domain to your production environment when there is no trust between the domains? This scenario is quite common in larger companies. The reason is … Continue reading

Posted in DBA, SQL Server, Tips | Leave a comment

VMWare VCenter data

VMWare VCenter platform is a goldmine of useful data if you want to know whats going on with your virtual servers. Statistical data is stored in an SQL Server database and you can either query views or the tables directly. … Continue reading

Posted in DBA, Perl, VMWare | Leave a comment

Review of Quest Spotlight on SQL Enterprise

I’ve been using Quest – Spotlight on SQL Enterprise for a while and here are my thoughts. First some positive things about Spotlight on SQL Very easy to install. All you need is a server, preferably a dedicated for hosting … Continue reading

Posted in DBA | Leave a comment

Me, the exceptional DBA?

So I’ve nominated myself to the Exceptional DBA even though I don’t think I’m qualified to win. I’m in it just to participate, and that’s what Internet Communities are for! What is the Exceptional DBA? “Do you take the time … Continue reading

Posted in DBA | Leave a comment

Deadlines

Has it ever happened that just days before the big release date, you get a new set of scripts to deploy in production? But it’s just a small change the developers say! Caramba! How are you going to verify those … Continue reading

Posted in DBA | Leave a comment