A Welcome Delay
An open letter to Microsoft from the CEO of Mandriva Linux might not have been the best idea.
Null Defaults
Today Steve Jones asks what default values you might choose for new columns in a table.
Usage of CTE - Trick with Dates
This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.
Clone a SQL Server login and password to a new server
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
Configure SSRS with an SSL Certificate
A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.
Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
Detecting Issues
How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.
Stairway to U-SQL Level 13: SQL.MAP
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
DevOps and “Shift Left” for Databases
The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least...
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