Why Do All Funnel Charts Look The Same?
Something recently occurred to me. I’ve been researching chart and dashboard
design standards for an article I’m working on, and the...
2011-01-12
668 reads
SQL Server BI Blog
What’s Going On at Microsoft?
Last week Donald
Farmer announced that he was leaving his long-time position as Microsoft’s lead
BI technology evangelist for QlikTech, a small...
2011-01-11
707 reads
Rich Embedded Text Formatting in Reports
I’ve recently come to realize what a truly remarkable feature it is to be able to
format report text using simple...
2011-01-11
774 reads
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source,
write a SQL query, optimize the...
2011-01-05
947 reads
Blogging on Blogging
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,448 reads
Happy Holidays
I hope everyone is enjoying the holidays. To everyone in the SQL Server community,
Merry Christmas and Happy New Year. Spend...
2010-12-27
969 reads
Dashboard and KPI Design–the Definitive Industry Standard
First of all, the title is intended to be
a little tongue-in-cheek – just a little bit. I’ll explain. Last week
while I...
2010-12-15
435 reads
Preventing Subscriptions from Blocking Interactive Report Executions
A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server. They manage a busy...
2010-12-15
651 reads
Are You Ready to Move to SharePoint for Microsoft BI?
I’m interested in hearing your response to this question. Microsoft is investing
aggressively in delivering Business Intelligence as a holistic platform...
2010-11-24
532 reads
Self-service Reporting in SQL Server “Denali”
Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...
2010-11-14
614 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