SSRS Subscription Schedules – Enhanced
Reporting Services
Over the past couple of articles I have illustrated some of the fun that can be had when dealing...
2017-05-25
1,103 reads
Blog Posts
T-SQL Tuesday #90 – The Elephant’s Name is Database
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-05-25 (first published: 2017-05-09)
2,074 reads
T-SQL Tuesday 90 - Shipping Database Changes
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-05-25 (first published: 2017-05-09)
1,663 reads
Find the number of rows for a value, without querying the table
Dear all,
Being a DBA, developers approach me with questions like can you run this query for me in production?
Select*FROM[dbo].[FactInternetSales]
WHERE UnitPrice...
2017-05-24 (first published: 2017-05-11)
2,458 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
164 reads
Power BI – Problem, Design, Solution (Concatenated Tooltip)
Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series...
2017-05-24
799 reads
SSAS high availability
If you are looking at providing high availability (HA) for SSAS, here are 3 options:
Install SSAS on a Windows Server...
2017-05-24
974 reads
TIL: Microsoft Azure Part 2
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
935 reads
Using Azure Machine Learning with an on-premises Database
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
3,959 reads
Copy-SqlJob, a handy dbatools cmdlet
One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often...
2017-05-23 (first published: 2017-05-08)
1,777 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
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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