Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....
2019-11-04 (first published: 2019-10-22)
3,042 reads
One of the follow up items I have from the event was to poll speakers on what hotel they used (see my previous post). In jotting down some notes...
2019-11-04
30 reads
When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:...
2019-11-04 (first published: 2019-10-22)
796 reads
SQL Clone v4 is out, and the big change is the addition of the Teams feature. I guess technically this is just for SQL Clone, which is included in...
2019-11-04
48 reads
So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...
2019-11-04
38 reads
This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications. Have a great week also for those of you...
2019-11-03
17 reads
Almost every year we select an “official” hotel for the event. For those coming in who don’t know the area it’s a way to avoid figuring out what is...
2019-11-03
14 reads
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...
2019-11-02
17 reads
Hello, it’s amazing to me how fast the past couple of years have gone by as I’ve served on the PASS Board. It has been a journey that has...
2019-11-02
18 reads
One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading
2019-11-01 (first published: 2019-10-21)
469 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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