Operation Souza
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...
2014-10-13
844 reads
Blog Posts
SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to...
2014-10-13
1,154 reads
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
41 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,196 reads
My Best Technical Sites and Blogs
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,469 reads
SQL Server proxy account and local policy
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,287 reads
Checking out Windows Server Technical Preview on Azure !
I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to...
2014-10-10 (first published: 2014-10-04)
6,158 reads
Friday Followup For October 10, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-10
465 reads
Monday Night Networking Dinner at PASS Summit 2014
For the fifth year Steve Jones and I are organizing the Monday Night Networking Dinner at the PASS Summit. It...
2014-10-10 (first published: 2014-10-02)
6,064 reads
PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
650 reads
Blogs
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...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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