Presentation Skills from Brent Ozar
If you present at any level, read this. If you’re thinking about presenting, read this. If you’d like to start...
2009-09-23
1,076 reads
Blog Posts
SQL Lunch – Pick your favorite Logo
We have been working on the logo for a month now, but instead of making the final decision I have...
2009-09-23
773 reads
SSIS - Data Provider Does Not Allow Parameters in OLE DB Source
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-09-23
1,834 reads
Travel for 2010
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
Venturing into Powershell
As you probably know if you read my blog regularly, I recently put together a presentation called, Dive into the...
2009-09-23
498 reads
ADO.NET in PowerShell
I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things...
2009-09-22
741 reads
Cape Cod .NET Users Group
Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the...
2009-09-22
840 reads
Estimated rows, actual rows and execution count
It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a...
2009-09-22
2,270 reads
Free eBook: “Protecting SQL Server Data”
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-22
718 reads
Gila Monster on Estimated vs. Actual Row Counts
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,288 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 Kelapa Gading Hibrida TLP/WA 08216977749
Jl. Boulevard Raya No.14 Blok RA-1, RW.15, Klp. Gading Tim., Kec. Klp. Gading, Jkt...
BCA KCP Semper TLP/HUB 08216977701
Jl. Plumpang Semper No. 02 RT 010/002, Daerah Khusus Ibukota Jakarta 14260
BCA KCP Pademangan TLP/Wa 08216977749
Gg. 21 dan 22 No.1, Pademangan Tim., Kec. Pademangan, Jkt Utara, Daerah Khusus Ibukota...
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