Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
Archives du mois : septembre 2022
[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 […]
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.
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 […]