Speaking for Future Data Driven Summit 2023
I am excited to announce that I have been selected to speak for the Future Data Driven Summit 2023. This is a free online conference, on Wednesday, 27-September-2023, for...
2023-07-03
30 reads
Blog Posts
What Happens in the Background when Executing Queries with Always Encrypted
In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...
2023-07-03 (first published: 2023-06-15)
244 reads
A New Word: Licotic
licotic – adj. anxiously excited to introduce a friend to something you think is amazing – a classic album, a favorite restaurant, a TV show they’re lucky enough to...
2023-06-30
21 reads
The New Redgate Office in Cambridge
I’m in Cambridge, UK this week for the internal Global Marketing Week and Level Up Conference. This is my first visit to Cambridge in 2023, and we have a...
2023-06-30 (first published: 2023-06-14)
258 reads
Twenty Years as a Guardian ad Litem
Twenty years ago, I stood in a courtroom and took an oath for a volunteer job I had no idea I would fall so much
The post Twenty Years as...
2023-06-30 (first published: 2023-06-26)
203 reads
Azure chaos STUDIO
Chaos engineering is fun but especially important when building solutions in the cloud. It is great leveraging the cloud to build something, whether that’s a globally distributed website with...
2023-06-28 (first published: 2023-06-08)
268 reads
Code signing for mere mortals
Well, turns out code signing is pretty complex, so I’m writing this blog post as a guide for my future self. I hope he will appreciate, and perhaps some...
2023-06-28 (first published: 2023-06-10)
340 reads
Typing Strange Characters–#SQLNewBlogger
I’ve had to type a few non-English characters lately, and this blog talks about how to do this. Another post for me that is simple and hopefully serves as...
2023-06-28
371 reads
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2023-06-28
153 reads
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that aims to improve the performance of parameterized queries. It is part of the Intelligent Query...
2023-06-26 (first published: 2023-06-08)
329 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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