Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
520 reads
Blog Posts
SQL Server on VMware Boot Camp at VMworld 2018
I am extremely proud to announce that I am presenting in conjunction with VMware Corp. an all-day boot camp for...
2018-07-21
382 reads
Finding Inconsistent Key Values–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-07-20 (first published: 2018-07-11)
1,843 reads
Friday Reading 2018-07-20
Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...
2018-07-20
334 reads
My #SQLCareer Day–July 19
I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but...
2018-07-20
473 reads
Silly Photos at Work
Someone I stumbled across this picture of @brento on my drive.
This might be the best one:
And this was a good...
2018-07-20
327 reads
The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...
2018-07-20
15 reads
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. Some...
2018-07-20 (first published: 2018-07-10)
2,190 reads
Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers...
2018-07-19
891 reads
Code I Can’t Live Without–T-SQL Tuesday #104
Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without....
2018-07-19 (first published: 2018-07-10)
3,701 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...
Kamagra Oral Jelly 100 mg to Treat Sexual Problems
Kamagra Oral Jelly 100 mg is a medication used to treat erectile dysfunction (ED)....
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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