Connecting to MongoDB through Python
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Sites anglophones
Who’s Hiring in the Microsoft Data Platform Community? November 2024 ...
Is your company hiring for a database position as of November 2024? Do you wanna work with the […]
Watch Me Stream at the PASS Summit for Free!
This week at the PASS Data Community Summit in Seattle, 15 sessions are getting streamed online for free! […]
Your Personal ChatGPT Tutorial
Introduction We are currently in a golden age of AI, with the emergence of large language models (LLMs) […]
Live webinar – Prioritizing security: Essential strategies for IT leaders
The post Live webinar – Prioritizing security: Essential strategies for IT leaders appeared first on SQLServerCentral.
Keeping up with the 2024 PASS Summit
In this post, I want to share a few places where you can keep up with what […]
AI and Databases
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
Our Annual Black Friday Sale Starts Now!
The wait is over: my annual Black Friday sale has officially launched! If you’ve been eyeing any of […]
A Guide to SQL Security in Django
The web apps we see today handle a lot of sensitive user data and this makes security of […]
Optimize SQL LIKE Wildcard Searches
The post Optimize SQL LIKE Wildcard Searches appeared first on SQLServerCentral.
Black Friday Super Sale!
It’s the time of year again where companies do crazy sales on the day after Thanksgiving in the […]
[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 […]
Audit SQL Server Extended Stored Procedures Usage
The post Audit SQL Server Extended Stored Procedures Usage appeared first on SQLServerCentral.
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, […]
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.
[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 […]
[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 […]
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.