The January Car Update - MP3
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-04-29
761 reads
Articles
The January Car Update - WMV
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-04-29
498 reads
The March Car Update
Steve Jones' bimonthly update on the state of transportation and what's happening with his Prius.
2008-04-29
725 reads
The March Car Update
Steve Jones' bimonthly update on the state of transportation and what's happening with his Prius.
2008-04-29
480 reads
The March Car Update
Steve Jones' bimonthly update on the state of transportation and what's happening with his Prius.
2008-04-29
495 reads
How to Handle NULL Values Loaded by SSIS from Excel Files
Using Script Task in SSIS to resolve problem of NULL values loaded from Excel.
2008-04-28
27,785 reads
All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-28
37 reads
All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-28
43 reads
All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-28
30 reads
Connection Strategy for Multiple Database Environments
Greg Larsen looks at one way to design your database connection strategy to simplify changing application connections so you can plug-n-play databases with less administrative overhead when the need arises.
2008-04-28
3,880 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