Black Friday Super Sale!
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the […]
Archives du mois : octobre 2024
[Video] Office Hours: Let’s Have a Drink
I was making myself a drink to film Office Hours and I realized I should just film it […]
T-SQL Notebooks: Manage Views Source Control and more
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss […]
Launch Day Bonus: Free Stuff on Friday
Our annual Black Friday sale launches this Friday and runs all month. For those of you who are […]
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with ...
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data […]
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
NEW YORK, October 29, 2024 – Timescale, the leading PostgreSQL database platform, today expanded its PostgreSQL AI offerings […]
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
Who Actually Buys BrentOzar.com Training?
So you’re thinking about picking up some of my training & online services during our annual Black Friday […]
The Countdown is On: Our Black Friday Sale Starts This ...
All year long, when you’re watching my Office Hours sessions, you keep hearing me say, “That topic is […]
Leveraging SQL Transaction Control in Python Applications
Transactions are the unsung heroes of data consistency/integrity in database operations. For us Python devs working with databases, […]
Audit SQL Server Extended Stored Procedures Usage
The post Audit SQL Server Extended Stored Procedures Usage appeared first on SQLServerCentral.
Microsoft at the PASS Data Community Summit 2024
Microsoft is once again excited to the be top sponsor at the PASS Data Community Summit in 2024 […]
[Video] Office Hours: Salem Witchcraft Edition
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I […]
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and […]
Using a Service Account in Microsoft Fabric
The post Using a Service Account in Microsoft Fabric appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in […]
What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted […]
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
Microsoft at PASS Data Community Summit 2024!
We’re thrilled to return as a Sapphire Sponsor for this year’s PASS Data Community Summit, together with our […]
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction […]
How To Embed Your Azure Logic Apps in a Metadata-driven ...
In this article, I am going to explain how you can dial your productivity up to 11 […]
Updated First Responder Kit and Consultant Toolkit for October 2024
The wording of all of sp_BlitzIndex’s warnings is now much more clear and inclusive thanks to hard work […]
The GitHub Web Platform
Introduction to the GitHub Web Platform In a previous article, we explained how to sign up for the GitHub […]
Data Lake Implementation – Data Lake Zones and Containers Planning
The post Data Lake Implementation – Data Lake Zones and Containers Planning appeared first on SQLServerCentral.
Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data […]
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 […]
Creating Views in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
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 […]
Use Logic Apps To Save Money In Azure: Data Engineering ...
Many companies have under provisioned lower environments since they are continuously running. What if you can turn on […]
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 […]
SQL Server Performances – CHAPITRE 3 – Estimateur de Cardinalité, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
[Video] Consulting Lines
In my consulting work, I often find myself saying the same things to clients – but they’re not […]
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 […]
Quick Tricks to Make Your Power BI Model Smaller, More ...
Power BI has been a leading data visualization tool in the market for years. It can be […]
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 […]
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 […]
Security Update for SQL Server 2022 RTM CU15
The Security Update for SQL Server 2022 RTM CU15 is now available for download at the Microsoft Download […]
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 […]
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part ...
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. […]
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 […]
[Video] Office Hours in Haines, Alaska: No Bears Here
While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. […]
Microsoft Fabric et Google BigQuery
Dans le monde actuel axé sur les données, les organisations se retrouvent souvent avec d’énormes quantités de […]
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, ...
The post Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star appeared first […]
How to Delete Large Amounts of Data in Microsoft SQL ...
Deleting large volumes of data in Microsoft SQL Server can be a challenging task. If not done correctly, […]