#PASSDataSummit – Keynote 1 Live Blogging
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-16
23 reads
Blog Posts
Creating a STONITH resource for a pacemaker cluster on VMWare virtual machines
A while back I wrote a post about creating a pacemaker cluster to run SQL Server availability group using the new Ubuntu images in Azure. Recently I had to...
2022-11-16 (first published: 2022-11-03)
153 reads
Daily Coping 16 Nov 2022
Today’s coping tip is to change your normal routine today and notice how you feel. I am a person who likes a routine. While I travel a lot and...
2022-11-16
8 reads
Find the Hidden Lego Steve at the Summit
I’m part of a Redgate promotion at the PASS Data Community Summit. They ordered some Lego Steve’s, which will be available at the booth. You can post some photos...
2022-11-16
19 reads
Moving dates to a weekending date
In publishing, and Im sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you...
2022-11-16 (first published: 2022-11-05)
321 reads
Optimized Plan Forcing in SQL Server 2022
I’ve been reading Bob Ward’s book “SQL Server 2022 Revealed” and one of the new features in Intelligent Query Processing (IQP) jumped out at me. Not because it’s going...
2022-11-16
79 reads
PASS Summit 2022 - Pre-Cons Were Amazing!
It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
50 reads
Daily Coping 15 Nov 2022
Today’s coping tip is to sign up to try a new activity, course, or community. I somewhat did this early in the fall by choosing to go through the...
2022-11-15
11 reads
SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
90 reads
Daily Coping 14 Nov 2022
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
15 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers