This chapter excerpt on Parallel SQL (download PDF) is taken from the book Oracle Performance Survival Guide: A Systematic Approach to Database Optimization. Get pertinent information on optimizing ...

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It’s always a fun time, with lots of ...

Managed Instance, Cosmos DB, SQL Azure, Azure Table Storage, Databricks, Fabric -- Microsoft, as we all know, struggles to name its products clearly. Unclear naming can lead to customer confusion. I ...

This chapter starts with a review of the history of database architecture. Initially, memory was expensive, so small amounts of RAM were used, and data persisted to disk. However, memory is now much ...

One of the advantages of the cloud is scale. We don’t call the big three cloud platforms hyperscale for nothing; they have massive data centers all around the world with millions of servers that can ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...