SQL Server 2017 – Interleaved Execution
I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...
2017-11-20 (first published: 2017-11-09)
857 reads
All About SQL
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
524 reads
Microsoft MVP!?
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
415 reads
Azure SQL Database Automatic Tuning – Questions Answered
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
381 reads
SQL Server Phantom Reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,617 reads
Query Store – SQL Server 2017 vs Azure SQL Database
I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...
2017-11-02 (first published: 2017-10-24)
2,066 reads
Connecting to Azure SQL Database Primary Endpoint – Failover Groups
When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...
2017-10-19
696 reads
SQL Server: What will REPAIR do?
So I had a corruption issue and I was thinking about running repair but I wanted to know what would...
2017-10-24 (first published: 2017-10-16)
2,079 reads
When Things Go Wrong in Azure
Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...
2017-10-12
467 reads
Azure SQL Database Level Firewall Rules
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,710 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers