Final Prep for SQL in the City
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me...
2014-10-13
924 reads
Blog Posts
Invite for #TSQL2sday #59 – My Hero!
It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday,...
2014-10-13 (first published: 2014-10-08)
5,211 reads
Last Weeks Top “Reading” Links #104
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-13
1,050 reads
Notes From the October 9, 2014 Space Coast SQL Meeting
Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have...
2014-10-13
910 reads
Operation Souza
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...
2014-10-13
844 reads
SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to...
2014-10-13
1,154 reads
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
39 reads
You can’t use aggregate/windowing functions with CROSS APPLY
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well...
2014-10-13 (first published: 2014-10-06)
9,195 reads
My Best Technical Sites and Blogs
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,469 reads
SQL Server proxy account and local policy
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,286 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