Daily Coping 15 Jul 2021
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-07-15
6 reads
Blog Posts
Accessibility after the fact: closed captions for videos
My user group, the Calgary Data User Group, has been recording videos since April of this year, so at the time of this writing we have just two videos...
2021-07-14
12 reads
Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
One of the biggest impacts on resource consumption for Azure SQL DB are repeated data pulls by the application layer. No matter how fast those queries execute calling the...
2021-07-14
51 reads
Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox
One of the biggest impacts on resource consumption for Azure SQL DB are repeated data pulls by the application layer. No matter how fast those queries execute calling the...
2021-07-14
88 reads
Basic Window Functions–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Window functions are a class of functions that...
2021-07-14 (first published: 2021-07-07)
611 reads
Daily Coping 14 Jul 2021
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-07-14
14 reads
Executing Azure Data Factory pipelines by Power App / Automate Flow
(2021-Jun-30) One of my university professors liked to tell us a quote, “The Sleep of Reason Produces Monsters”, in a way to help us, his students, to stay active in...
2021-07-14 (first published: 2021-06-30)
3,553 reads
Getting Row Numbers with Window Functions–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a recent post, I started looking at...
2021-07-14
137 reads
Build a Blogging Habit with Reminders in Your WordPress App
Meet your posting goals on your site with this new feature in the iOS and Android apps.
2021-07-13
26 reads
Daily Coping 13 Jul 2021
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-07-13
12 reads
Blogs
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...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
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