The post SQL Index Rebuild vs Reorganize Comparison appeared first on SQLServerCentral.
I ran across an article that showed calculating a running total with a twist. In this case, the […]
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we […]
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
The post The PASS Data Community Summit Session Schedule is LIVE! appeared first on SQLServerCentral.
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on […]
The 15th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL […]
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are […]
This year at Simple Talk has been exciting, after a slow start with me being more or […]
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Database development has become more complex over the years due to the introduction of new data and […]
The post Setup Excel as Front End Application for SQL Server appeared first on SQLServerCentral.
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what […]
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
This week’s Query Exercise challenged you to figure out why these 3 estimates went so badly: SELECT TOP […]
The post Microsoft return to PASS Summit 2024 as Sapphire sponsor appeared first on SQLServerCentral.
The automated patching feature for SQL Server on Azure VM will be retired on September 17th, 2027. […]
PAST ME, WHAT WERE YOU THINKING We all make mistakes. I certainly have. I’ll give you a recent […]
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can […]
The post Download AWS RDS SQL Server Backup appeared first on SQLServerCentral.
DBAs often face situations when the disk gets full for user database files, logs, or system database files. […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Companies of all sizes and across industries are struggling to cope with an explosion of data never […]
The post Introducing the New Stars of Data speakers for PASS Summit 2024 appeared first on SQLServerCentral.
Simplifying Database Migrations with Azure SQL By migrating their databases to Azure, customers like Ernst and Young are modernizing […]
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 […]
こんにちは。SQL Server サポート チームです。 事象 SQL Server がインストールされていないAzure VM において、Windows イベントログのアプリケーションログに以下のメッセージが記録される場合があります。 – ソース Microsoft SQL Server […]
Our prior Query Exercise introduced SQL Server’s 201 buckets problem: its inability to accurately estimate rows for more […]
The Security Update for SQL Server 2019 RTM CU28 is now available for download at the Microsoft Download […]
The Security Update for SQL Server 2022 RTM CU14 is now available for download at the Microsoft Download […]
The temporal database is a database that can keep information on time when the facts represented in […]
Introduction If you’ve been following SimpleTalk for a while, you will be aware that I’ve recently blogged […]
The post Event Streams for Persistent and Asynchronous Microservice Communication appeared first on SQLServerCentral.
Relational Databases are known for their atomic, consistent, independent and durable properties (ACID). The first version of Apache […]
Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,295. But […]
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as […]
Let me start with a simple confession, and I hope it’s not too shocking for anyone; I’m […]
Introduction Previously, we created a tutorial to connect Visual Studio Code with GitHub. Now, we will show another […]
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring […]
I got a new laptop recently and instead of installing SQL Server, I decided to try and use […]
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.
All developers hit the problem of how and where to store and set their configuration, profile, or […]
Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera […]
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked […]
Hello SSMS users! A short post today to remind folks to check out the feedback site regularly. As […]
Let’s say you built a web app and it became globally popular. You’ve got users scattered across North […]
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.