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 ...

This GitHub repository contains code samples that demonstrate how to use Microsoft's Azure Data products including SQL Server, Azure SQL Database, Azure Synapse, and Azure SQL Edge. Each sample ...

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 ...

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 ...

This blog post is part of the SQL Server 2022 blog series. Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as ...

Another week and another useful dbatools snippet for you today. Last week at work I was given a folder of 1,500 scripts – each containing a create table statement. Can you imagine having to open each ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

The man who once imagined a ‘global war’ between ‘the Judeo-Christian west’ and ‘jihadist Islamic fascism’ is now Trump’s top adviser. Here’s a selection of anti-Muslim remarks he has made in the past ...