2025-12-29
75 reads
Misc
Memories of Andrew Clarke, by Simon Galbraith
Simon Galbraith, co-founder of Redgate and one of the creators of Simple Talk, remembers Andrew Clarke
2025-10-24
Don't Forget About Financial Skills
A bit of advice from Steve to ensure you do not neglect the management of your finances for the long term.
2025-09-26
108 reads
Remembering Phil Factor
One of the most prolific and popular authors at Simple Talk has been Phil Factor. He wrote many pieces on all aspects of database work and has probably written more articles on the Redgate Product Learning site than anyone else. He has entertained, informed, and inspired many database professionals in his many years as an […]
2025-09-19
225 reads
2024-11-08
107 reads
2023-05-19
239 reads
How Normal Is Your World?
Steve thinks the world is close to normal for him after the pandemic. What about you?
2023-03-10
153 reads
2022-07-04
94 reads
2022-07-02
85 reads
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
2022-04-29
137 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Create filegroups in partition
I have a table with partition on create_timestamp field. Though we're storing all data...
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
