Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,114 reads
SQL RNNR
Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put...
2011-08-16
9 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method...
2011-08-15
1,320 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send...
2011-08-15
12 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had...
2011-08-11
505 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had the week available in order to attend. I finally...
2011-08-11
1 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and...
2011-08-10
730 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting...
2011-08-10
3 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
671 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with...
2011-08-09
6 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