Article: SQL Server Sample Databases
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
240 reads
Blog Posts
PostgreSQL 17: A Deep Dive into New Features, Benefits, and Enterprise Impact
PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release focuses on performance, scalability, developer productivity, and enterprise-grade reliability. Each feature in PostgreSQL 17 is...
2025-07-21
1,040 reads
The Evolution of Data: From Databases to Spark to Lakebases
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling their jeans or people with bellbottoms or the 80’s music playing in grocery stores… It’s...
2025-07-18
115 reads
PostgreSQL Timeline: History and Evolution
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-17
98 reads
Why Microsoft Fabric Signals the Next Wave of Data Strategy
In today’s data-driven economy, organizations are no longer asking if they should invest in data, they are asking how fast they can turn data into decisions. The answer, increasingly,...
2025-07-17
312 reads
DP-203: The Complete Guide to Becoming a Microsoft Azure Data Engineer Associate
In today’s data-driven world, organizations rely on skilled professionals to design, build, and maintain scalable data solutions. The DP-203: Data Engineering on Microsoft Azure certification is your ticket to...
2025-07-16
101 reads
SQL Server Database Compatibility Levels
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve ever upgraded a SQL Server instance and something just broke in your application, chances are...
2025-07-16
454 reads
Understanding Zonal Redundancy in Azure SQL MI
Do you know what happens when you enable zonal redundancy for your SQL managed instance? Lets define it first (in the context of Business-Critical tier) – zonal redundancy is...
2025-07-16
89 reads
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from failure — and why most companies still underestimate what it really takes to turn strategy...
2025-07-15 (first published: 2025-07-14)
27 reads
Azure SQL Managed Instance: Boost Performance with Read-Scale Out
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary...
2025-07-15
108 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers