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 …
Poll: What’s In Your Development Database?
When your developers work on new queries or testing complaints about existing queries, what database are they working on? I put together an anonymous one-question poll that only takes a few seconds to respond. Let me know! I’ll follow up with a b …
Identify CPU Intensive SQL Server Queries from an Implicit Conversion
The post Identify CPU Intensive SQL Server Queries from an Implicit Conversion appeared first on SQLServerCentral.
Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor
Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and …
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part I)
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. As I covered in a previous article, Frappe and ERPNext stand out as powerful tools in this domain, offering comprehensive c …
Finished Your Training? Get a Certificate of Completion.
If you want to get a raise or stand out from a crowd of job hunt competitors, you need something to differentiate yourself. Whenever you finish a training class – including mine – ask if you can get a certificate of completion. For example, …