Technical Presentations: Give it a Shot!

Posted on

If you have never done a technical presentation I HIGHLY recommend you do try it at least once. Volunteer to speak at your local user group or SQL event. Andy Warren (Blog | LinkedIn) recently added the idea of mini-presentations to both his user group meetings as well as the upcoming SQL Saturday #21 in Orlando. […]

PASS Summit Hotel/Travel Forum

Posted on

Are you going to the SQL PASS Summit? Would you like to save some money on hotel by finding someone to split a room with? Want to share insider information on local spots you can dine at on the cheap? Well I hinted on Twitter recently that I was working on something for PASS with […]

Policy Based Management: Against All Databases Condition

Posted on

Recently after one of my presentations a Twitter-buddy of mine, Argenis Fernandez ( Blog | Twitter ), showed me something interesting. By default when you create a new policy the against targets default says ‘Every Database’ (see screenshot below). Well this is a tad misleading as it apparently means “every” in the sense that it […]

How to Create a Server-Side Trace with SQL Profiler

Posted on

This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via T-SQL but to my dismay I […]

Remote Server Administration Tools for Windows 7 (RC)

Posted on

If you’re like me and trying out the Windows 7 RC on your everyday machines, there are certain key tools you find you need to do your work. For us system administrators Remote Server Administration Tools is definitely (or should be) one of those. I installed the previous version of tools on my workstation and […]

How to Kill a Stuck VM in ESX 3.5

Posted on

This morning my VM’s decided to become schizophrenic and stop opening consoles. Virtual Center showed the VM’s as still running but some weren’t responding to pings, some were but all had this error when trying to connect via console: error connecting to vmfs volumes Ok, well luckily this was a test environment VM so I […]

Got an Installation Stuck in a Loop?

Posted on

Today I was troubleshooting an issue where an MSI is constantly trying to install itself on the server but cannot find the files needed to complete the install. The errors encountered were the following: Source: MsiInstallerEvent ID: 1001 Detection of product ‘{GUID}’, feature ‘{program}’ failed during request for component ‘{GUID}’ What happened here was that […]

Starting the SQL Journey: Part II

Posted on

So in my last post I talked about my personal journey. In this post I’ll go step-by-step what I did to help along the path of learning all this SQL goodness.  Tip 1 – Crawl Before You Walk… Don’t know what a SQL statement is? Think T-SQL is an alternative to Coffee-SQL? Fear not, like […]

Starting the SQL Journey: Part I

Posted on

Recently at the VMware user group meeting I was approached by someone I used to work with. He worked in a non-IT role at my previous job and at his new job he was getting more involved in technical roles. He was attending the VMware meeting in order to understand virtualization better and expand his […]