Category Archives: Uncategorized

How long do the parts of my job take?

Posted on September 28, 2011 by Stefan

When you schedule a job in SQL Server, you can see how long the job took by right clicking on the job and then clicking View History. If you want to see how long each step in the job took, … Continue reading →

Posted in Uncategorized | Leave a comment

Send Text notifications

Posted on July 4, 2011 by Stefan

I have most of my jobs set up to email me either when they fail or when they complete, depending on how sensitive the job is. If I need to know it is taking too long, I set it up … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

A weird result from IN (SELECT

Posted on June 29, 2011 by Stefan

I was recently building a query that referenced a SQL Server 2000 database on a linked server. I’m using SQL Server 2008 R2 on my end and I’m used to Intellisense suggesting the columns in the table I’m querying. Unfortunately, … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Who’s data is it?

Posted on June 23, 2011 by Stefan

Recently I needed to import some data from a flatfile into SQL Server. As I was creating the table for it, I tried to determine what the data actually was. There wasn’t very good documentation for it so I played … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

Oracle to SQL Server

Posted on June 12, 2011 by Stefan

It can be hard getting back to blogging after some time off, but here goes. I moved in March/April and I’ll be unpacking for a long time, but I do want to be blogging it is just hard to find … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

Knowledge Sharing

Posted on October 27, 2010 by Stefan

One of the biggest problems most companies face is the loss of institutional knowledge when an employee leaves. As a consultant, I see this at every company I go to. If it isn’t from an employee leaving while I’m there, … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

Taking Notes

Posted on September 18, 2010 by Stefan

I work with quite a few different technologies and I’ll use this blog to talk about all of them as I find interesting things to say about each. Currently I’m working primarily with SQL Server and that’ll be the primary … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment