Pragmatic Works

  On Friday, Sept. 12, you can hear about all the new features of SQL Server 2008 in this full day of free training brought to you by JSSUG, Idea Integration and Pragmatic Works. We've already had about 100 register for the event and we only...

It can be a pain to launch an SSIS package remotely. So I developed a vb.net standalone application to remotely launch a package. It does require the host computer to have SSIS installed. This is just a beginning program. I am going to be adding other...

In this series, I plan on sharing a lot of my recent experience with the SQL Server 2005 to SQL Server 2008 upgrade. Part of our ongoing project was to also use some of the new fantastic full text features in SQL Server 2008, which are now fully integrated...

I was trying to deploy a custom assembly today using Windows 2008 and SQL Server 2008 and found a bit of differences in Windows 2008. The GACUtil.exe utility has now moved first and foremost and is not installed by default until you install the .NET and...

If you have ever worked on a Data Warehousing project, specifically with being tasked in developing and loading (ETL) a dimensional model, you will have no doubt encountered the decision to implement a dimensional type architecture. Basically, you have...

Last week I had the opportunity to speak on SSRS 2008 at the Midlands PASS chapter in South Carolina. Given the fact that it was a horribly stormy night, (I got soaked walking, no, running to the building) I appreciate all the folks who came out for the...

Recently, I received from the publisher, an updated image of the cover of the forthcoming book titled Professional Microsoft SQL Server 2008 Integration Services . I'm very excited to have been involved in this project and hope that it gives those...

A icon of the business intelligence industry for Microsoft has now left the company to take a CTO role at Visible Technology. Bill has been with the SQL Server team or with in a BI role since 1996. I will truly miss Bill in the community, as he was a...

We’d like to thank all of you for attending our first of many free SQL Server Business Intelligence training sessions. To view the webinar recordings and register for our next free session please click below:

It's official, SQL Server 2008 has now launched and can be downloaded on MSDN, Technet. For more information, you can see the press release here: http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx. In Microsoft tradition...

While doing a big ETL project in Columbia, SC, I volunteered to speak at the local PASS chapter. Brian Kelley who heads up the group was kind enough to let me speak. The topic of the evening will be on Reporting Services 2008. Below is the information...

Yesterday I finished up my Professional SQL Server 2008 Administration book at long last, which makes my 9th book. I've never tried to write two books at the same time but I can tell you I'll never do it again! Writing is always like a bad hangover...

Thanks to the nearly 15,000 people who attended a webinar with me last week! All the webinars were recorded and we'll be posting them within a few weeks. We're just awaiting them for them to be edited since we have full motion videos in them....

Thanks to all who came to today's session on Introduction to SSIS. Tomorrow's session is on SSIS for the DBA. If you have not registered, I'm afraid we've maxed out the conference system at this point with 3200 people spread across Wednesday's...

Thanks to the 1500 + people who attended today's webinars. The recording will be posted on PragmaticWorks.com or SQLServerCentral.com next week. In case you're following along with the example I had on the webinar, you can download the code below...