Subscribe to this blog
Archives: September 2009
Great Post on Clearing all data from your Data Warehouse
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
2 comments, 68 reads
Posted in Adam Jorgensen on 9 September 2009
Books You Should Own
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
0 comments, 93 reads
Posted in Adam Jorgensen on 9 September 2009
Importing SQL Server 2008 Analysis Server Database
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…
0 comments, 98 reads
Posted in Adam Jorgensen on 8 September 2009
Star Join Optimization in SQL Server 2008
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…
0 comments, 1,514 reads
Posted in Adam Jorgensen on 8 September 2009
Date Expression Compilation in SSIS
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
3 comments, 535 reads
Posted in Adam Jorgensen on 8 September 2009
Smarter Intellisense
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…
0 comments, 140 reads
Posted in Adam Jorgensen on 8 September 2009
Identity Insert Guideline
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…
0 comments, 119 reads
Posted in Adam Jorgensen on 8 September 2009