MySQL Index Overviews: B-Tree Indexes
In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL, B-Tree Indexes. Applying indexes of any type in MySQL is nuanced task – they are used to speed up the performance of our search queries at the ex …
Level up your learning in 2024 with PASS Data Community Summit
The post Level up your learning in 2024 with PASS Data Community Summit appeared first on SQLServerCentral.
Create Document Templates in a SQL Server Database Table
The post Create Document Templates in a SQL Server Database Table appeared first on SQLServerCentral.
Git, GitHub and Visual Studio Code for SQL Server
Introduction This article will teach us to integrate Git, GitHub, and Visual Studio Code. Visual Studio Code (VSCode) is a great tool for programming in T-SQL, Python, Java, and other languages. You can read our articles about Visual Studio code if you …
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this work involves Task Scheduler and, be honest, who knew Task Scheduler was this complicated? On different servers, we wanted jobs to trigg …
Redgate Summit: The Database Landscape – New York
The post Redgate Summit: The Database Landscape – New York appeared first on SQLServerCentral.
Génération d’une dimension Date pour les modèles sémantiques en Direct Lake
L’un des éléments clés d’un modèle sémantique est la table des dates. Elle fournit une référence pour tous les calculs et analyses liés au temps. Une table de dates est une table qui contient une ligne pour chaque jour dans une plage spécif …
Who’s Hiring in the Microsoft Data Platform Community? August 2024 Edition
Is your company hiring for a database position as of August 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inc …
[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. Here’s what we covered: 00:00 Start 00:36 DBA_Mufasa: When we restore a DB from a prod source to a different ser …
Contrôler la qualité des modèles sémantiques Power BI au fil du temps
Cet article est disponible en Anglais sur LinkedIn : Monitoring the quality of Power BI Semantics Models over time. Introduction Il y a plus de 3 ans, j’ai écrit un article sur l’analyse de la qualité de modèles sémantiques d’un espac …
Using Registered Servers in SSMS
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection di …
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 details and register for the August 8th event at eightkb.online. The session lineup is below, each link being a calendar invite just so you can block o …
5 Ways to Spend Your 2024 Learning and Development Budget in the US
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This is something I encourage you to negotiate when you are considering a job or at your annual review. We all need to learn and a b …