Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
282 reads
Koen Verbeeck
The times they are ae-changing
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...
2017-08-03
368 reads
Microsoft Professional Program in Data Science – Continued
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...
2017-06-27 (first published: 2017-06-19)
2,857 reads
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,584 reads
Microsoft Professional Program in Data Science – The Road So Far
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open...
2017-05-26
1,356 reads
Power BI Announcements Summary
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap...
2017-05-05
1,374 reads
Book Review – The Truthful Art
I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about...
2017-04-28 (first published: 2017-04-21)
1,270 reads
PASS BA Marathon – Spring Edition Q&A
The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar...
2017-04-19
747 reads
T-SQL Tuesday 89 – Roundup
I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how...
2017-04-18
417 reads
T-SQL Tuesday #89 – The times they are a-changing
This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the...
2017-04-19 (first published: 2017-04-11)
1,747 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
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...
Forums
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
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...
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