SSAS Dimension Attribute Discretization Methods
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...
2011-01-27
3,818 reads
Devin Knight
SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.As I promised in the...
2011-01-17
1,266 reads
SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that...
2011-01-10
14,907 reads
SQLSaturday #62 - Tampa
Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa. If you haven't...
2011-01-06
649 reads
SSAS Understanding Multiple Security Roles
In a previous article I showed how you can create dynamic security in SSAS.This is a great way to make...
2010-12-28
3,199 reads
SSIS to SQL Server Data Type Translations
I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS...
2010-12-22
99,669 reads
Work With Me at Pragmatic Works
Recently Adam Jorgenson wrote a blog post titled Come be your best at Pragmatic Works, which described the work environment...
2010-12-14
985 reads
SSIS Denali Source and Destination Assistants
In several previous posts I have described some of the usability changes that will come with the next release of...
2010-12-13
1,474 reads
SSIS Denali Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
670 reads
SSIS Denali Data Flow Grouping
There have been several usability features that have been added to SSIS in the latest CTP.One of these features is...
2010-11-22
837 reads
Blogs
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers