2017-03-21 (first published: 2017-03-15)
482 reads
SQL
2017-03-07 (first published: 2017-03-01)
1,244 reads
2017-02-28
11,427 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
9,278 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,544 reads
Extracting string after and before a Character/Pattern
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
265,165 reads
SQL Explained
A short explanation and infographic of what SQL is. For the non-SQL people in your life.
2015-07-24
8,743 reads
10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
2015-07-16
9,747 reads
2015-06-23
2,057 reads
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
2015-03-16
6,679 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