Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

Leonardo Boscaro, EMEA Sales Leader, Nutanix Database. In most large enterprises, the greatest concentration of operational complexity sits quietly inside SQL Server estates. Hundreds, and in some ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Structured Query Language, or SQL, is used to analyze large datasets. Today’s best SQL courses offer hands-on training for mastering database management. Structured Query Language, or SQL, is the ...

Solutions Architect, Azure cloud expert, blogger, trainer, professional racing driver. I recently migrated a full-fledged SQL Server from a virtual machine to Azure SQL. The journey was full of ...

Welcome to the SQL Server Language Extensions project! Starting in SQL Server 2019, we have added support for language extensibility, which means that you can now execute code in various languages ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Microsoft is bulking up its Azure SQL database services on the back of Intel's "Ice Lake" Xeon and AMD's "Milan" Epyc server chipsets. The company this week started a public preview of its ...

Users of on-premises Analysis Services will know that most of the useful server properties can be set in SQL Server Management Studio, some (such as MaxIntermediateRowsetSize) can only be set by ...