Sub query pass through
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...
2013-03-26 (first published: 2013-03-22)
3,583 reads
Dave Ballantyne
SQL Saturday 194
On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred. A massive thank you...
2013-03-12
661 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
697 reads
Deploying SSRS artefacts using Powershell ( Simply)
As ive stated in the past, i’m presently part of a team on an ALM project for a major UK...
2013-02-12
4,104 reads
Photo cataloguer
If you are anything like me, by know you will have a few thousand digital images spread across multiple directories...
2013-01-20
731 reads
Scaling out SQLLunch UK
As you may be aware, I have been running a lunch time user group ‘SQLLunch UK’ having stolen drawn inspiration...
2013-01-11
665 reads
SSDT – TSQL Unit testing in multiple environments
Late in December, one the long awaited portions of functionality inside SSDT was released to an eager public, that being...
2013-01-07
1,755 reads
When is a whitespace not a whitespace ?
As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...
2013-01-04
1,526 reads
My new favourite traceflag
As we are all aware, there are a number of traceflags. Some documented, some semi-documented and some completely undocumented. Here...
2012-12-06
991 reads
SQL Saturday 194 - Exeter
Many kudos goes to Jonathan and Annette Allen and the others on the team for confirming SQL Saturday 194 in...
2012-12-06
877 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers