A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
Connection strings for SQL Server 2008
A set of different connection strings for using with different providers for SQL Server.
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
Using T-SQL to Transform XML Data to a Relational Format
More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.
Running a Small User Group - Getting Quality Speakers
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
The SQL of Scrabble and Rapping
In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers