(last updated: 2021-08-13 @ 19:50 ET / 2021-08-13 @ 23:50 UTC ) In a previous post, Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC), I explained how...
2021-08-25 (first published: 2021-08-13)
527 reads
During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10...
2021-08-25
63 reads
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-08-24
17 reads
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to ... Continue reading
2021-08-24
153 reads
As a Software Engineer, I will like to detect security vulnerabilities early enough in my codebase before committing my code.
Detecting security vulnerability is very important in SDLC (Software Development Life...
2021-08-24
9 reads
I've had a few recent conversations where customers/partners were encountering scale concerns in existing timeseries database applications hosted outside of Azure, and wished to explore the native services in...
2021-08-24
22 reads
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-08-23
12 reads
Recently I ran into a customer that was having issues deploying code from their development system to their production system. The issue was that they often found that the...
2021-08-23 (first published: 2021-08-09)
160 reads
Fascination has always been with me when thinking of developing local talent. It has helped me immensely in my career both as an attendee, presenter, chapter leader, and more....
2021-08-23
90 reads
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to leverage Subflows to better organize your
2021-08-23 (first published: 2021-08-10)
376 reads
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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