The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
Sample Chapter from Murach's SQL Server 2008 for Developers
Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a database table. In the process, you’ll master the basic skills that you’ll use in coding almost any SELECT statement, no matter how complex. At that point, you’ll be ready to learn how to code joins, summary queries, subqueries, and action queries, and then move on to working with server-side features like cursors and stored procedures.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Creating Hierarchical Data Structure Mashups
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
Using CROSS JOIN queries to find records out of sequence
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
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