Microsoft Ignite Announcements Oct 2022
Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL...
2022-10-18
30 reads
Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL...
2022-10-18
30 reads
Today’s coping tip is to make progress on a project or task you have been avoiding Most of the things I do for work are spent looking in the...
2022-10-17
15 reads
I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.
Older...
2022-10-17
30 reads
Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...
2022-10-17 (first published: 2022-10-04)
929 reads
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
158 reads
Hello Dear Reader! We had a big week on Tales From The Field! We've got some great stuff planned for you this week, but before we get to the...
2022-10-17
29 reads
I’m pleased to announce that I will be presenting at this year’s PASS Summit. PASS Data Community Summit 2022 is the year’s largest gathering of data platform professionals in...
2022-10-16
45 reads
Today’s coping tip is to look for the good in people around you today. I’m working remotely today in New York. I flew up last night to be with...
2022-10-14
26 reads
In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...
2022-10-14 (first published: 2022-10-04)
116 reads
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-14 (first published: 2022-09-29)
295 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers