Author Archives: Stefan

Knowledge Sharing

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

Clarity in Code

Commenting code is always a good idea and there are more ways than one to comment your code. When running a long series of SQL queries it can be useful to know what has run. If you have conditional statements … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment

Lecture

I went to a SQL Server lecture tonight on Virtual Machines and SQL Server by Brent Ozar. It wasn’t what I expected. The lecture was great, as have been all the ones in this lecture series, but the advice was … Continue reading

Posted in 2008, SQL Server | Tagged , , , , | Leave a comment

Resources

I’d like to recommend a web site for learning SQL Server and for all your questions as you get stuck. And you will get stuck, believe me, at least if you do anything at all beyond the basics and probably … Continue reading

Posted in 2008, SQL Server | Tagged , , , , | Leave a comment

Data Transformation Quirk

In SSIS when creating a Data Flow Task, you’ll usually want to have a destination for your data. From everything I’ve read, if your package is running on the same server as your destination, you’ll want to use SQL Server … Continue reading

Posted in 2008, SQL Server, SSIS | Tagged , , | Leave a comment

File System Task

I’ve used the File System task before, but it was to do a daily copy of files in a directory. I used copy directory so I didn’t have to specify or loop through any files. It was the same process … Continue reading

Posted in 2008, SQL Server, SSIS | Tagged , , | Leave a comment

Intellisense

Adding Intellisense to SQL Server Management Studio is a wonderful improvement. If you’ve used Visual Studio, you know what Intellisense is. For everyone else, Intellisense checks what you’re typing and gives you suggestions of valid options based on context. It … Continue reading

Posted in SQL Server 2008 | Tagged , , , | Leave a comment

Aliases

Aliases seems to be something people don’t think much about. They learn that you can call a table or a column something else for reference elsewhere in your query and they go about using it. Sure, sometimes they can’t understand … Continue reading

Posted in 2008, SQL Server | Tagged , , , | 2 Comments

How much data is there?

We’re all familiar with trying to figure out just how much data is in our database. To get approximately how much memory the whole database takes up you can open SQL Server Management Studio, right-click on the database name you’re … Continue reading

Posted in 2008, SQL Server | Tagged , , | Leave a comment

Set Statistics

Any time you’re developing queries in SQL Server, whether they’re single use or intended for inclusion in a stored procedure that’ll be run frequently, you want to know how well your query is running. If it is intended for production, … Continue reading

Posted in 2008, SQL Server | Tagged , , , | Leave a comment