Acronyms in SQL Server

SQL Server can be a dizzying array of acronyms to the uninitiated – SQL itself, SSIS, SSAS, SSRS, SMO, DMO – the list seems endless.  In this post, I will define some of the acronyms and give a brief description of what each does, so you can decide if you are interested in learning more…

0

Where to find help on Microsoft products

Hello all,   I’ve had a couple of times this week when I have been contacted by customers, and they have not been happy, as they have had issues trying to get support from Microsoft.  I fully understand the frustration, as most of us seem to have to work with at least one Microsoft product…

0

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 how to do this.  Here’s what happened – my manager wanted a report from me about participation in the MSDN and TechNet Forums, the exact details are unimportant, but suffice it to say, this…

0

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, catch up on the meetings you missed, etc.  So, time to dive back in to the blog and actually put some data in the database and the table we created last time.  My goal here over the…

3

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 Real World unless you can also create a new database and add the information that you want in it. I am not all that unusual in that I have a lot of photographs (of…

0

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 a bit more, you learn a few things about it.  First, the log is not actually one file, but a series of files called Virtual Log Files.  These VLFs act as one…

0

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 North Carolina.  As I look for topics to write about, I go through a variety of sources to see what people are having trouble with, and installation is by far the #1 issue.  To solve…

0

Scripts in SQL Server

One would think this is a small and easy topic, as Scripts seem to be a pretty easy concept to grasp.  However, there are a few things to know first – are you trying to affect the database itself (create it, add or drop a table, etc.), or are you generating a script to run…

2

Things I learned from TechEd

There are a number of things I learned from TechEd in New Orleans last week.  Although this was not my first TechEd (I think I have been to 8 or 9 now), I always look forward to it, as I always seem to learn something new.  My main function at TechEd this year was to…

0

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 Entity Framework is, so I did some research on it, and rather than waste good knowledge, I figured I’d write about it now and we can come back to it later.  At its…

11