Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
157 reads
Blog Posts
Database Recovery Monitoring with XE
Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...
2019-04-10
11 reads
Notes from SQLSaturday Tampa 2019
Late notes! Great signs at the event, all hand written on flip chart paper. Cheap and effective, the “different” nature of the signs made them easy to spot Rooms...
2019-04-10
14 reads
Power BI Now Has Keyboard Accessible Visual Interactions
The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...
2019-04-10 (first published: 2019-03-21)
1,875 reads
SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...
2019-04-10
27 reads
Uppercase All String Columns (and in a Single Query!)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,506 reads
Using a home-grown Azure Blob Storage solution for SQL Server backups
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
24 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
10 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
9 reads
Delete activity in Azure Data Factory - Cleaning up your data files
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,545 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCU MUARA KARANG Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
BCA KCP Bursa Efek Jakarta Telpon/wa:0813.7887.595
BCA KCP Bursa Efek Jakarta Telpon/wa:0813.7887.595.Gd. Bursa Efek Jakarta, Jl. Jend. Sudirman kav 52-53...
BCA KCP Gunung Sahari Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Pert, Indah Blok B, Jl. Gn. Sahari Jl. Budi Mulia No.13 11-12, Pademangan...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers