Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
8 reads
Blog Posts
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
4 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
3 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
5 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
2 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
10 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
3 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
5 reads
SSIS Logging – Linking sysssislog with custom log
I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...
2021-07-05 (first published: 2021-06-21)
466 reads
Are You a Diverse User Group or Event?
One of the things that I’ve seen crop up at various points in my career is a question of diversity. I know there are many people that don’t think...
2021-07-02 (first published: 2021-06-18)
171 reads
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers