SQL Saturday #49 - Orlando
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
2010-09-15
1,426 reads
Articles
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
2010-09-14
6,463 reads
SQL Saturday #55 - San Diego
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
2010-09-14 (first published: 2010-09-07)
1,663 reads
SQL Social - Kent, UK
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
2010-09-14
1,427 reads
Synchronizing SQL Server and SQL Azure
SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
2010-09-14
1,240 reads
Mid September Free Training from PASS
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
2010-09-13
1,808 reads
Top 10 SQL Server Integration Services Best Practices
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
2010-09-13
13,634 reads
Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log
SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.
2010-09-13
3,345 reads
SQL Saturday #46 - Raleigh
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010
2010-09-13 (first published: 2010-09-02)
1,529 reads
2010-09-10 (first published: 2008-11-17)
33,015 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
BCA KCU WAHID HASYIM TLP/WA 083800119009
Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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