Proposed SQL Server defaults: cost threshold for parallelism
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
185 reads
Blog Posts
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
11 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
113 reads
Speaking Internationally at SQLBits
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
184 reads
SQL Server 2017 Reporting Services: The Basics Part 1
I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I...
2019-02-13 (first published: 2019-01-25)
3,781 reads
SQLSaturday Krakow #824
Demo time – last preps!
SQL Saturday started on Friday with three preconfs. Kevin Boles, Tomasz Cieplak, Tomasz Libera & Grzegorz Stolecki did...
2019-02-13
138 reads
Where have I been?
Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...
2019-02-13
146 reads
Friend of Redgate 2019
The crew at Redgate has deemed me worthy enough to be in their Friend of Redgate program for another year....
2019-02-12
103 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
4 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
5 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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