Search
Post Calendar
My Tweets
- We just backed Ten Plagues the Card Game on @Kickstarter kickstarter.com/projects/64044… https://t.co/1hIFAxaLHd 3 months ago
- I just entered to win a $50 Miniature Market Gift Card with help from @TheGameBoyGeek ! gameboygeek.com/contest 5 years ago
- Help Sydney travel Abroad gofundme.com/help-sydney-tr… 6 years ago
- Got to meet zee @dtconofficial https://t.co/m0YUdcLVOr 6 years ago
- RT @StrateSQL: Mikes entering sandman #sqlkaraoke vine.co/v/eYUJrV0JAiK 7 years ago
Pass Summit 2011
SQL Rally
Meta
Monthly Archives: February 2014
Standard Deviations with CTE in SQL
I was working with a client recently getting the number of standard deviations a student was off the average number of suspensions. I accomplished this with two Common Table Expressions, (CTE). The first CTE gets the standard deviation and the … Continue reading
SSRS Report Models no Primary Keys
When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading
SSRS – Creating Drill Through reports with MDX
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 … Continue reading
SSIS – Using Kill with SP_Who to Break locks
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 … Continue reading