Spider-Man Homecoming Twitter Sentiment
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
2 reads
SQLBalls
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,229 reads
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40. A little wiser? Maybe. Despite...
2017-03-01
2 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to...
2017-02-28
910 reads
How Do I Add an R Package to SQL Server from In-Database R?
Hello Dear Reader! I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so...
2017-02-28
6 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network,...
2017-02-07 (first published: 2017-02-03)
1,857 reads
The High Availability Conversation Part 1: Introduction
Hello Dear Reader! Twitter is a fantastic tool if you use SQL Server. It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...
2017-02-03
5 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,319 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem. They had a large amount of skewness/data skew. This...
2016-12-05
5 reads
SQL Azure, Hekaton, and Bob Dorr is Awesome
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...
2016-08-29
928 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