Multiserver Queries

Setting up registered servers and practical uses of multiserver queries in SSMS.

Multiserver Queries

You can run queries against multiple servers at once, and it’s quite useful for a number of reasons.  I use...

A first look at SQL Server 2016–String_split

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...

Goodness-of-Fit Testing with SQL Server Part 6.2: The Ryan-Joiner Test

By Steve Bolton
…………In the last installment of this amateur series of self-tutorials, we saw how the Shapiro-Wilk Test might probably...

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...

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...

The Virginia Tour 2016

Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:

An Experiment with Deadlocks...

The Virginia Tour 2016

Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...

Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....

Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which...