SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
2,374 reads
Ryan Adams
SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download...
2016-03-11
73 reads
Fix a Network Binding Order Warning
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in...
2016-03-03 (first published: 2016-02-26)
1,717 reads
Change Availability Group Endpoint Port
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can...
2016-01-19
1,718 reads
Change Availability Group Endpoint IP
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,536 reads
Could not Register Service Principal Name
Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of...
2015-12-29 (first published: 2015-12-17)
1,572 reads
Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3
I ran across a bug in SSMS 2016 CTP 2 back in August. If you try to right click and...
2015-12-16
441 reads
High Availability and Disaster Recovery Training in Austin
I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery...
2015-12-01
480 reads
Thank You Community
All I can say is, “Wow…Thank you!”. I won a seat on the PASS Board of Directors and it’s very...
2015-10-09
432 reads
PASS Election Questions Answered 2
Today I am going to continue with my PASS Election Questions and Answers series. Here is where you can find...
2015-09-17
614 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