The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
TSQL Challenge #14
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
COPY_ONLY Backups
What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
Energy Intelligence
Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
Setting up Change Data Capture in SQL Server 2008
Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
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...
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