Time to register for PASS Data Community Summit
The post Time to register for PASS Data Community Summit appeared first on SQLServerCentral.
Archives de l’année : 2022
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.
Question : visualiser mes fichiers stockés en blob
Question : je voudrais visualiser facilement mes fichiers PDF qui sont stockés dans ma base dans une colonne […]
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.
Query Store hints in SQL Server 2022
Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features […]
[Video] Office Hours: Hotel Balcony Edition, Part 2
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, […]
Load and visualize Covid-19 case data with the integrated Power ...
How have major cities like London and New York been affected by Covid-19 and how can we […]
SQL Server isolation optimiste
Vous avez des problèmes avec les verrous bloquants ? Savez-vous que SQL Server propose aussi un mode d’isolation […]
Gérer les bases de données à forte volumétrie
L’administration des bases de données devient plus délicate lorsqu’on gère de fortes volumétries. Dans cette présentation en […]
Je veux migrer mes bases dans Azure MAIS …
Vous êtes nombreux à vous poser des questions sur comment maîtriser la migration de vos bases dans […]