External Article

The Role of the Technical Architect in Development

What do Technical Architects (TAs) actually do when in a development role? Are they just senior developers 'pushed upstairs' into a management role? Is there a clear distinction between a TA and a product, or project, manager? In an increasingly automated and joined up development environment, the role is important, varied and wide-ranging; as Grzegorz Strzelecki explains.

SQLServerCentral Editorial

When is 8000 too small?

Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.

External Article

Building a Better NuGet

NuGet has transformed the ease of getting and installing the latest version of .NET packages, tools and frameworks. It relies on NuGet package authors to get packages right but there is little documentation for them to go by, and there are a few inevitable problems. Ed Charbeneau offers advice from experience.

Technical Article

Finding a table name from a page ID

Imagine you come to work in the morning and notice that some new rows have been entered into the msdb.dbo.suspect_pages table during the night. Usually the first thing you’re going to do is run DBCC CHECKDB, but if your database is a few TB, that could be several hours before you know where the problem is, and which table may have lost data. You want to find out which table is involved as soon as possible so you can explore your disaster recovery options.

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

By

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

Free Webinar about Columnstore Indexes

By

I’m doing a small series on indexing basics for SQL Server, and on May...

Read the latest Blogs

Forums

BCA KCP Bintaro Hubungi Cs.0851•8812•0691

By vitaminaal

BCA KCP Bintaro Hubungi Cs.0851•8812•0691 Jl. RC. Veteran. 9, dan No.9A, Daerah Khusus Ibukota...

BCA KCP Pluit Raya TLP/WA 08216977749

By ASAPRoofing

Jl. Pluit Raya No.200, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus Ibukota Jakarta 14440

BCA KCP Mal Taman Anggrek TLP/WA 08218573837

By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV

Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec. Grogol...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers