An interesting AI experiment here with Copilot from GitHub in handling some code I don’t work with that often. Read on and watch. This is part of a series...
2024-11-06 (first published: 2024-10-16)
357 reads
How can you achieve good enough without compromising the process/product? In the world of database technology, striving for perfection is a double-edged sword. While high standards are important for...
2024-11-05
30 reads
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and flying to Seattle for the PASS Data Community Summit 2024. I’m very lucky that I...
2024-11-04
12 reads
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
679 reads
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but …
reading the extended event...
2024-11-04 (first published: 2024-10-18)
421 reads
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling Monday to the event to see a few thousand fellow data professionals, developers, managers, and...
2024-11-01
26 reads
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional farewell but then unexpectedly have a little extra time together, wordlessly agreeing to pretend that...
2024-11-01
104 reads
I need to migrate from a single server to a flex server. Instead of doing a dump and restore, I’m going to try out the migration service that Azure provides. Single...
2024-11-01 (first published: 2024-10-17)
219 reads
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email, ads, etc. My MCADAA exam started with an entire section on it. I’m trying to...
2024-11-01 (first published: 2024-10-18)
580 reads
SQL Server Audit is an efficient way to track and log events that occur within the database engine. For on-premises or IaaS environments, those audits can only be stored...
2024-10-30 (first published: 2024-10-15)
396 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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