Archives: September 2009
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your… Read more
Have you ever wondered where to go to get good information that will help you in your day to day SSAS development life?
There are many options from community websites like ssas-info.com, sqlservercentral.com, sql-server-performance.com, and of course Microsoft's TechNet and MSDN sites get better with every release. They… Read more
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to create a new project from an existing database either in development or production.
First - Select to Create a New Project in BIDS (Business Intelligence Development Studio) and Choose the…
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow a "star pattern". This pattern consist of Fact data being retrieved along with it's related dimension data from a start schema. What makes the Star Schema look like a star…
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted across the web and I use many of them on a regular basis in my coding. It can be difficult however to get a single source for many of these… Read more
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I hear from database developers (especially those who have migrated from .NET) is that the intellisense seems to miss some recently created objects. They cry out "My object doesn't appear in…
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'tblDemo' when IDENTITY_INSERT is set to OFF.
This is because the table has a column marked for…