Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for starting SQL hides some of the nuances that divide efficient queries from inefficient queries. As your SQL gets more complicated and you need …
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data and numerous transactions. Traditional relational databases, once the foundation of data management, often struggle to meet these moder …
Uncover SQL Server Missing Indexes
The post Uncover SQL Server Missing Indexes appeared first on SQLServerCentral.
PASS Summit Livestream and on-demand
The post PASS Summit Livestream and on-demand appeared first on SQLServerCentral.
[Video] Office Hours: Back at Home (Briefly)
I took a break from unpacking my SQL Saturday San Diego bags and re-packing for a Boston wedding long enough to take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 01:55 Deadlockinator: Hi Brent, Why does s …
Creating Views in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB database that …
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete: SET STATISTICS IO ON; GO BEGIN TRAN DELETE dbo.Users WHERE DisplayName = N’Brent Ozar’; I’m using SET STATISTICS I …
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
Many companies have under provisioned lower environments since they are continuously running. What if you can turn on and off your major Azure Services to save money. If needed, these savings can be used to increase the size of your computing power t …
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them: EXEC DropIndexes @TableName = N’Users’; CREATE INDEX LastAccessDate ON dbo.Users(LastAc …
[Video] Consulting Lines
In my consulting work, I often find myself saying the same things to clients – but they’re not the kinds of things I said when I was a database administrator. I call these “Consulting Lines”, and I talked through ’em: …
Azure Managed Instance Download and Restore SQL Server Backup
The post Azure Managed Instance Download and Restore SQL Server Backup appeared first on SQLServerCentral.
Enhancing SQL Server Searches with Elasticsearch and Python
As a seasoned SQL developer and tech enthusiast, I often encounter scenarios where traditional SQL Server searches struggle to meet performance and flexibility requirements. One such challenge is efficiently searching a large person database with multi …
Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster
Power BI has been a leading data visualization tool in the market for years. It can be used as a self-service data analysis tool, or as an enterprise-governed business intelligence tool. According to the official website: “Do more with less using an en …
PASS Summit 2025 Dates
The post PASS Summit 2025 Dates appeared first on SQLServerCentral.
[Video] Office Hours on a Calm Sea Day Off Canada
On an unbelievably calm sea day off the shores of Canada, aboard the Norwegian Jewel, I enjoyed a nice cup of completely alcohol-free coffee (as far as you know) and took your top-voted questions from https://pollgab.com/room/brento. Here’s what …