SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
41 reads
Blog Posts
Turning a Corporate Color Palette into a Data Visualization Color Palette
Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are designed...
2019-06-03 (first published: 2019-05-16)
1,411 reads
Using Extended Events To Capture Backup and Restore Progress
If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
2019-06-03 (first published: 2019-05-16)
977 reads
Weekly reading #0x10
This is the blog anniversary! 16th Weekly reading has come into the light! For great articles and a video wait for you! Report Parameter Support for Paginated Report E-Mail...
2019-06-03
19 reads
Which Query Used the Most CPU? Implementing Extended Events
A question that comes up on the forums all the time: Which query used the most CPU. You may see variations on, memory, I/O, or just resources in general....
2019-06-03
34 reads
Keynoting at SQL Saturday #831–Christchurch
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
10 reads
Thanks for joining us at SQLSaturday Dallas!
Thanks for joining hundreds of SQL pros from around the country today at UTDallas!Here's my session downloads from my presentation today at 1:15 in room 1.102, there's a handy...
2019-06-01
13 reads
2019-05-31T19:00:42.000+00:00
TEST I'd read about Terraform 0.12 and thought it was much further out, so moved on with regret from evaluating the massive number of improvements. Just found out it...
2019-05-31
7 reads
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
9 reads
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
9 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Bandar Jaya TLP/WA 08216977749
Jalan Proklamator RT. 2/RW. 1, Bandar Jaya Timur, Bandar Jaya Barat, Terbanggi Besar, Kabupaten...
BCA KCP Grogol Permai Telpn/wa (08218171891)
Pert.Grogol Permai, Jl. Prof. Dr. Latumeten No.4 Blok F 3, Jelambar, Kec. Grogol petamburan,...
BCA KCU WISMA MILLENIA Wa 083179431656
Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet, akarta Selatan,...
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