Pre Conference seminar voting is up now here: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 http://www.zoomerang.com/Survey/WEB22BD59JCQBT Go make it happen! There's a lot of good seminars that you can ready here: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 BI Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingBI.aspx DBA Sessions: http://www.sqlpass.org/sqlrally/2011/PreConsforVotingDba.aspx Developer Sessions: http://www.sql...
Read More
Okay SQL Community, I need your help! Patrick Leblanc , Adam Jorgensen , Mike Davis and myself have submitted a precon for the exciting new event SQL Rally , which will be from May 11 - 13 in Orlando, FL. This event new event is designed to bridge the gap between the yearly PASS summit and SQL Saturday's. The Precon we've submitted is a Full Day Business Intelligence Workshop designed to get you from beginning to end in the Microsoft Business Intelligence while building a complete Data Warehouse...
Tuesday at 12:30 pm I will be presenting for SQL Lunch giving you an overview of some common DAX Expressions in PowerPivot. PowerPivot is still a very new technology and in this session you will get familiar with how you can create calculated columns and calculated measures using DAX. Speaker: Devin Knight Add To Outlook: Add To Calendar Date and Time: 10/26/2010 11:30:00 AM CST BIO: Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Micr...
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age. It used the following expression, which could just as easily be in T-SQL, to return back the current age of a person: DATEDIFF("YYYY", BirthDate, GETDATE()) Seems to make sense right? It sounds like it is saying return an integer back of the number of years between the birthdate column and the current date (GetDate()). Well if you do a little research on how DATEDIFF actually works you will find this will n...
Often when designing a Reporting Services with parameters you may be required to display those parameter values on your report. This is beneficial when you have a lot of values for one parameter or maybe you just want to print the report and need to know how the report is being filtered. Normally if you would like to use a parameter anywhere in the design of your report you can simply drag in the parameter name from the Report Data tab. Here I’ve concatenated the parameter value with some text: ...
To all who live within a drive (or even a flight) to Orlando I really recommend you attend SQL Saturday Orlando next Saturday October 16th. I and many other great speakers will be in attendance to give you great information on relevant SQL Server topics. I will be giving a presentation introducing you to Analysis Services. In this session I will also be giving away a copy of my latest book that teaches you how to work with the entire BI stack http://www.tinyurl.com/knightsbi . I hope you’re able...