Degenerate Dimensions
Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...
2011-11-16
4,973 reads
Blog Posts
Identify Risk Early
One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...
2011-11-16
482 reads
SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...
2011-11-16
1,283 reads
SQL Server A to Z – Views
Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...
2011-11-16
1,057 reads
SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-16
12,906 reads
SSWUG SSIS Expo Event This Friday
Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...
2011-11-16
606 reads
Stop SOPA…it already happened in Denmark #StopSOPA
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
551 reads
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The...
2011-11-16
594 reads
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never...
2011-11-16
11 reads
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,877 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers