nealwaterstreet.com

SSIS Frameworks Magic presentation

Today I attended Andy Leonard‘s presentation for his SSIS Framework. He has obviously put a lot of effort into this project. It is very robust, and has enough flexibility to do just about anything you want. He has posted the sample code and I am going to take a more in depth look.

The meeting itself was hosted on MeetingBurner, which looks like a new meeting/webinar service. MeetingBurner looks like a nice new tool to try out.

Andy sent out a follow up email that he will be presenting again on 12/27/11 at 10am ET. The link is: http://AndyLeonard.enterthemeeting.com/m/4DEJZZ1K. Check it out if you get the chance!

PASS Healthcare December meeting

Topic: Payer Data Warehouse Modeling 101
Speaker: Jessica M. Moss
Date/Time: December 15, 2011 1:00PM Eastern Standard Time

Attendee Link: www.livemeeting.com/cc/8000181573/join

Topic Synopsis: If you are in the healthcare industry, using acronyms such as ICD10 and HCPCS is second nature; however, adding a data warehouse to the mix may take you out of your comfort zone. Not to worry, this session will take that healthcare knowledge and turn it into a lean, mean, fact-finding machine. Learn how to create a payer data warehouse model, created from experience with numerous insurer organizations. If you are not in the healthcare industry, learn about data warehouse modeling best practices, and maybe you will even understand your insurance company better!

PASS Healthcare Virtual Chapter!

The PASS Healthcare Virtual Chapter has it’s first meeting on 11/17 at 1pm EST.

The topic will be “SQL Server in Healthcare – Healthy relationship?” by Scott Shaw. Go to http://healthcare.sqlpass.org for more information on upcoming topics and be sure to follow @HealthcareSQLVC on Twitter.

This is something that I’ve been working on over the last several months and it is great to see it taking off!

Try the statement later.

I got an error message I’d never seen before while altering a database.

Database is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)

Try the statement later? What does that mean?

I altered a column in a test database and immediately tried to take it offline. That is when I got the error. After searching for the message I found this:

http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/e779230a-87bc-4cee-b223-98a029097dc1

One of the solutions was to search sys.dm_exec_requests for an alter process on that database. Sure enough it was suspended. I killed the SPID and the database was back online pretty quickly.

Problem with a MTD query

I was running a query today and was not able to SUM by the current month. I checked the code and didn’t see any issues there, but when I looked at the variables it was pretty obvious.

DECLARE @targetdate VARCHAR(8)
DECLARE @previousdate VARCHAR(8)
DECLARE @currentmonth INT
DECLARE @currentday INT

SET @targetdate = CONVERT(VARCHAR(8), GETDATE() – 1, 112)
SET @previousdate = CONVERT(VARCHAR(8), GETDATE() – 2, 112)
SET @currentmonth = ( 10 * CAST(DATEPART(Year, GETDATE() – 1) AS INT) ) + CAST(DATEPART(Month, GETDATE() – 1) AS INT)
SET @currentday = CAST(DATEPART(Day, GETDATE() – 1) AS INT)

Which results in:

20111018
20111017
20120
18

I was setting @currentmonth incorrectly. The correct value is:

SET @currentmonth = ( 100 * CAST(DATEPART(Year, GETDATE() – 1) AS INT) ) + CAST(DATEPART(Month, GETDATE() – 1) AS INT)

Which gives the correct date/month

20111018
20111017
201110
18

Big difference!