Pragmatic Works is on YouTube !
I bet you didn’t know Pragmatic Works has our own YouTube channel ? Check it out at
There is some great...
2010-02-20
279 reads
Quotes in Calculation Tab
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
208 reads
Selecting Top N Rows from Excel Source
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
263 reads
SSAS Query Processing and Performance Tuning
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
292 reads
Testing Security in SSAS
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
333 reads
Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
389 reads
Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
346 reads
Recent Speaking
Ok Guys and Gals. I know I have been a slow blogger thus far in 2010. To try and make...
2010-02-08
339 reads
Stop Splashing with –NoSplash
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
480 reads
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
313 reads
Blogs
What’s New at AWS re:Invent 2025 – Day 1 Highlights
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers