SQLDay 2019 – Day 2
Tuesday is the day when SQLDay starts. The doors are opened from 8am but the show begins with a keynote at 9am. This year the keynote talk was done...
2019-05-15
13 reads
Coding Family
SQLDay 2019 – Day 1 – workshops
Today it was a workshop day at SQLDay. Five workshops (one unfortunately has been cancelled). I think at least 300-350 people have attended the conference during the first day....
2019-05-14
26 reads
Interview with Robert Farley
This is the third interview we have done. This time our guest is Robert Farley who can be also recognized as the famous guitar player! Here you can find...
2019-05-10
48 reads
Weekly reading #14
SQLDay starts in a week! Stay tuned during this week as it could be full of surprises! We are ready & prepared and speakers start to arrive next Saturday!...
2019-05-05
16 reads
#Operators in Python with Dominika
It’s been long time ago I published the last article. I had exams at school and worked hard to pass and have a good grades. Now I have some...
2019-04-30
20 reads
Weekly reading #13
#13, #13, #13 – that must be a good week! This firs week of May we call a “long weekend” as we have at least 2 days off! This...
2019-04-29
38 reads
Interview with Andre Melancia
This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!
2019-04-24
42 reads
Weekly reading #12
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family...
2019-04-22
14 reads
Weekly reading #11
Good day folks! Let’s make this week great (again)! It is spring already there so it is easy to get up at 6am and write the blog! Now looking...
2019-04-15
52 reads
Global AI Night at WSB in Chorzów
The 2nd of April 2019 was a big day because of the two global IT events. The one was for developers as a new Visual Studio 2019 was born....
2019-04-13
40 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