PASS 2020 Board of Director Endorsements
The election for the next PASS Board of Directors starts today, with a slate of 7 for three spots. I asked them for their vision last week, I’ve read...
2020-11-12 (first published: 2020-11-11)
113 reads
Blog Posts
PASS Summit 2020 Precon – Scripts and Links
An attendee at my PASS Summit precon on virtualized SQL Server performance tuning on Monday asked a great question. “Do you have a list of the tools and scripts...
2020-11-12 (first published: 2020-11-11)
283 reads
Vote in the PASS Election
If you login to pass.org AND have previously met the criteria to vote this year, you’ll see this. Click the button and you’ll be off to the voting page...
2020-11-12
20 reads
Daily Coping 11 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-11
19 reads
Deploy SSRS Projects with Two New PowerShell Commands
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...
2020-11-11
6 reads
External tables vs T-SQL views on files in a data lake
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus...
2020-11-11 (first published: 2020-11-03)
774 reads
Notes on the 2020 PASS Virtual Summit – Part 3
Tuesday notes! Today I’m in Execution Plans in Depth by Hugo Kornelis. Notes: Today the presenter is using the Cadmium/EventScribe platform instead of GotoWebinar Started off with a lot...
2020-11-11
18 reads
T-SQL Tuesday #132 - Coping With the Pandemic
This week is a double-whammy of activity - T-SQL Tuesday and PASS Summit 2020. T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month,...
2020-11-11
3 reads
T-SQL Tuesday Retrospective #004: I/O
Mike Walsh invited us on March 1st 2010 to write about I/O. This abbreviation stands for Input / Output, and is often used as shorthand for persisted storage. Given...
2020-11-11
15 reads
Daily Coping 10 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. Today's tip is to add the word "yet" when you feel you can't do something. This is good advice because […]
2020-11-10
17 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 Juanda Lyn Cs 083835110341
Jl. Insinyur H. Juanda No.54, RT.003/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
BCA Finance Bandung TELP/Wa-0831-6926-5861
Jl. Ir. H. Juanda No.66, Lb. Siliwangi, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
BCA Multifinance Surabaya Timur Tlpn.Wa 083834802131
Ruko Soho Emas, Jl. Klampis Jaya No.39, Klampis Ngasem, Sukolilo, Surabaya, Jawa Timur 60117
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