Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting back up and get in full swing of the things again. This is going to be a short blog post as I am just letting you all know about a… Read more

Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve presented at, this event was great. The last I heard, there were nearly 300 attendees and it seemed that all were very pleased with the event. Check-in went smoothly especially… Read more

As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get the data from Text, Table (rarely used) or a Stored Procedure. Which query type to use has been a topic on many forum boards and I’ve had this question pop… Read more

Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and have never heard of SQL Saturday, it is a free event put on by the SQL community…for the SQL community… This is an opportunity to learn new things and brush… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I am going to show you how to… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

Yesterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well organized and gave me the idea that a lot of time was spent in making sure that nearly all of the 300 attendees (approx.) were well taken care of.… Read more

For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net Coders. It’s that time of year again and next weekend (Saturday August 27th, 2011) is going to be jammed pack with content to get you to the… Read more

I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that they needed a speaker and would love to have me talk about SSRS. Since I have given SSRS presentations for the past two years, I should be able to whip…Read more

While playing around with Denali, I came across a function that I believe should have been included in SQL for years. It is called EOMONTH and it “returns the last day of the month that contains a specified date”. You can pass in any date value and it will return…Read more

Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database to another server and you want to know how the move would impact your SQL Server.

With one of Pragmatic Works software tools, BI Documenter, you can easily…Read more

I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that I should probably wait until it is released…Hit the forward button…check…Make some modifications to blog…check…

It is July 12th, 2011 and finally…After months of waiting for SQL…Read more