Database snapshot issue with sqlserver
Database snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with sqlserverDatabase snapshot issue with...
2017-05-23
680 reads
Blog Posts
Experienced DBA: Rookie Mistake
M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this...
2017-05-23
113 reads
How To Use Temporal Tables For Easy Point-In-Time Analysis
Watch this week's video on YouTube
Have you ever needed to look at what data in a table used to look like?
If you have, it probably took a knuckle-cracking filled...
2017-05-23
18 reads
Power BI Custom Visuals Class (Module 50 – Narratives)
In this module you will learn how to use the Narrative Power BI Custom Visual. The Narrative visual is developed...
2017-05-23 (first published: 2017-05-09)
1,617 reads
Setting up the Power BI Report Server Preview
Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power...
2017-05-23
232 reads
SQL Server Window Functions in Action
SQL Server Window Functions were introduced in SQL Server 2005 with a basic set of operators and massively upgraded in...
2017-05-23
74 reads
SSRS Subscription Schedules
With the ability to create content delivery schedules, or to subscribe to report content delivery, this imposes a requirement to also know when the various reports are scheduled to...
2017-05-23
28 reads
What is Power BI Premium?
Yesterday I had the pleasure of delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”.
New...
2017-05-23
170 reads
What is Power BI Premium?
Yesterday I had the pleasure of delivering a webinar presentation in partnership with Pragmatic Works called “What is Power BI Premium?”.
New...
2017-05-23
940 reads
A Busy Few Years
Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking...
2017-05-22
473 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
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