Multiserver Queries
You can run queries against multiple servers at once, and it’s quite useful for a number of reasons. I use...
2016-03-14
729 reads
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,...
2016-03-13
628 reads
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...
2016-03-12
857 reads
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
77 reads
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,385 reads
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...
2016-03-11
5 reads
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...
2016-03-11
520 reads
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....
2016-03-11
12 reads
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...
2016-03-11
442 reads
Finding Strings
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-11
691 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers