A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

Microsoft Research conducts fundamental science and technology research across a spectrum of research areas. With labs around the globe we pursue breakthroughs across the computing and AI stack to ...

As a database professional, understanding how SQL Server manages its internal resources is the key to unlocking peak performance. One of the most misunderstood and, consequently, misconfigured ...

The TinyTDS gem is meant to serve the extremely common use-case of connecting, querying and iterating over results to Microsoft SQL Server from Ruby using the FreeTDS's DB-Library API. TinyTDS offers ...

These two configuration options control how the SQL Memory Manager handles memory growth and reduction for a SQL Server process used by an instance of SQL Server. This is specifically the amount of ...

EF Core allows you to instantiate a DbContext in several ways. Learn when and how to use these different approaches in your ASP.NET Core applications. Entity Framework Core is an object-relational ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...