The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
10 reads
Blog Posts
XML-> JSON document Example
Convert the XML document to JSON document example
<person>
<name>John</name>
<age>25</age>
<address>
<city>New York</city>
<postalCode>10021</postalCode>
</address>
<phones>
<phone type="home">212-555-1234</phone>
<phone type="mobile">646-555-1234</phone>
...
2016-05-24
486 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,991 reads
Monday Morning SQL Break – May 16, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-05-23
364 reads
Monday Morning SQL Break – May 23, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-05-23
411 reads
PASS Board 2016: Update #3
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question...
2016-05-23
398 reads
PowerShell : Scripting Logins, Role Assignments and Server Permissions Using PowerShell
This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the...
2016-05-23
725 reads
Query Store, Forced Plans, and New Plans
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...
2016-05-23 (first published: 2016-05-16)
2,731 reads
SQL Server on VMware Workshop at VMworld
I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US in Last...
2016-05-23
399 reads
The Road to SQLSaturday Orlando – 2016
This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress...
2016-05-23
430 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers