Checking out Windows Server Technical Preview on Azure !
I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to...
2014-10-10 (first published: 2014-10-04)
6,157 reads
Blog Posts
Friday Followup For October 10, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-10
465 reads
Monday Night Networking Dinner at PASS Summit 2014
For the fifth year Steve Jones and I are organizing the Monday Night Networking Dinner at the PASS Summit. It...
2014-10-10 (first published: 2014-10-02)
6,064 reads
PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
649 reads
Reblog: October 3 to October 9
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-10-10
967 reads
SQLSaturday Orlando Marketing Plan-Part 49 (Plan Notes)
Introduction
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog...
2014-10-10
760 reads
C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,118 reads
Fixing SCOM After a Hardware Upgrade
Quick note in case I need again some day. The team recently moved all the user databases for a monitoring...
2014-10-09 (first published: 2014-10-02)
6,008 reads
Speaker of the Month: October 2014
I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to...
2014-10-09
546 reads
SQL in the City 2014 – Two countries in two weeks
I have had a fairly busy travel schedule the last few years. While I don’t love sitting on airplanes and...
2014-10-09
702 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