The One Piece of Career Advice I Wish I’d Gotten
Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...
2017-12-12 (first published: 2017-11-29)
2,520 reads
Blog Posts
T-SQL Tuesday #098–2018 Goals
A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic...
2017-12-12
482 reads
T-SQL Tuesday #97 – We don’t need no Education! (or do we?)
TweetG’day,
Well, it’s T-SQL Tuesday time again -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This...
2017-12-12
527 reads
When Best Practices Aren’t Best
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
389 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices,...
2017-12-11
443 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
10 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
10 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,250 reads
Database Fundamentals #15: Modifying Data With T-SQL
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,786 reads
Microsoft to Decommission Connect on 12/31/2017
Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...
2017-12-11
443 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...
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