Adding Space to a Home Server
I got new drives for my Windows Home Server the other day and decided to add some space to the...
2010-05-27
1,042 reads
Blog Posts
Becoming a Part of the SQL Server Twitter Community
There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have...
2010-05-27
747 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,441 reads
Challenge 19 – An Explanation of a Query
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...
2010-05-27
1,705 reads
Follow Up On My Keynote Survey
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
619 reads
IndyTechFest 2010 a Big Hit
Jesse Liberty,a Developer Community Program Manager for Microsoft, starts off IndyTechFest 2010 with the keynote presentation.
On Saturday, May 22, 2010,...
2010-05-27
472 reads
North Texas SQL Server User Group Offers Innovative Educational Series
On Thursday, May 20, 2010, I had the opportunity to speak at the North Texas SQL Server Users Group, which...
2010-05-27
478 reads
SQLSaturday #49 Planning Update
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
480 reads
The SSIS Data Flow is Like... an Automotive Assembly Line
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
465 reads
When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,728 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