If You Plan to Publish A SQL Script–Some Suggestions
Nothing better than finding a script that does something you need done and often done better than what you’d put...
2014-02-19
723 reads
Nothing better than finding a script that does something you need done and often done better than what you’d put...
2014-02-19
723 reads
Hopefully you got the email today from PASS containing these:
Volunteer GoalsProgram GoalsSQLSaturday GoalsReading them I’m first struck that we often...
2014-02-19
630 reads
Friday night I took my wife out for Valentine’s Dinner. We had a reservation for 9 pm and I hoped...
2014-02-18
642 reads
If you don’t have kids you might not get the title of the post, it’s part of the theme song...
2014-02-17
627 reads
Amusing myself for a minute at Google Trends. Anyone missing 2005?
2014-02-17 (first published: 2014-02-12)
3,555 reads
Today I watched DATAVIZ YOU THOUGHT YOU COULD NOT DO WITH SSRS by Jason Thomas. The intro felt long, but...
2014-02-14
749 reads
I’ve been trying out the Melitta Coffee Brewer for a few weeks. Not much to it, it’s just a plastic...
2014-02-13
737 reads
I found Tell Me How I’m Doing by Richard L. Williams at the local library. It’s a book about giving...
2014-02-11
606 reads
On Friday I was finally able to spend a couple hours looking at the Redgate Ecosystem, which is essentially a...
2014-02-10
1,020 reads
Today we have a guest editorial from Andy Warren. He talks about strange questions in interviews and whether they help you assess the candidate.
2014-02-07
389 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
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