Ideas are a work of art
When you think about it, most of us in the IT field are paid to solve problems. Sure there are...
2009-08-21
381 reads
Blog Posts
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,412 reads
SQL Down Under Code Camp to be Held in October
If you live in Australia, or are just looking for an excuse for a vacation in Australia, sign up for...
2009-08-21
661 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
700 reads
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,269 reads
SQL Quiz #5 – SANs the Star the Show Must Go On(Mirroring)?
Okay, Jorge Segarra (@SQLChicken) tagged me in Chris Shaw’s (@SQLShaw) latest SQL Quiz, SAN’s and Mirroring. I’m a little behind...
2009-08-21
337 reads
The Kindle Update - A Month on the iPhone/iTouch
Ever since my Kindle broke, I've been reading on my iTouch for the most part. I've been using both the...
2009-08-21
773 reads
What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,325 reads
Costco & Blueberry Muffins
You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there...
2009-08-20
567 reads
Managing Your Database
It seems that I see posts like this one more often than I'd like. Or at least some variation on...
2009-08-20
861 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