Micro Credentials
Today Steve talks about a new way of achieving some certification and education from Microsoft.
2019-11-13
267 reads
Editorials
2019-11-11
346 reads
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
234 reads
The Network Bottleneck
Computer networks are critical for our work, but if they get clogged with new types of data, we might have a problem.
2019-11-08
240 reads
2019-11-07
225 reads
Predictions for PASS
Steve is missing the PASS opening keynote, but he has a few predictions for the day.
2019-11-06
166 reads
Logging Tables
Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?
2019-11-05 (first published: 2015-09-25)
620 reads
2019-11-04 (first published: 2015-11-13)
426 reads
A Faster tempdb
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,153 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
315 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