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.
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.6.4. The update addresses a […]
Is your company hiring for a database position as of September 2024? Do you wanna work with the […]
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that […]
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on […]
An entire post on choosing the correct data types either seems like overkill or much needed and […]
Hey folks – I’ve seen some comments and replies stating that folks cannot use the debugger with SSDT […]
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially […]
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.
The post Is it still worth it to sponsor PASS Summit? appeared first on SQLServerCentral.
Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both […]
We have released updates to multiple supported versions of Microsoft.Data.SqlClient. The updates address several issues. Microsoft.Data.SqlClient 4.0 […]
Microsoft.Data.SqlClient 6.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
We recently released an update to Microsoft JDBC Driver for SQL Server, version 12.8.1. The update addresses a few […]
As you all know about, just a few weeks ago we had the big CrowdStrike global IT […]
In this week’s Query Exercise challenge, I explained SQL Server’s 201 buckets problem. SQL Server’s statistics only handle […]
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at […]
The post Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level appeared first on SQLServerCentral.
The post Is your DevOps strategy missing a vital link? appeared first on SQLServerCentral.
I ran a poll over on LinkedIn to find out if people have 100% of their databases under […]
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your […]
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking […]
We announced Microsoft.Data.SqlClient in the first half of 2019 and shipped the first stable package later that year. That release coincided with .NET […]
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.