Yet another newsletter
I’ve been thinking about starting a newsletter for a while now. I want to focus on summaries and what stood out for me from among the many cool talks...
2023-08-30 (first published: 2023-08-14)
168 reads
Blog Posts
Chicago Database DevOps in a Day Workshop
I’m heading to Chicago today for the Redgate Database DevOps in a Day workshops. This is the first of many on the US tour. I’ll be at 5 of...
2023-08-29
13 reads
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
For a very important client, I currently manage over 200 SQL...
2023-08-29
41 reads
How to Create a Time Table in Power BI Using DAX
Lately, I’ve been having to create items in Power BI, that I haven’t had to do for a while, this week it was a Time table. Of course, I...
2023-08-28 (first published: 2023-08-11)
457 reads
Serving layers with a data lake
Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is...
2023-08-28 (first published: 2023-08-09)
400 reads
A New Word: mahpiohanzia
mahpiohanzia – n. the frustration of being unable to fly, unable to stretch out your arms and vault into the air, having finally shrugged off the burden of your...
2023-08-25
54 reads
Finding Identity Columns–#SQLNewBlogger
I had to find a set of identity columns recently and through this would make a good blog post. Another post for me that is simple and hopefully serves...
2023-08-25 (first published: 2023-08-02)
1,775 reads
Open Online Community Hangout During PASS Summit
Are you bummed that you can’t attend the PASS Data Community Summit conference in-person this November during the week of November 13? There’s lots of reasons to be there,...
2023-08-25
18 reads
T-SQL Tuesday #165 Job Titles – What do you need?
My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out...
2023-08-25 (first published: 2023-08-08)
176 reads
Using Secrets in Docker Swarm for SQL Server
In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...
2023-08-23 (first published: 2023-08-02)
210 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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