SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
2013-07-19 (first published: 2013-07-15)
2,129 reads
Blog Posts
70-457 Reviewer #04, Implement a Migration Strategy
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
589 reads
Check Constraints can help enforce the all or nothing approach when it comes to column updates
If you have a set of columns inside your table that you want to allow nulls in, however if one...
2013-07-18
1,232 reads
Fixing Bad Links Found Using Google Webmaster Tools
I’ve been doing various clean up tasks this week related to the blog, with part of that being a review...
2013-07-18
825 reads
Reblog: July 12 to July 18
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-07-18
681 reads
SQL Server: Performance Tuning :Understanding Set Statistics Time output
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning. In this post we will discuss about the Set...
2013-07-18
79 reads
T-SQL Tuesday #44 Wrap UP
Hello Dear Reader, what a busy week we’ve had last week! I’ve got 3 big Thank You’s that I would...
2013-07-18 (first published: 2013-07-15)
1,959 reads
Webcast Presentation Materials: 5 Ways to Improve Performance through Indexing
This past Tuesday, I delivered a presentation for Pragmatic WorksTraining on the T’s. The session I delivered was 5 Ways to...
2013-07-18
755 reads
Amusing SQL Trick – Hide yourself from SQL Server
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
832 reads
Disable the Charms Bar – Making Windows 8 Better
One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves...
2013-07-17
960 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers