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
Blog Posts
How many calls – A T-SQL Question
I got a call from a friend recently that was looking for some query help. He was actually using Access,...
2011-12-22
1,302 reads
PASS Summit 2011 Eval Results
My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63....
2011-12-22
643 reads
SQL Server Sample Databases - All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-22
1,244 reads
The #Meme15 Round-Up
The first round of #meme15 has finished. In total, there were eighteen people that participated. If there were more, I...
2011-12-22
846 reads
ETL from Oracle to SQL Server
I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using...
2011-12-21
7,972 reads
Explaining SQLSaturday
I wrote a while back about my coffee cup from SQLSaturday #100. I took it to work (where I usually...
2011-12-21
637 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down...
2011-12-21
1,983 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down thrown the tree trying to find that one specific...
2011-12-21
15 reads
Routing OSPF and Network Team
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
661 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