Presenting Biml and Team-based Development at PASSDC and BSSUG
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
566 reads
Sam Vanga
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,362 reads
Get Rid of These 5 T-SQL Bad Habits with SQL Prompt
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
614 reads
Standardize Table Aliases
What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT a.[BusinessEntityID] , b.[FirstName] , b.[LastName]FROM[HumanResources].[Employee] a INNER JOIN [Person].[Person] b ON...
2013-03-05
799 reads
Standardize Table Aliases
What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...
2013-03-05
923 reads
Sparklines and Conditional Formating in SSRS
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
874 reads
Sparklines and Conditional Formating in SSRS
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
499 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,500 reads
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
841 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
810 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers