Cloud computing is essential for modern development, data storage, and scalable applications. Setting up your first cloud environment is a valuable skill, and you can begin without spending any...
2025-07-15
33 reads
The PASS Summit goes on tour this year, with the final date the first few days of October in the Netherlands, Utrect to be exact. This is the first...
2025-07-15
43 reads
I recently had to copy an Azure SQL database (SQL db) from one subscription to an Azure SQL Server instance ... Continue reading
2025-07-14
326 reads
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming how we live, work, and interact with technology. From personalized recommendations to AI-generated art, the...
2025-07-14 (first published: 2025-06-23)
398 reads
The internet relies on IP (Internet Protocol) addresses to identify devices and route traffic. Two versions of IP exist today: IPv4 and IPv6. While IPv6 was introduced to overcome...
2025-07-14
46 reads
During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate...
2025-07-14 (first published: 2025-06-23)
300 reads
AI is no longer a niche capability – it is a leadership catalyst. As Microsoft continues to push boundaries with tools like Azure and Fabric, the demands on today’s...
2025-07-14
19 reads
A friend was asking for help with some data analysis. This was in PowerBI, and the source data was PII. I asked them to mask the data for me...
2025-07-14
32 reads
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call is about various ways to grow young data community/speakers. I’m going to take a brief...
2025-07-13
21 reads
I may think I'm trying to reach the crowd, but I'm really trying to reach each person within the crowd. The "crowd" doesn't actually exist.
2025-07-11 (first published: 2025-06-24)
110 reads
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
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...
Comments posted to this topic are about the item Learning From Breakage
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Comments posted to this topic are about the item 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