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,999 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
679 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
733 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
932 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,532 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,240 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,270 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,912 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,202 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,883 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers