Category Archives: Tips

Using Mediawiki as a documentation tool

Some years ago, a coworker introduced me to using Mediawiki as a documentation tool and I got immediately hooked on it. The biggest pro is that it’s very easy to use and install (millions of people already use it on … Continue reading

Posted in Linux, Mediawiki, Tips | Leave a comment

Query WSUS server

On a regular basis we patch our Windows Servers and it would be nice to get a realtime view of just how patched our servers are – which servers are not yet patched and how many patches are about to … Continue reading

Posted in SQL Script, Tips, WSUS | 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

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

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

Progress of DBCC CHECKDB

Run this to find out progress for dbcc checkdb select percent_complete, command , start_time from sys.dm_exec_requests where command like ‘%dbcc%’ You can also find out progress for long running backups and more! select percent_complete, command , start_time from sys.dm_exec_requests where … Continue reading

Posted in SQL Server, Tips | Leave a comment

Large result sets

When doing a sort or other manipulation on a large result set, try to limit it down even though you use “top 100” in your select statement. A “top 100” won’t do any good when running an “order by” cause … Continue reading

Posted in SQL Server, Tips | Leave a comment