Notes from SQLSaturday #801 (2018)
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
256 reads
Blog Posts
SQL Server 2019
I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to...
2018-10-20
275 reads
Sharding: Horizontal Scaling in Azure SQL Database
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,731 reads
SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
274 reads
Contextual View Part II or how to hide sensitive data
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
524 reads
Creating Wait stats widget on Azure Data Studio for macOS
A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...
2018-10-18 (first published: 2018-10-09)
2,545 reads
Step-by-Step: How to Trigger an Email Alert from Windows Performance Monitor
Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...
2018-10-18
1,508 reads
The Project Graveyard
This post is a response to this month’s T-SQL Tuesday #107 prompt by Jeff Mlakar. T-SQL Tuesday is a way...
2018-10-18 (first published: 2018-10-09)
2,724 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
292 reads
Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,054 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