SQL Server: Consolidation Tactics and Best Practices
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I...
2016-07-21
1,507 reads
Tim Radney - Database Professional
Microsoft SQL Server MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year....
2015-07-01
1,236 reads
I am joining SQLskills
I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to...
2014-12-19
1,308 reads
Getting Your Worth the Struggles with Moving Ahead
I often get asked for advice on how to get started in a career as a DBA or in IT...
2014-12-19 (first published: 2014-12-10)
6,996 reads
#Summit14 Embarcadero Book Signing
The blessings continue as Embarcadero offered to support my new book by hosting a book signing and providing 100 copies...
2014-11-04
1,057 reads
Managing Geeks – A journey of leading by doing
I am proud to share that my good friend Andy Leonard has just released a new book. This is also...
2014-10-29
1,882 reads
SQL Server 2014 Backup and Recovery
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...
2014-10-29
1,877 reads
SQL Server 2008 SP4 Released
On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates...
2014-10-01
1,392 reads
What PASS is to me #sqlpass
I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL...
2014-09-29
1,632 reads
4 Things I Wish I Knew Sooner
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,327 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 Sudirman TLP WA 08218573837
Jl. Jend. Sudirman No.277, Cibadak, Kec. Astanaanyar, Kota Bandung, Jawa Barat 40241
BCA Finance Bekasi Layanan Mobil Tlpn.Wa 083834802131
KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...
BCA KCP Batununggal TLP/WA 08218573837
Jl. Batununggal Indah Raya No.149, Batununggal, Kec. Bandung Kidul, Kota Bandung, Jawa Barat 40266
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