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).

SQL Rally Schedule

by Devin-Knight

Devin Knight

Thursday, May 12
BI
DBA
DEV
PD / WILD
CARD
8:30 - 9:30
SQL Server Parallel Data Warehouse - Under the Hood
Brian Mitchell
The Dirty Dozen: PowerShell Scripts for the...

2011-04-05

1,119 reads

SQL Saturday #74 Jacksonville

by Devin-Knight

Devin Knight

For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already...

2011-03-30

1,502 reads

SSAS - Measures or Attributes in Multiple Display Folders

by Devin-Knight

Devin Knight

I had a client recently show me a neat little tip that I thought I would share.In the cube he...

2011-03-22

1,266 reads

Passing Values into an SSIS Package at Runtime from Outside the Package

by Devin-Knight

Devin Knight

SSIS provide several methods for passing values into your packages at runtime.The benefit of doing so allows you to change...

2011-03-14

34,392 reads

SSAS – Changing the Dimension ALL Member Name

by Devin-Knight

Devin Knight

All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.For example, let’s...

2011-03-07

2,157 reads

SSAS - Preserve Measure Null Values

by Devin-Knight

Devin Knight

Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in...

2011-02-28

5,853 reads

Testing SSAS Security in Excel

by Devin-Knight

Devin Knight

There are many posts available that describe how to test Analysis Services security from inside the development environment.Today I would...

2011-02-21

1,491 reads

SQL Rally Performance Tuning SSAS Session

by Devin-Knight

Devin Knight

Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning...

2011-02-16

1,229 reads

Pre-Order SharePoint 2010 Business Intelligence 24-Hour Trainer

by Devin-Knight

Devin Knight

I wanted to announce that you can now pre-order your copy of my latest book to be released called SharePoint...

2011-02-07

940 reads

SQL Rally BI Sessions

by Devin-Knight

Devin Knight

This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder...

2011-02-01

1,178 reads

Blogs

My 2024 in Data: Music

This is my last week of the year working (I guess I come back...

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By Andrew Pruski

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Automating Export of PowerQuery to SQL Server using DAX Studio...?

I wrote a PowerQuery that parses a table from a PDF, and I want...

Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

Comments posted to this topic are about the item Attaching an SQL Server database...

Superseded Indexes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Superseded Indexes

Visit the forum

Question of the Day

Superseded Indexes

Which of these indexes is superseded by another?

See possible answers