SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: February 2011

SSAS - Preserve Measure Null Values

Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in measure data of a fact table.  You may have unknown foreign keys from your dimension data but even those unknown foreign keys relate to some kind of fact data.  If… Read more

0 comments, 5,741 reads

Posted in Devin Knight on 28 February 2011

Testing SSAS Security in Excel

There are many posts available that describe how to test Analysis Services security from inside the development environment.  Today I would like to share a nice way to do this from excel.  When you create a connection to your Analysis Services database in Excel it creates an .odc file.  This… Read more

0 comments, 1,466 reads

Posted in Devin Knight on 21 February 2011

SQL Rally Performance Tuning SSAS Session

Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning Analysis Services was voted in!  I want to thank everyone for voting and I promise to make it a great session.  It will be a fun, entertaining, and of… Read more

0 comments, 1,213 reads

Posted in Devin Knight on 16 February 2011

Pre-Order SharePoint 2010 Business Intelligence 24-Hour Trainer

I wanted to announce that you can now pre-order your copy of my latest book to be released called SharePoint 2010 Business Intelligence 24 Hour Trainer  (http://tinyurl.com/SharePointBITrainer). This book was written so that someone completely new to SharePoint or BI could get their feet wet and produce value… Read more

0 comments, 935 reads

Posted in Devin Knight on 7 February 2011

SQL Rally BI Sessions

This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder to everyone to vote!  Of Course PragmaticWorks is a Business Intelligence shop you will find myself and several of my co-workers have submitted sessions.  It looks like no matter who… Read more

0 comments, 1,170 reads

Posted in Devin Knight on 1 February 2011