CONCAT() string function–SQL Server 2012
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
3,998 reads
Sam Vanga
Why did I start blogging?
This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....
2011-12-16
678 reads
T-SQL Tuesday #025 – Tips and Tricks
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
732 reads
Create Drillthrough Reports
Use Actions!
Your user wants a summary report, containing sales for calendar year, for example. When the user clicks on the...
2011-12-06
931 reads
Start Documenting Your Day! Why Now?
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about...
2011-11-30
1,531 reads
New string function in SQL Server 2012 – FORMAT()
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...
2011-11-29
3,238 reads
SSAS Processing Mode (Lazy Aggregations)
Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
Regular....
2011-11-21
3,267 reads
Create Sparklines in SSRS
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2...
2011-11-14
3,909 reads
#SSRS error – An item with the same key has already been added
Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I...
2011-11-10
2,201 reads
Column alias in order by and where
If you ever wonder why column alias can be used in order by and not in where clause, it’s the...
2011-11-08
6,858 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers