how to get ahead
Many people have ideas as to how to do well in life. Of course, many people do not even agree...
2012-12-05
1,640 reads
@chuckboycejr
should I use clustering on a VM?
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...
2012-11-28
878 reads
thanks for Bud
My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I...
2012-11-22
826 reads
blogging fun: dealing with spammers like Psychz Networks
@PsychzNetworks is spamming me non-stop. Every minute of every day.
I googled them and it seems Psychz Networks are famous for...
2012-11-21
1,504 reads
[video] Inside Tempdb - Bob Ward
Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...
2012-11-20
2,474 reads
Bob Duffy
ok, everyone has their favorite SQL guru and favorite SQL tips. There are some people whose names you associate with...
2012-11-19
920 reads
circle of trust
I have heard it said that a former US President once remarked "People tell you who they are by their...
2012-11-16
662 reads
"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
686 reads
problem solving: sometimes you need to walk away from a problem to solve it
If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and...
2012-11-14
717 reads
How to obtain the version and license for a Red Gate SQL BACKUP install
/*
here is a little script I've hobbled together that I use to get version and license info for a Red...
2012-11-13
1,150 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