[Video] Office Hours in Cabo San Lucas, Mexico
What a comfy morning to sit down with a breakfast margarita and tackle your top-voted questions from https://pollgab.com/room/brento. […]
Archives du mois : juillet 2024
Contrôler la qualité des modèles sémantiques Power BI au fil ...
Cet article est disponible en Anglais sur LinkedIn : Monitoring the quality of Power BI Semantics Models […]
Using Registered Servers in SSMS
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have […]
Getting Started with Azure CLI to Manage Azure Resources
The post Getting Started with Azure CLI to Manage Azure Resources appeared first on SQLServerCentral.
PASS Summit Futures Scholarship
The post PASS Summit Futures Scholarship appeared first on SQLServerCentral.
Free Online SQL Server Internals Conference Next Week
The EightKB conference is a free event that focuses on SQL Server internals. You can get the session […]
5 Ways to Spend Your 2024 Learning and Development Budget ...
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at […]
Fall is around the corner, and hence the PASS Data ...
Welcome to the dog days of summer in the Northern Hemisphere. It is hot, so if you […]
Getting Started With Azure Cosmos DB for PostgreSQL
Article Overview In this article we will learn about Azure Cosmos DB PostgreSQL, which is the latest addition […]
How to Stream Data from Azure Event Hubs into a ...
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for […]
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include […]
Migrate a SQL Server Database to a PostgreSQL Database
The post Migrate a SQL Server Database to a PostgreSQL Database appeared first on SQLServerCentral.
[Video] Office Hours in a Mexican Hot Tub
While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. https://www.youtube.com/watch?v=OaHImrIMM6YVideo can’t be loaded […]
Query Exercise Answer: Fixing a Slow Computed Column
In last week’s Query Exercise, we added a user-defined function to the Users table to check whether their […]
Cumulative Update #14 for SQL Server 2022 RTM
The 14th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Announcing New Membership Tiers: Free & Mentoring
I give away a lot of stuff in various places on the internet: videos, scripts, the new free tier […]
Sécurité : un Patch Tuesday avec 139 correctifs
Microsoft a déployé son patch mensuel de sécurité. L’édition juillet est particulièrement riche : pas moins de […]
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes. You can read […]
How to use Jupyter Notebook in VSCode
Introduction Visual Studio Code (VSCode) is a free code editor used by many programmers. In this article, we […]
Using Query Store to Identify CPU Intensive SQL Queries and ...
The post Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes appeared first on […]
An Introduction to Frappe Framework: Features and Benefits
Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. […]
101 of Troubleshooting SQL Server on Linux
Based on our extensive experience with customers using SQL on Linux, we have compiled a guide outlining fundamental […]
Today’s a Good Day to Talk to Your Manager About ...
Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The […]
Notebook Jobs in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
[Video] Office Hours in My Backyard
On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento. […]
Query Exercise: Fix This Computed Column.
Take any size of the Stack Overflow database and check out the WebsiteUrl column of the Users table: […]
Effectively troubleshoot latency in SQL Server Transactional replication: Part 2
Let us continue our troubleshooting by checking threads in this part. Step 4.1. Troubleshoot latency in Log Reader […]
Effectively troubleshoot latency in SQL Server Transactional replication: Part 1
High level transactional replication architecture The initial stage of transactional replication is initializing the subscriber. Although this can […]
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
Configure Microsoft Fabric Database Mirroring for Snowflake
The post Configure Microsoft Fabric Database Mirroring for Snowflake appeared first on SQLServerCentral.
Four steps towards tackling the complexity of managing multiple database ...
The post Four steps towards tackling the complexity of managing multiple database platforms appeared first on SQLServerCentral.
Updated, Larger Stack Overflow Demo Database
Stack Overflow publishes a data dump with all user-contributed content, and it’s a fun set of data to […]
T-SQL Tuesday #176 Roundup of advice
There was a lot of great advice, and I really wonder how much of this I would […]
Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal ...
The temporal database is a database that can keep information on time when the facts represented in […]
SQL Server, gestion de la performance… et la VM dans ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Prompt+ EAP: your AI-powered database development partner in the making
The post Prompt+ EAP: your AI-powered database development partner in the making appeared first on SQLServerCentral.
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Introduction In the realm of image generation, Generative Adversarial Networks (GANs) have emerged as powerful tools, capable of […]
Add Indexes to Improve SQL DELETE Performance
The post Add Indexes to Improve SQL DELETE Performance appeared first on SQLServerCentral.
Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream
In this fast-changing world of data, businesses are looking for more insights in their data to remain competitive. […]
Save $200 by registering for a PASS Summit 2024 3-day ...
The post Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16 appeared first […]
Working with Documents in the MongoDB Compass GUI
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Haute disponibilité – SQL Server vs PostGreSQL
La haute disponibilité des données est un facteur fondamental dans l’élaboration d’une architecture de bases de données, notamment […]
[Video] Office Hours in Bulgaria
I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art […]
SQL Server 2022 分散型可用性グループにおける同期失敗
こんにちは。SQL Server サポート チームです。 今回は、分散型可用性グループにおける同期が突然失敗する事象についてご紹介します。 事象 SQL Server 2022 で分散型可用性グループを構成し FILESTREAM を使用している環境において、正常に稼働していた分散型可用性グループが突如同期に失敗し、同期の状態が NOT_HEALTHY になります。 <事象発生構成> […]
Announcing Free SQL Server Monitoring.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your […]
Security Update for SQL Server 2016 SP3 Azure Connect Feature ...
The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack is now available for download at the Microsoft […]
Security Update for SQL Server 2019 RTM CU27
The Security Update for SQL Server 2019 RTM CU27 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2022 RTM CU13
The Security Update for SQL Server 2022 RTM CU13 is now available for download at the Microsoft Download […]