Author Archives: jacob

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

Change default Collation in SQL Server 2008 R2

If you, like me, have a Test SQL Server that you use to load databases from various SQL Servers, then you may find it useful to change the Default Collation for your server every now and then. Reason for this … Continue reading

Posted in SQL Server | Leave a comment

SQL Pass Nordic – Day Two

Nice breakfast at Hotel Tammsvik and with an excellent view of the sunrise above the lake. All set up for a great day at SQL Pass. Today I followed the DBA track the whole day. Started with Mark Rasmussen waking … Continue reading

Posted in Uncategorized | Leave a comment

SQL Pass Nordic 2011 – Day One

Yikes, found out yesterday that Microsoft Pass split me and my two colleagues up by placing us on different hotels even though I booked the whole event together for all of us. Started off with a session with Tibor Karazi … Continue reading

Posted in Uncategorized | 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

VCenter and Total DISK IO

I’ve talked before about the vast amount of useful information in the VMWare VCenter database and one thing I’ve been looking for is the total Disk IO for a given time for all host servers. In VCenter you can see … Continue reading

Posted in SAN, Tips, VMWare | 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

I use WordPress for this blog

I first tried WordPress for blogging a couple of years ago and liked it so much that I currently run all my blogs on WordPress. I like it so much I even run my friends blogs on WordPress! This blog … Continue reading

Posted in Linux, Tips | Leave a comment

Selecting data from two or more tables?

Say you have one production database and an archive database for your application. A quite common setup. If you want to grab data from both tables in one single query, there are some ways to do this. you could create … Continue reading

Posted in SQL Server, Tips | Leave a comment