"What's New in SQL 2017?" at the Baton Rouge SQL Server UG meeting
We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech...
2018-02-15
542 reads
SQL Tact
SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0
A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...
2018-01-16 (first published: 2018-01-09)
31,248 reads
SQL Server on TLS 1.2: XEvent session to catch TLS in use
How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column...
2018-01-09
2,410 reads
Our SQL Server 2017 Administration Inside Out fun author survey
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
798 reads
Start/Stop Group of Azure RM VM's
For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had...
2017-12-19
374 reads
Attracting Non-Technical Speakers to Your SQLSat Events
Fellow DBA and community leader Peter Shore of the Columbus SQL PASS UG and SQLSat Columbus OH asked me via Twitter, "What is the...
2017-12-04
389 reads
SQLSat Organizers and UG Leaders Meetings at PASS Summit - Tips and Tricks notes
At the SQLSat Organizers and UG Leaders Meetings at PASS Summit meetings last week, we were given an opportunity to share...
2017-11-06
325 reads
The #SQLSAT Speaker Goodie Bag
Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and...
2017-10-29
611 reads
VS Code: PowerShell and focusConsoleOnExecute
If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your...
2017-10-03
492 reads
Twilight Timezone: Date and Time Architecture in your Applications aka Use DateTimeOffset, Your Future Self Thanks You
Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...
2017-09-14
429 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