25 Years Later: What SQLServerCentral Meant to Me
A look back at SQL Server Central after 25 years from founder Brian Knight.
Doing Good at SQL Server Central
Steve talks about some of the charitable work at SQL Server Central.
I Just Don’t Understand Why You Don’t Update SSMS.
A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.
Engineer Lessons
Steve thinks a few lessons on being a software engineer at Google are good items for anyone to think about.
Azure Functions: The Serverless Powerhouse
Today’s organization are faced with multiple conflicts for their current cloud infrastructures and which approach to go with either opting for a microservice or monolith applications. However, there are numerous difficulties with standard hosting methods.
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
Securing Your Databases in 2026: Best Practices for the Evolving Threat Landscape
In 2026, your approach to both applications and databases must be focused on practical and technical real-world operations and use cases rather than just hype.
Microsoft Security Changes and SQL Server
Windows is changing its security, which will affect SQL Server.
Expanding into Print
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were […]
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Kantor BCA KCP Abdulrahman Saleh Telp/wa 085169998803
Telp/wa 085169998803 Jl. Abdulrahman Saleh No.101 Kav C-D, Kalibanteng Kulon, Kec. Semarang Barat, Kota...
BCA KCP Gudang Peluru HUB/CS 08216977701
Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar No.23 Blok a, Kebon Baru,...
BCA KCP Kedungmundu Telp/wa 085169998765
Telp/wa 085169998765 Jl. Kedungmundu No.121, Tandang, Kec. Tembalang, Kota Semarang, Jawa Tengah 50274
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