SSIS in One Hour: Hands-On Tutorial
The post SSIS in One Hour: Hands-On Tutorial appeared first on SQLServerCentral.
Sites anglophones
Introducing PASS Summit Charitable Organization Scholarship
The post Introducing PASS Summit Charitable Organization Scholarship appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Summer 2024 (And Upcoming Gamification Badges)
The short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 […]
As a SQL Server DBA, Postgres Backups Surprised Me.
Over the last week, I’ve been working on putting together a Postgres version of the Stack Overflow database, […]
MySQL vs PostgreSQL: Which Open-Source Database is right for you?
When I joined a growing startup company as a backend developer, we were at crossroads choosing between […]
Hiring in IT and Relevance of Domain Experience
We recently wanted to hire two candidates (SQL developers with around 5-10 years of experience) to join our […]
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
The post Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces appeared first on SQLServerCentral.
Introducing the pre-con schedule for PASS Summit 2024
The post Introducing the pre-con schedule for PASS Summit 2024 appeared first on SQLServerCentral.
Free DBA Job Interview Q&A Course This Weekend
If you’re facing an upcoming SQL Server DBA job interview, or if you’re a manager who has to […]
Promote Simple Talks podcast episode 2: Coffee chat with Huxley ...
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 […]
Query Exercise: What Makes SELECT TOP 1 or SELECT MAX ...
These two queries both get the same answer from the Stack Overflow database: SELECT TOP 1 LastAccessDate FROM […]
Surveiller l’adoption des Microsoft Fabric Copilots
Cet article est disponible en Anglais sur LinkedIn : Monitoring Microsoft Fabric Copilot Adoption | LinkedIn. Les […]
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 […]
The full agenda for the Redgate Summit New York is ...
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 ...
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a […]
MySQL Index Overviews: B-Tree Indexes
In this first entry in a multipart series on indexes, I will cover the most important index […]
Level up your learning in 2024 with PASS Data Community ...
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 […]
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
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 ...
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 […]
Who’s Hiring in the Microsoft Data Platform Community? August 2024 ...
Is your company hiring for a database position as of August 2024? Do you wanna work with the […]
[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. […]
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 […]
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 […]
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. […]
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: […]
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]