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,123 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,505 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,275 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,670 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,164 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,857 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,497 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,234 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

944 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,186 reads

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

March 2026 SQL Server Security Updates

By Brian Kelley

On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...

How Fabric Mirroring Transformed with SQL Server 2025

By Meagan Longoria

When mirroring was first released for Azure SQL Database, it used Change Data Capture...

Read the latest Blogs

Forums

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

Upgrading Admin Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrading Admin Queries

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers