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,820 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,268 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,908 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
650 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,203 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,806 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
986 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,476 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
673 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
840 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat BCA KCP Bontang Kontak 0817819444
WhatsApp:0817819444 Ruko Bontang Trade Center, Jl. Bhayangkara A10-A11, Gn. Elai, Kec. Bontang Utara, Kota...
Alamat BCA KCP Sangatta Kontak 0817819444
Jl. Yos Sudarso, Sangatta Utara, Kec. Sangatta Utara, Kabupaten Kutai Timur, Kalimantan Timur 75611
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers