What is KTLO? Keep The Lights On vs Project Work in Agile
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT and Agile In the realm of IT operations and software development, not all tasks are...
2025-07-10
32 reads
Blog Posts
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet in question was New-AzRoleAssignment, but the cmdlet itself isn’t important. What is important is that...
2025-07-09
66 reads
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
As data becomes the backbone of modern business, understanding how to manage and analyze it in the cloud is a must-have skill. The DP-900: Microsoft Azure Data Fundamentals certification...
2025-07-09 (first published: 2025-06-22)
317 reads
SQL Server Auto-settings: The Good, the Bad, and the Ugly
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL Server database and just left the default settings alone, you’re not alone. Microsoft provides a...
2025-07-09
105 reads
SQL Server Editions: What’s the Difference and Why It Matters
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server instance but don’t live and breathe licensing, you’re not alone. Many IT managers and sysadmins...
2025-07-09 (first published: 2025-06-25)
442 reads
The PASS Summit on Tour in Dallas
The PASS Summit goes on tour this year, with a September stop in Dallas. This is the first event in the series, and I’m excited to go back to...
2025-07-09
68 reads
Azure Cloud Chronicles with Microsoft MVPs YouTube Channel
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with Microsoft MVPs channel popped up and when I went to it, I noticed that the...
2025-07-08
21 reads
T-SQL Tuesday #188: Growing the Community
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has been a great help in multiple communities over the years, and he has quite an...
2025-07-08
103 reads
T-SQL Tuesday 188 - Growing the Younger Data Community and Speakers
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, John Sterrett
(blog) asks us:
What are you doing, or what can we do...
2025-07-08
16 reads
Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that has evolved over decades. It is known for its reliability, feature richness, and strong community...
2025-07-08
81 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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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