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 […]
Tous les articles
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 […]
Time to register for PASS Data Community Summit
The post Time to register for PASS Data Community Summit appeared first on SQLServerCentral.
How to Visualize Python Charts in Power BI Part 4
Introduction This is the 4th part of the topic of how to visualize Python charts in Power BI […]
Un « GREP » pour rechercher un motif dans tous les codes ...
Il est parfois nécessaire de rechercher dans toute l’étendue du code Transact SQL (vues, procédures stockées, fonctions UDF, […]
PostgreSQL Triggers Part 2
Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. […]
Optimize Large SQL Server Insert, Update and Delete Processes by ...
The post Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches appeared first on SQLServerCentral.
Query processing architecture guide
The post Query processing architecture guide appeared first on SQLServerCentral.
Azure Synapse Link for SQL
Near-real-time analytics for transactional workloads Part of the SQL Server 2022 blog series. Traditionally, data to serve analytical systems […]
[Video] Office Hours: Six-Minute Speed Round
The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered […]
[Video] Office Hours in Tel Aviv, Israel
Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions […]
SQL Server and Oracle Transparent Data Encryption Differences and Similarities
The post SQL Server and Oracle Transparent Data Encryption Differences and Similarities appeared first on SQLServerCentral.
Data Governance: Joining the Dots
The post Data Governance: Joining the Dots appeared first on SQLServerCentral.
Cumulative Update #31 for SQL Server 2017 RTM
The 31st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft […]
Antipatterns on Azure Cosmos DB
This post was authored by Microsoft MVP and Azure Cosmos DB community champion Blaize Stewart. You can […]
New Online Class: Running SQL Server in AWS and Azure
You’re used to managing your own SQL Servers in VMs, but now they’re asking you to work with […]
La recette des fusions et acquisitions réussies : la consolidation d'Active ...
La concurrence s'intensifiant, les entreprises opèrent de plus en plus de changements structurels pour survivre et prospérer. […]
Maximize the Business Impact with Quest EMPOWER
You do not want to miss out on signing up with Quest EMPOWER. I will be there […]
The Lock Escalation Threshold – Part 1
The post The Lock Escalation Threshold – Part 1 appeared first on SQLServerCentral.
How to visualize Python charts in Power BI part 3
Introduction This is the 3rd part of the topic of how to visualize Python charts in Power BI. […]
Guide to Build Graph Node and Edge Tables with Azure ...
The post Guide to Build Graph Node and Edge Tables with Azure Data Studio appeared first on SQLServerCentral.
Managing Static Data in Flyway Database Development
The post Managing Static Data in Flyway Database Development appeared first on SQLServerCentral.
SQL WHERE Tutorial
The post SQL WHERE Tutorial appeared first on SQLServerCentral.
How to Use PowerShell to Set Secure SA Passwords in ...
Introduction In this article, I will help you how to set secure SA passwords for bulk servers. Sometimes […]
Intelligent Query Processing: feature family additions
Part of the SQL Server 2022 blog series. SQL Server 2022 introduces a handful of new members to the […]
Most DBAs Say They’re Encrypting Personally Identifiable Data. Most.
Despite the continuous stream of data breaches, ransomware, and GDPR violations, some companies still aren’t encrypting personally identifiable […]
Released: Microsoft.Data.SqlClient 4.0.2
We have released an update to Microsoft.Data.SqlClient, version 4.0.2. The update addresses several issues that are important to […]
Announcing Entity Framework 7 Release Candidate 1
Entity Framework Core 7 (EF7) Release Candidate 1 has shipped! The team focused on addressing defects, minor […]
Released: Microsoft.Data.SqlClient 4.1.1
We have released an update to Microsoft.Data.SqlClient, version 4.1.1. The update addresses several issues that are important to […]
Released: Microsoft.Data.SqlClient 4.1.1
We have released an update to Microsoft.Data.SqlClient, version 4.1.1. The update addresses several issues that are important to […]
[Video] Office Hours: Ask Me Anything About SQL Server and ...
Got questions about the Microsoft data platform? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to […]
Monitoring: The ROI of Build vs. Buy
The post Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
Convert UNIX Timestamps to DATE/TIMEs in SQL Server – Part#1
tl;dr A complete and documented function is available at the end of the article. You don’t know what […]
How to Create a SQL Server Database, Tables, Foreign Keys ...
The post How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application appeared […]
Hotfix: JDBC Driver 11.2.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.1. The update addresses a couple […]
T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM
SELECT CASE WHEN 1 = NULL THEN ‘True’ Else ‘False’ end, CASE WHEN NOT(1 = NULL) THEN […]
Community Tools Month: Using sp_WhoIsActive to Catch ASYNC_NETWORK_IO
When your SQL Server’s top wait stat is ASYNC_NETWORK_IO, that indicates SQL Server is waiting on the app […]
SQL Server 2022 RC0 est disponible sur Linux
Microsoft a annoncé la disponibilité de SQL Server 2022 release Candidate 0 pour Linux. Cette mouture apporte […]
How to visualize Python charts in Power BI Part 2
Introduction In a previous article, named How to visualize Python charts in Power BI, we show some charts […]
Microsoft offre une version candidate de SQL Server 2022 au ...
Microsoft offre une version candidate de SQL Server 2022 au monde Linux elle comprend des fonctionnalités comme […]
Understanding the System Function FILEPROPERTY()
The SQL Server system function, FILEPROPERTY(), is used to retrieve database file properties. I will show you use […]
Rollbacks, Undos and Undonts
The post Rollbacks, Undos and Undonts appeared first on SQLServerCentral.
Data Visualizations for Excel Multi-Chart Sets with SQL Server Data
The post Data Visualizations for Excel Multi-Chart Sets with SQL Server Data appeared first on SQLServerCentral.