Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell
The post Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell appeared first on SQLServerCentral.
Express a Number or Currency in Words with T-SQL Code
The post Express a Number or Currency in Words with T-SQL Code appeared first on SQLServerCentral.
[Video] Office Hours with a Special Guest: Count Distinct
I was busy, so I asked a friend to fill in for me and answer your top-voted questions from https://pollgab.com/room/brento. He did a pretty good job: Here’s what we covered: 00:00 Start 00:52 Confused: Who uses differential backups, really …
Query Exercise: What Makes SELECT TOP 1 or SELECT MAX Different?
These two queries both get the same answer from the Stack Overflow database:SELECT TOP 1 LastAccessDate FROM dbo.Users ORDER BY LastAccessDate DESC; SELECT MAX(LastAccessDate) FROM dbo.Users; But do they go about their work the same way? As it turns ou …
Surveiller l’adoption des Microsoft Fabric Copilots
Cet article est disponible en Anglais sur LinkedIn : Monitoring Microsoft Fabric Copilot Adoption | LinkedIn. Les Copilots dans Microsoft Fabric offrent une gamme de fonctionnalités conçues pour enrichir la façon dont vous travaillez avec les données e …
Choosing a File Format – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure Data Lake Storage and can be accessed with tools that you are familiar with. Since the invention of computers, many different file formats h …
The full agenda for the Redgate Summit New York is live!
The post The full agenda for the Redgate Summit New York is live! appeared first on SQLServerCentral.
[Video] I Must Be an Idiot: Automatic Tuning Never Works for Me.
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work. The latest instance involved the recent Query Exercise where you were challenged to fix a computed col …
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 …