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
284 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
210 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
266 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
295 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
335 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
392 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
354 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
343 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
487 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
315 reads
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers