NTFS Allocation Unit Size
I ordered some new drives for our Dell server from "This Old Store" recently and they came on Tuesday of...
2006-09-08
1,688 reads
Blog Posts
SQL Server 2005 Scripts on TechNet
I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...
2006-09-01
1,458 reads
Dallas Code Camp 2006
Generally I don't look forward to giving up an entire Saturday at work. However, today's Dallas Code Camp was an...
2006-08-29
1,583 reads
Removing SQL Server Express from VS Team System for Database Professionals CTP 5
As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...
2006-08-24
1,385 reads
Downtime
Under the category of working too fast, today's downtime was brought to you by me.
I've been working an issue with...
2006-08-23
1,442 reads
Visual Studio Team System for Database Professionals CTP 5 Out
If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...
2006-08-23
1,429 reads
The Importance of Database Coding Standards
I was working with a developer the other day and the question came up
of how to return status from a...
2006-08-17
1,825 reads
Long Time No See
OK, it's been a long time since I made an entry here, mostly because I've been busy and keep forgetting...
2006-08-15
1,413 reads
2006-08-09
2006-08-09
1,408 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