05 Jun 2012
By Allen
0 Comments
SQL Rally 2012 BI Track Highlights

SQL Rally 2012 BI Track Highlights

SQL Server, SSAS, SSIS, SSRS, , , , , , , ,
When I got back from SQL Rally 2012 a few weeks ago in Dallas, I shoved the notes into my laptop bag and took off for vacation.   I still want to share a few of the highlights of my trip.  These were some excellent speakers and I hope to see them again at future events. Sessions: Tuning Analysis Services Performance by John Welch Presentation John did an excellent job of explaining the basics of the processing options in SSAS. What was interesting was his experience splitting up jobs to increase performance.  Process Full will process all the dimensions and facts…
Read More
21 May 2012
By Allen
0 Comments
Microsoft Exams 2-for-1

Microsoft Exams 2-for-1

Microsoft SQL Server, SQL Server, ,
With all the certification paths being updated, Microsoft is offering a limited time* "Two for One" exam offer.   Technology paths include Windows 7,  Windows Server 8/cloud, Visual Studio 2010 and of course SQL Server. 1.  To purchase your "two-for-one" voucher, visit Prometric's website. 2.  Just purchase and take a qualifying exam at full price between April 11, 2012 and June 30, 2012, 3.  You will be emailed a voucher valid for the next version exam of your chosen technology path, at no additional cost.    
Read More
09 Apr 2012
By Allen
0 Comments

SQL 2012 Study Materials

SQL Server, , , ,
This started as my personal list of study materials, but it bears sharing.  I got started studying as I studied for the new SQL 2012 Beta Exams.  You might still get a slot to try out the exams for free over at the Born to Learn blog  Once you choose an exam, follow their link to see the specifics about the exam.  Be sure to click on the 'Skills Measured' tab.  That will show what percent of the test covers different areas. Be sure to take a look at the planned certification paths for SQL 2012.  The paths have changed…
Read More
09 Dec 2011
By Allen
0 Comments

SSRS Data Driven Subscription Troubleshooting

SSRS, , , , , ,
Microsoft SQL Server Reporting Services (SSRS) 2008 R2 will only allow data driven subscriptions under certain conditions, including data source security and server configuration options.   SSRS Subscriptions always work great and easy in the demos and training classes.  The following is the list of requirements to actually get them to work with in a data driven environment. You must have SSRS configured to run with an 'Execution Account' Data Sources must not have your Data Sources folder hidden with the option 'Hide in tile view'.  If you check that box, you will be unable to select a data for…
Read More
02 Aug 2011
By Allen
0 Comments
SSRS Adding “Image Not Available” as Alternate Image

SSRS Adding “Image Not Available” as Alternate Image

Microsoft SQL Server, SSRS, , , ,
I just had a requirement to build a report which had images stored in the database. SSRS handles that fine by just setting the image object to 'database' and then selecting the field. The challenge was adding an alternate image or text when there was no image stored in the database. SSRS makes it difficult because there is no method to dynamically change the image type on the image container itself, such as changing from 'database' to 'external' image on a web server. OPTIONS: Store the 'Not Available' image in the table and write a query which pulled only that…
Read More
01 Jul 2011
By Allen
0 Comments

Using SQL to Build MDX parameters

SSAS, SSRS, , , , , ,
I had a client report which needed a parameter list to default to the previous closed financial period date. The SSAS cube includes reporting periods into the future which have data entries even if the month has not been 'closed' by accounting department. Without a 'Month Closed' flag in the cube, the only way to build the parameter list was by querying the date dimension database table. When adding a date parameter to the report dataset, SSRS will automatically build a hidden dataset which pulls the list of available dates from the cube. For this example, I left that data…
Read More
04 Apr 2011
By Allen
0 Comments

Microsoft PowerPivot Resources

Microsoft SQL Server, PowerPivot
I enjoyed the weekend at SQL Saturday #63 in Dallas. It was my first SQL Saturday and I was quite impressed with the caliber of speakers. Some sessions were hit and miss, but most were well prepared and immediately useful. One area I wanted to learn more about was PowerPivot, but that presentation was stuck in Demo Hell. We've all been there in front of a crowd, so I empathize. Jamin Mace sent more resources to learn about PowerPivot. I just wanted to thank him and pass them along: Good Blog about PowerPivot with tutorials: http://powerpivotgeek.com/ Good DAX reference:  http://powerpivot-info.com/post/439-dax-cheat-sheet…
Read More
18 Mar 2011
By Allen
0 Comments

Learning the Microsoft BI Stack: SSRS

Microsoft SQL Server, SQL Server, SSIS, SSRS
I've been learning and working with IBM Cognos since it arrived on my desk in 1999.  It was an ugly brown box labeled Cognos 5.5.  Since then I've studied and learned 6.x then 7.x and finally made the painful transition to 8.x. Now I'm studying both the Microsoft Business Intelligence stack (SSAS, SSIS and SSRS) along with learning the new Cognos 10. I just want to list two WROX titles which are the best I've found for getting up to speed quickly. For learning SQL Server Reporting Services (SSRS) go get the Professional series book 'Microsoft SQL Server 2008 Reporting…
Read More