When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I...
2023-02-14 (first published: 2023-02-13)
43 reads
Today’s coping tip is to thank someone and tell them how they made a difference for you. I’ve had a lot of success in my life, as well as...
2023-02-14
6 reads
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...
2023-02-14
15 reads
Today’s coping tip is to show an active interest by asking questions when talking to others. I listen more and more these days. I’m trying to input less and...
2023-02-13
10 reads
The question came up that someone wanted to monitor the queries impacting tempdb using Extended Events. Initially, I was pretty sure that there was no real way to do...
2023-02-13
20 reads
Hello Dear Reader! We had a great last week on Tales from the Field. This weekend was also a really nice one. On Saturday a group of friends gathered...
2023-02-13
23 reads
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when...
2023-02-13 (first published: 2023-02-01)
2,797 reads
Today’s coping tip is to send a message to let someone know you’re thinking of them. I reached out a friend the other day, someone I know from the...
2023-02-10
22 reads
Today’s coping tip is to write down your hopes or plans for the future. Hopes are vague, and plans are easier, so here are some plans: Plan a trip...
2023-02-09
33 reads
Typically you have a bunch of pipelines that are started by one or more triggers. Sometimes, a pipeline needs to be manually triggered. For example, when the finance department...
2023-02-08 (first published: 2023-01-25)
217 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