MDX Order by Multiple Criteria
The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression. The syntax of the...
2013-12-08
23 reads
Blog Posts
Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional
OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows...
2013-12-07
8,360 reads
My First Windows Update Gone Bad
I don’t think I’ve ever had a Windows Update go bad - until this week.
I recently upgraded to Office 2013 and late Monday afternoon, decided to check in with...
2013-12-07
5 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.6: Custom Mining Functions
by Steve Bolton
…………In the last installment of this amateur series of mistutorials on SQL Server Data Mining (SSDM), I explained how to...
2013-12-06 (first published: 2013-11-28)
2,678 reads
Decrypting Stored Procedures Thanksgiving Special:Quick Tips
Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner...
2013-12-06 (first published: 2013-11-28)
3,486 reads
Friday Followup For December 6, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-06
357 reads
Junior DBAs - Where to start?
I personally would start with your local user groups. Getting to know people and networking may be your best bet...
2013-12-06
426 reads
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...
2013-12-06
1,233 reads
Reblog: November 29 to December 5
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-06
823 reads
Speaker of the Month, December 2013
This will be my fifth speaker of the month post. Do a search to see the others.
I try to find...
2013-12-06
619 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers