Sites anglophones


SQL ConstantCare® Population Report: Summer 2024 (And Upcoming Gamification Badges)

Publié le 13 août 2024 sur brentozar.com
 

The short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 in 10 SQL Servers is finally running the latest version. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’ …

As a SQL Server DBA, Postgres Backups Surprised Me.

Publié le 12 août 2024 sur brentozar.com
 

Over the last week, I’ve been working on putting together a Postgres version of the Stack Overflow database, just like the SQL Server one that I’ve distributed for almost a decade now. I’ve worked with Microsoft SQL Server for so long …

 

MySQL vs PostgreSQL: Which Open-Source Database is right for you?

Publié le 12 août 2024 sur simple-talk.com
 

When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL for our backend. Our team was divided: some favored MySQL for its speed and simplicity, while others leaned towards PostgreSQL f …

 

Hiring in IT and Relevance of Domain Experience

Publié le 12 août 2024 sur sqlservercentral.com
 

We recently wanted to hire two candidates (SQL developers with around 5-10 years of experience) to join our team. Since we partner with asset management companies, I wanted to hire people with expertise in asset management. However, my manager, who is …

Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces

Publié le 12 août 2024 sur sqlservercentral.com
 

The post Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces appeared first on SQLServerCentral.

Introducing the pre-con schedule for PASS Summit 2024

Publié le 12 août 2024 sur sqlservercentral.com
 

The post Introducing the pre-con schedule for PASS Summit 2024 appeared first on SQLServerCentral.

Free DBA Job Interview Q&A Course This Weekend

Publié le 9 août 2024 sur brentozar.com
 

If you’re facing an upcoming SQL Server DBA job interview, or if you’re a manager who has to interview DBAs, I want to help. This weekend, I’m giving away my DBA Job Interview Questions & Answers course absolutely free! Just hit u …

Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell

Publié le 9 août 2024 sur sqlservercentral.com
 

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

Publié le 9 août 2024 sur sqlservercentral.com
 

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

Publié le 8 août 2024 sur brentozar.com
 

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?

Publié le 7 août 2024 sur brentozar.com
 

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

Publié le 7 août 2024 sur www.pulsweb.fr
 

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

Publié le 7 août 2024 sur sqlservercentral.com
 

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!

Publié le 7 août 2024 sur sqlservercentral.com
 

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.

Publié le 6 août 2024 sur brentozar.com
 

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 …


Pages :