The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
2008-03-11
95 reads
Editorials
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-10
58 reads
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
2008-03-06
92 reads
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
2008-03-05
110 reads
A New World Record
SQL Server 2008 sets a TPC record. And it hasn't even been released. This editorial was originally published on Mar 4, 2008. It is being rerun as Steve is on vacation.
2008-03-04
164 reads
How to lay out SQL Code
Anyone who inherits a database application dreads poorly laid-out SQL code. Development teams loathe it. Putting it right would be easier, if there was a common, agreed, standard in place, so why the difficulty?
2008-03-03
225 reads
Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.
2008-02-29
123 reads
The February Energy Update
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
2008-02-28
61 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-27
72 reads
2008-02-25
25 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