Query Exercise Answer: What Makes SELECT TOP 1 or SELECT MAX Different?
This Query Exercise was very different: I didn’t ask you to solve a particular problem. I pointed out that I’ve heard advice that SELECT MAX is faster than SELECT TOP 1, and that’s not quite true. I asked you to find factors that woul …
SSIS in One Hour: Hands-On Tutorial
The post SSIS in One Hour: Hands-On Tutorial appeared first on SQLServerCentral.
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 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.
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?
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
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
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 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
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 …