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 […]
Archives du mois : octobre 2022
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 […]