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
276 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
302 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
342 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
225 reads
I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
223 reads
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
288 reads
Don’t Miss our Upcoming Webinar Series in February and March
More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...
2010-02-20
259 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
407 reads
Important SSAS Dimension Properties
When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...
2010-02-20
458 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
360 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers