Monday Morning SQL Break – March 14, 2016
It’s time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter...
2016-03-14
443 reads
Blog Posts
Multiserver Queries
Setting up registered servers and practical uses of multiserver queries in SSMS.
2016-03-14
19 reads
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
714 reads
Pulling data from a non-clustered index
This is one of those things that I found very interesting but figured I’d probably never really use. Of course...
2016-03-14
488 reads
Session Based Wait Statistics in SQL Server 2016
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...
2016-03-14
2,494 reads
SQL Saturday 486: Richmond, VA Precon
Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend...
2016-03-14
1,050 reads
SSRS 2016 – Part 3 Mobile Reports
This is the final post of 3 on SSRS 2016. This time I’m looking at the new SSRS 2016 mobile reports.
Post 1 covered...
2016-03-14
6,272 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
604 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
829 reads
Are You Data Driven? SQL Server 2016 revealed!
By now, all you folks who logged on to watch the ultimate Microsoft Data Driven event, streamed live from New...
2016-03-11
1,256 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers