2014-03-31
1,565 reads
@chuckboycejr
Correlation Does Not Imply Causation
One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...
2014-02-11
1,502 reads
Why no discussion of MarkLogic / NoSQL security in light of Obamacare security fiasco?
We are awaiting Polar Vortex 2 in New England and are set to have more snow dumped on us starting...
2014-01-21
1,076 reads
Best advice I ever got on negotiating consulting rates and salary negotiations
Back when I was getting ready to take the plunge and begin consulting I sought advice from a friend who...
2014-01-20
789 reads
sometimes, you have to piss people off
Just a quick note today on being effective.
For better or for worse, I was raised by parents who had me...
2014-01-16
667 reads
2013-12-24
581 reads
Microsoft, can you please elaborate (Caution about CredSSP)?
Microsoft publishes the following caution about enabling the CredSSP Windows Group Policy:
Caution: Credential Security Support Provider (CredSSP) authentication, in which...
2013-12-04
906 reads
JFK
“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...
2013-11-21
630 reads
hacked
ugggh.
My Drupal site in AWS EC2 was hijacked and is being used by the hijackers to do port scans.
Who said...
2013-11-06
604 reads
If you buy a Hyundai, don't expect BMW results
This sort of ties in to my last post on denying reality.
Managing expectations is the most important thing to success...
2013-10-11
696 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers