Ed's Getting Started Blog

This is a blog geared towards those of us who are not masters of SQL Server. I will be learning SQL Server, and this blog will chronicle the journey.

Time for a change

This will be my last post on this blog, I am leaving Microsoft tomorrow. After 14 years working for...

Author: edhickey Date: 10/06/2011

SQL PASS Community Summit 2011

Hi all, One of the things I write about in this blog is how toget help from the Community of SQL...

Author: edhickey Date: 08/08/2011

Locks Unlocked

I’m likely not the first person clever enough to use this title, but as requested, this post...

Author: edhickey Date: 07/27/2011

Where to post your questions in Microsoft Forums

Hi all, As some of you know, I manage about 120 MSDN and TechNet Forums for our division. One thing...

Author: edhickey Date: 06/03/2011

What gives you trouble when learning SQL Server?

I've written a few posts about some of the bigger topics in learning SQL Server. Now I'd like to...

Author: edhickey Date: 04/21/2011

The MVP Summit 2011

It has been a while since I posted, and I know I am not supposed to apologize for being absent in my...

Author: edhickey Date: 03/11/2011

Acronyms in SQL Server

SQL Server can be a dizzying array of acronyms to the uninitiated – SQL itself, SSIS, SSAS,...

Author: edhickey Date: 11/19/2010

Now that was easy!

This is a pretty common scenario, so I thought I would write it up and post it so everyone could see...

Author: edhickey Date: 10/08/2010

Adding data to a SQL Server Database

I’m back from vacation, and it always seems to take an extra week to clear out the inbox,...

Author: edhickey Date: 08/27/2010

Creating a Database in SQL Server Express via SSMS

It is all fine and good to be able to manipulate a database, but that will get you nowhere in the...

Author: edhickey Date: 07/29/2010

The Transaction Log

I hear a lot about this file, as it is a very important part of SQL Server, but as you dive into it...

Author: edhickey Date: 07/21/2010

SQL Server Setup issue and SP1

I came across this topic when it was pointed out to me by Larry Franks, a colleague of mine from...

Author: edhickey Date: 07/09/2010

Scripts in SQL Server

One would think this is a small and easy topic, as Scripts seem to be a pretty easy concept to...

Author: edhickey Date: 06/25/2010

What is Entity Framework?

I know this is out of sequence for this blog, but I really needed to get a better grasp on what the...

Author: edhickey Date: 05/27/2010

The parts of a SQL query

I was going to go more into Joins this week, but as this is the Getting Started Blog, I think I...

Author: edhickey Date: 05/14/2010

First Queries in SQL Server Management Studio

Alright, I’ve got everything installed, I have the AdventureWorks database, SQL Server and some time...

Author: edhickey Date: 04/30/2010

Installing SQL Server Express

I have decided to start with SQL Server Express, as it is a free download and hopefully will not...

Author: edhickey Date: 04/19/2010

The importance of a clean machine

Years ago, I was hired by Microsoft to support Visual Basic, and I spent nearly 4 years on the...

Author: edhickey Date: 04/01/2010

Using the Community

One of the things I have learned in my travels here has been that you can find almost anything if...

Author: edhickey Date: 03/22/2010

Getting started with the new blog

Hello!  My name is Ed Hickey, and I am a Program Manager in the BPD Division at...

Author: edhickey Date: 03/16/2010