Azure SQL database SKU selection
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
121 reads
Blog Posts
Data Saturday #8–Southwest US
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
17 reads
Data Weekender v3.1
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
21 reads
Thanks Kathi and Mala
I have to thank Kathi and Mala for putting on the WIT Mental Health and Wellness today today. I was honored to present, but I was more glad that...
2021-05-08
21 reads
Altering a Computed Column in a Temporal Table in Azure SQL
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data stored in the table at any point in time by storing an effective dated version...
2021-05-07 (first published: 2021-04-22)
210 reads
Basic OFFSET–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I saw an article on...
2021-05-07 (first published: 2021-04-21)
379 reads
Daily Coping 7 May 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-07
10 reads
Goal Progress for April 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-05-07
12 reads
Understanding NUMA in SQL Server VMs
Last Updated on January 8, 2022 by John Morehouse What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows...
2021-05-07
302 reads
A notebook, a guideline, and a workshop
I've come to the conclusion that most of us need to hear this: You cannot do Bullet Journaling wrong; your journal is a tool that's there for you, not...
2021-05-06
27 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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