What’s New in the Block Editor: New Page Layout Picker, Better Block Transformation Options, and More
From a new page layout picker to a more streamlined writing prompt, we’re bringing you the latest round of editor improvements.
2021-04-15
35 reads
Blog Posts
Daily Coping 14 Apr 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-04-14
50 reads
Introducing Milestone Notifications
Your website is a product of your hard work and passion. Therefore, when your site hits a milestone — it shouldn’t go unrecognized. To make it easier for you...
2021-04-14
10 reads
Modern Data Warehouse & Reverse ETL
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-14 (first published: 2021-04-12)
855 reads
Running Scripts in Parallel with SQL Multi Script
One of the lesser known tools in the Redgate Toolbelt is SQL Multi Script. While few customers used it, those that did loved it, as it solves a problem...
2021-04-14 (first published: 2021-04-05)
456 reads
Become a Contributor to Microsoft Docs
Starting this month, I'm leading a talk series with my teammates from the SQL Docs team at Microsoft. In this presentation we lay out just how easy it is,...
2021-04-13 (first published: 2021-04-08)
184 reads
Daily Coping 13 Apr 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-04-13
36 reads
Help Build an Amazing Summit in 2021
For a good portion of my career, I’ve been going to the annual Summit in the fall with lots of my fellow SQL Server/Data Platform professionals. I have been...
2021-04-13 (first published: 2021-04-07)
138 reads
T-SQL Tuesday #137–Notebook Uses
It’s actually my month to host T-SQL Tuesday, and I came up with the notebook idea last year. Aaron Nelson (b | t) sent me a link to a...
2021-04-13
53 reads
#TSQL2sday #137 Invite Using Notebooks Every Day
It’s time for the T-SQL Tuesday blog party, and I’m hosting this month. I don’t host too often, but since I had some schedule mix ups, I’ll handle this...
2021-04-12 (first published: 2021-04-06)
342 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
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
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...
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