New Blog Space
I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.
Older...
2022-10-17
25 reads
Blog Posts
Restore HEADERONLY and FILELISTONLY
Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...
2022-10-17 (first published: 2022-10-04)
915 reads
Tales From The Field Weekly Wrap Up
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
146 reads
Tales From The Field Weekly Wrap Up for the Week of 10-10-2020
Hello Dear Reader! We had a big week on Tales From The Field! We've got some great stuff planned for you this week, but before we get to the...
2022-10-17
22 reads
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at this year’s PASS Summit. PASS Data Community Summit 2022 is the year’s largest gathering of data platform professionals in...
2022-10-16
44 reads
Daily Coping 14 Oct 2022
Today’s coping tip is to look for the good in people around you today. I’m working remotely today in New York. I flew up last night to be with...
2022-10-14
15 reads
DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...
2022-10-14 (first published: 2022-10-04)
115 reads
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-14 (first published: 2022-09-29)
289 reads
Daily Coping 13 Oct 2022
Today’s coping tip is to remind yourself that things can change for the better. It can be easy to get upset/sad/depressed/angry/etc. about the way something is in the world....
2022-10-13
7 reads
Daily Coping 12 Oct 2022
Today’s coping tip is to start your day with the most important thing on your to-do list. I’m writing this on 11 Oct. The most important thing today is...
2022-10-12
13 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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