Devil's Advocate
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
2011-08-22
120 reads
Chris Massey
What's holding you back?
If you’re not where you want to be in your career, then what do you think is holding you back?
2011-06-13
207 reads
Wish you were here?
As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.
2011-05-16
76 reads
Do we do enough?
Do we, event organizers, tool vendors, concerned SQL citizens, as a community, do enough to reach people who don't know about the training available to them?
2011-04-18
102 reads
(Un)Common Speed Phreakery
Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.
2010-08-09
163 reads
GOSQL vs. NOSQL
If we're getting pulled down a blind alley by acronyms, we may as well make up a more optimistic one.
2010-07-12
312 reads
Oracle: Overhaul or Overkill?
Vendor-specific hardware might make Oracle less painful to use in the future, so Chris Massey considers whether Microsoft should consider providing a more tailored and complete product with SQL Server. The verdict? "Not necessary".
2010-02-22
150 reads
Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
256 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
