I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...
2021-05-12 (first published: 2021-04-27)
999 reads
It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...
2021-05-12 (first published: 2021-04-28)
944 reads
In February 2011, Pat Wright invited us to talk about Automation: So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or...
2021-05-12
11 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-11
12 reads
This month’s T-SQL Tuesday is hosted by Andy Leonard who has poised the question ‘What do you do when technology changes underneath you?’ I was going to begin by...
2021-05-11
17 reads
This month the topic for T-SQL Tuesday comes from Andy Leonard, whom I reached out to be a host. I was running low on hosts last year, and Andy...
2021-05-11
40 reads
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2021-05-11
93 reads
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2021-05-11
3 reads
This month’s T-SQL Tuesday is hosted by Andy Leonard who has poised the question ‘What do you do when technology changes underneath you?’ I was going to begin by...
2021-05-11
4 reads
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes ... Continue reading
2021-05-11
17 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