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 […]
Sites anglophones
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.
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, […]
[Video] Office Hours: Icy Strait Point, Alaska
I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route […]
Why customers love SQL Prompt
The post Why customers love SQL Prompt appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? October 2024 ...
Is your company hiring for a database position as of October 2024? Do you wanna work with the […]
Announcing the Winners of the Biggest Database Regret Contest
I recently asked you to leave a comment with your biggest database regret, and the comments were great! […]
Exploring Time Travel and Row Level Concurrency: Data Engineering with ...
The Delta file format supports ACID properties by storing data in parquet files and actions in JSON files. […]
Casino night is back at PASS Summit 2024!
The post Casino night is back at PASS Summit 2024! appeared first on SQLServerCentral.
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, […]
SQL Index Rebuild vs Reorganize Comparison
The post SQL Index Rebuild vs Reorganize Comparison appeared first on SQLServerCentral.
Converting Old Running Total Code to Window Functions
I ran across an article that showed calculating a running total with a twist. In this case, the […]
[Video] Office Hours: Open Q&A on Microsoft Databases
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we […]
Diving Deeper into the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
The PASS Data Community Summit Session Schedule is LIVE!
The post The PASS Data Community Summit Session Schedule is LIVE! appeared first on SQLServerCentral.
Free Webcast: How to Think Like the Engine, Big Data ...
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on […]
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL […]
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server ...
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are […]
Simple Talks at the PASS Summit
This year at Simple Talk has been exciting, after a slow start with me being more or […]
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Boosting Database Development Efficiency Using AI SQL Code Generators
Database development has become more complex over the years due to the introduction of new data and […]
Setup Excel as Front End Application for SQL Server
The post Setup Excel as Front End Application for SQL Server appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what […]
How To Use Managed Identities in your Azure Logic Apps
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
Query Exercise Answers: Why Are These 3 Estimates So Wrong?
This week’s Query Exercise challenged you to figure out why these 3 estimates went so badly: SELECT TOP […]
Microsoft return to PASS Summit 2024 as Sapphire sponsor
The post Microsoft return to PASS Summit 2024 as Sapphire sponsor appeared first on SQLServerCentral.
Contest: What’s Your Biggest Database Regret?
PAST ME, WHAT WERE YOU THINKING We all make mistakes. I certainly have. I’ll give you a recent […]
AWS Services Using SQL for Big Data Analysis
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can […]
Download AWS RDS SQL Server Backup
The post Download AWS RDS SQL Server Backup appeared first on SQLServerCentral.
How to Add a New Shared Disk to a WSFC ...
DBAs often face situations when the disk gets full for user database files, logs, or system database files. […]
Working with Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never […]
Introducing the New Stars of Data speakers for PASS Summit ...
The post Introducing the New Stars of Data speakers for PASS Summit 2024 appeared first on SQLServerCentral.
[Video] Office Hours: Database Q&A
I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start […]
Query Exercise: Why Are These 3 Estimates So Wrong?
Our prior Query Exercise introduced SQL Server’s 201 buckets problem: its inability to accurately estimate rows for more […]