The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How can I get rid of these table locks?” This blog will show you how to build a package that will kill any SPID’s that are running on your system that could be locking a table. Note: Be careful using this technique, you could kill a critical process. In this package you will have five variables. objSpids = Holds the data from sp_Who2 strDatabase = Name of the database to look in Spids strSpid...
Read More
Come see two Database Powerhouses go Head to Head in an ETL challenge. Mike Davis and Aaron Nelson Square off in the SQL Smackdown. Mike Davis will use SSIS, Aaron Nelson will use Powershell Both men will show what pros and cons of each method in ETL Who will win??? Who will get hit with a steel chair??? Come see them at SQL Saturday Tampa on January 15, 2011.
Pragmatic Works is hiring. I would have to say this is the best company I have ever worked for, the job is very enjoyable. You are constantly learning the newest technology. Check out this blog desribing it more here .
If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill through report must be changed to Unique Name instead of value. Go to the detailed report that you are drilling down to and right click on the datasets folder then select show hidden data sets so you can see the parameter dataset. In this query you will see the key under the parameter value. ...
When working with SSAS it is sometimes necessary to process every dimension before continuing with development. This can be accomplished with a couple of clicks on the menu bar. Click on Database and then process. Then you will see each dimension processing.
When creating dates or numbers as strings it is sometimes required to have two digit numbers. For example, instead of this: 3/1/2011 You want to see this: 03/01/2011 There is an easy way to do this using the Right() function and adding a string zero to the front of a number, and then take the right two characters. Here are some examples: Today's Date is December 6, 2010, so the day is a single digit "6" Running this query: Select Convert(varchar(10), Day(GETDATE())) as OneDigit Results = "6" Add...
Creating a Rolling Date Range Named set in MDX One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this I used the StrToMember function in MDX. First To create a basic date range in a named set the syntax would be: [Admit Date].[Year].[2005]:[Admit Date].[Year].[2010] But this would require a manual change every year. To make the Named Set a Rolling 5 ...