How to Apply Clustering in a Scatter Plot to Visualize ...
The post How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop appeared […]
Archives de l’année : 2022
Announcing Entity Framework Core 7 RC2: JSON Columns
Entity Framework Core 7 (EF7) RC2 has shipped! The RC2 release contains all features planned for the […]
SQL Server 2017 で導入された日本語照合順序を利用する環境での注意点
＊この記事は、SQL Server で日本語の照合順序を利用している方に向けた情報となりますので、日本語でのみ公開しております。 ＊This article is for the user using japanese collation of SQL Server.Hence we publish the […]
#tsql2sday: Start Your Dynamic SQL with a Comment.
When you write dynamic SQL, start like this: CREATE OR ALTER PROC dbo.MyProc AS BEGIN DECLARE @StringToExecute NVARCHAR(4000); […]
This Week, Fundamentals of Query Tuning Classes are Free!
Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely […]
Rethinking SQL Explicit Transactions
The post Rethinking SQL Explicit Transactions appeared first on SQLServerCentral.
Post-migration Validation and Optimization Guide
The post Post-migration Validation and Optimization Guide appeared first on SQLServerCentral.
Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]
Introducing the MySQL INSERT statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working […]
Putaclic – Cyberattaque – SQL Server et la backdoor Maggie
Je donne très rarement dans le sensationnel mais j’avoue que les titres des quelques agrégateurs de News que […]
Data Masking: Static vs Dynamic
The problem of data masking comes up surprisingly often in the world of IT. Any time you need […]
Improving the Quality of Data Governance: Where to Start?
The post Improving the Quality of Data Governance: Where to Start? appeared first on SQLServerCentral.
Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF
The post Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF appeared first on SQLServerCentral.
SQL Server 2022 : les nouveautés TSQL
Découvrez dans cette présentation « Full Démo » les nouveautés du langage SQL qui arrivent avec SQL Server 2022 !
SQL Server 2022 – Les nouveautés TSQL
Un petit tour d’horizon des nouveautés du langage SQL de SQL Server 2022
SQL Server – Trop d'index tue l'index : supprimer les ...
Bonjour, Je vous propose cet article sur la suppression des index inutiles (et donc contre performants) dont […]
[Video] Office Hours Silent Edition
Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text […]
Trop d’index tue l’index : supprimez les index inutiles !
Je découvre souvent beaucoup trop d’index dans les bases de données des clients que j’audite… Or tout index […]
What’s New in SQL Server 2022: GENERATE_SERIES()
I’ve been doing a lot of work with SQL Server 2022 lately and one of my absolute favorite […]
Data Virtualization with PolyBase for SQL Server 2022
Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and […]
Who’s Hiring in the Microsoft Data Platform Community? October 2022 ...
Is your company hiring for a database position as of October 2022? Do you wanna work with the […]
Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part ...
The post Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part 6 appeared first on SQLServerCentral.
Transaction locking and row versioning guide
The post Transaction locking and row versioning guide appeared first on SQLServerCentral.
The Basics of Inserting Data into a SQL Server Table
Entry in Greg Larsen series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
Azure Synapse Link support for Azure Cosmos DB Gremlin API ...
Azure Cosmos DB’s Gremlin API combines the power of graph database algorithms with highly scalable, managed infrastructure […]
Erik Darling’s Month of Free Tools Training
Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to […]
SQL Server 2022 Release Candidate 1 is now available on ...
Continuing with our release cadence, we are pleased to announce the release of SQL Server 2022 Release Candidate 1 […]
HADR_SYNC_COMMIT Wait Updates (In Progress)
A HADR_SYNC_COMMIT wait occurs when the session is waiting for a transaction to commit or rollback when the […]
October is Free Fundamentals Month – And The Training Starts ...
Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely […]
Convert Problematic Data in SQL Server
The post Convert Problematic Data in SQL Server appeared first on SQLServerCentral.
Join the EAP: Next-gen database cloning
The post Join the EAP: Next-gen database cloning appeared first on SQLServerCentral.
How to work with Python in Azure Data Studio
Introduction In this article, we will learn how to use Python in Azure Data Studio. Azure Data Studio is […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
[Video] Office Hours: Ask Me Anything at the Mediterranean Sea
On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered […]
The Redgate 100: Top Influencers List
The post The Redgate 100: Top Influencers List appeared first on SQLServerCentral.
How to Build a Data Science Time Series Model with ...
The post How to Build a Data Science Time Series Model with SQL Server appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022 Part 2
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This […]
SQL Server 2022 Release Candidate 1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 1. Since […]
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series. Backup and restore to simple storage service (S3)compatible object storage is […]
Vegas Home Office Tour
I’ve been teaching online from home for years, and you’d probably think my office would keep growing and […]
Cumulative Update #18 for SQL Server 2019 RTM
The 18th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
dbcc dumptrigger: Capture a dump for specific error and state
I had an inquiry about dbcc dumptrigger today and realized that state filtering was added to dbcc dumptrigger […]
Free Live Webcast: Why is One Query Sometimes Slow and ...
Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild […]
SQL Server – Un « GREP » pour rechercher un ...
Bonjour, voici un article traitant de la recherche d’un motif dans tous les codes de tous les […]
Microsoft SQL Server on Ubuntu pro-The preferred choice for deploying ...
Today, you can deploy SQL Server on Ubuntu based Azure virtual machines (VMs) in one of the three […]
Easy and Cost Effective way to Encrypt Every SQL Server ...
The post Easy and Cost Effective way to Encrypt Every SQL Server Database appeared first on SQLServerCentral.
Redgate Summit: The Database DevOps Transformation
The post Redgate Summit: The Database DevOps Transformation appeared first on SQLServerCentral.
Revamped SQL Permission system for Principle of Least Privilege and ...
The article is published here on the Azure SQL Blog: Revamped SQL Permission system for Principle of Least […]
Buckle Up: October is Free Fundamentals Month!
How about some completely free SQL Server training? Every weekday during the month of October, one of the […]
Ledger – Automatic digest upload for SQL Server without Azure ...
Ledger is a new feature that offers the power of blockchain in Azure SQL Database and SQL Server […]