I'm looking at several new visualization features in SQL Server 2008 R2 Reporting Services and the data bar looks like something that I could really use. Can you provide an example of how to use this in a report?
2010-12-29
4,396 reads
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-29
5,713 reads
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
2010-12-28
1,371 reads
This article shows how to slipstream the SP and CU during the SQL Server setup process.
2010-12-27
3,923 reads
This challenge is a slightly enhanced version of the ‘remove leading zeros’ problem
2010-12-27
1,728 reads
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-27
4,468 reads
Frequently I find myself in situations where I need to insert records into a table in a set-based operation wrapped inside of a transaction where secondarily, and within the same transaction, I spawn-off subsequent inserts into related tables where I need to pass-in key values that were the outcome of the initial INSERT command. Thanks to a Transact/SQL enhancement in SQL Server, this just became much easier and can be done in a single statement... WITHOUT A TRIGGER!
2010-12-27
5,245 reads
This article introduces connection strings and suggests using MDAC to easily write efficient connection strings for those new to SQL Integration.
2010-12-24
5,590 reads
2010-12-24
2,329 reads
Red Gate has released SQL Scripts Manager, a free tool containing over 25 scripts written by SQL Server experts, to help you automate common troubleshooting, diagnostic, and maintenance tasks.
2010-12-23
5,954 reads
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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