Casino Night is Back
Casino Night from SQL Server Central is coming back to the PASS Data Community Summit.
2024-09-11
409 reads
SQLServerCentral
Adding an AI Policy for Authors
SQL Server Central is changing their policy to respond to the increased use of AI technologies.
2024-02-02
333 reads
Adding Cookie Consent to SQL Server Central
We are adding a consent form to the SQL Server Central website to allow our cookies.
2024-01-10
1,389 reads
SQL Server Central Is Upgrading Our Servers
The SQL Server Central database servers are being upgraded on Thursday, Nov 2.
2023-11-01
655 reads
Reducing the Frequency of SQL Server Central Newsletters
We are reducing the sending of the SQL Server Central newsletter to three days a week.
2021-04-30 (first published: 2021-04-26)
1,177 reads
Do You Still Want Coping Tips?
A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping tips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to think about what we could do to […]
2020-06-16
672 reads
Forum FAQ
With the implementation of the BBPress forums at SQLServerCentral, a few community members have asked how the forums work and how to best use them. This document will address a few of the items that have been asked by users. A list of questions is followed by the answers below. If you have additional questions […]
2020-05-15
256 reads
Blocking Private Messages
A new feature on SQLServerCentral to allow you more control over who can contact you.
2019-12-30
213 reads
SQLServerCentral v3 coming tomorrow
The next version of SQLServerCentral will go love on Saturday, March 30, 2019
2019-03-29
309 reads
Call for Articles
SQLServerCentral is looking for articles on a few topics. Read more to find out how to submit a draft.
2016-08-19 (first published: 2016-08-12)
916 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
