You’re doing your POC wrong! : T-SQL Tuesday #152
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
384 reads
Blog Posts
Daily Coping 26 Jul 2022
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...
2022-07-26
8 reads
Daily Coping 25 Jul 2022
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...
2022-07-25
12 reads
Database Fundamentals #32: Create Unique Constraints with T-SQL
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
88 reads
New Database Job – The 90 Day Plan
In my first post, I reference that by the end of your first 30 days you should have a 90-day plan of things to tackle at your job and...
2022-07-25 (first published: 2022-07-12)
556 reads
Talking DevOps with Scott
The SQL Solutions Group asked me to do a webinar with them, which is still an honor for me. They’ve been working with various clients on DevOps development practices,...
2022-07-25
19 reads
T-SQL Tuesday #152 – The crazy login client
This month’s T-SQL Tuesday is hosted by Deborah Melkin(b|t), and she has an interesting topic. She wants us to write a rant on a scenario we encountered at a...
2022-07-25 (first published: 2022-07-12)
324 reads
Adopting a DevOps Process for your Database – SQL Saturday New Jersey 2022
I had a great talk today at SQL Saturday New Jersey 2022 on DevOps and databases. Good crowd and good questions. Got caught in a spotlight picture as well:...
2022-07-23
31 reads
Daily Coping 22 Jul 2022
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...
2022-07-22
21 reads
Register as a Pre-Con Speaker
I’ve been debating how we better organize speaker resources and one of the things I proposed was a pre-con registry of speakers. I did so at the sqlsaturday blog....
2022-07-22 (first published: 2022-07-13)
74 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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