Upcoming Free Webinars on Database Development and Operations
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
6 reads
2019-11-16
9 reads
2019-11-16
12 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
24 reads
2019-11-06
5 reads
2019-11-06
10 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
12 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
20 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
9 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
7 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
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:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
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
