Friends of Redgate 2015
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
816 reads
WaterOx SQL
Identify Primary Keys That Are Not Identity Columns
Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...
2015-01-13
1,148 reads
Have We Devalued SQL Server Consulting?
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...
2014-11-21
616 reads
Have We Devalued SQL Server Consulting?
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
336 reads
12 Things To Check With SQL Server To Prepare For Winter
Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...
2014-11-14
1,065 reads
12 Things To Check With SQL Server To Prepare For Winter
Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...
2014-11-14
635 reads
Versioning In Your SQL Database
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...
2014-11-12 (first published: 2014-11-07)
6,991 reads
Versioning In Your SQL Database
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
638 reads
When Things Align Unexpectedly
Things are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am...
2014-11-02
872 reads
When Things Align Unexpectedly
Reading Time: 4 minutesThings are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...
2014-11-02
405 reads
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