Setting up my new workstation with some Chocolatey goodness.
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
181 reads
Blog Posts
SQL Server 2022 Query Performance Tuning
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
246 reads
Attending and presenting at conferences
I have attended and presented at a ton of conferences over the years (see the entire list at Presentations | James Serra’s Blog). If you are looking to learn...
2022-11-10
13 reads
Daily Coping 10 Nov 2022
Today’s coping tip is to respond to a difficult situation in a different way. There are plenty of difficult situations I find myself in, some of which create lots...
2022-11-10
9 reads
Thursday is #sqlkilt Day
At the PASS Data Community Summit, Thursday is the day when the Women in Technology (WIT) luncheon takes place. This is an event I’ve come to enjoy as I...
2022-11-10
68 reads
Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
12 reads
Daily Coping 9 Nov 2022
Today’s coping tip is to make time for a friend and have a coffee, meal, or just spend time. It’s been a busy few months for me. Since Sept...
2022-11-09
14 reads
SQL Server Registered Servers
Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.
2022-11-09 (first published: 2022-10-28)
450 reads
The Reason We Use Only One Git Repo For All Environments of an Azure Data Factory Solution
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
307 reads
Daily Coping 8 Nov 2022
Today’s coping tip is to set a goal that brings a sense of purpose for the coming month. For me, I’m going away from primary work to secondary work....
2022-11-08
11 reads
Blogs
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...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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