Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
503 reads
Blog Posts
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
293 reads
SQL New Blogger Challenge: Looking back… and a new challenge!
A little over six months ago, I suggested the SQL New Blogger Challenge. I thought that maybe a few people...
2015-10-27
443 reads
Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN.
Connecting to a data source can be time consuming. To...
2015-10-27 (first published: 2015-10-20)
5,092 reads
Extended Events Intro
Extended Events is supposed to be taking over for most of Profiler and server-side tracing functionality, but there were people...
2015-10-26
1,525 reads
Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
486 reads
Networking Tonight at the YardHouse in Seattle
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
549 reads
Networking Tonight at the YardHouse in Seattle
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
403 reads
Of clustered indexes and ordering
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,820 reads
Short Circuit Events
I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading...
2015-10-26
607 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
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
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...
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