[Video] Office Hours: Ask Me Anything About #SQLServer
I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones: Here’s what we covered: 00:00 Start 01:10 Trushit: You mention in your career internals guide that you focused on high value things for wh …
Thoughts Before Speaking at the Software Architecture Conference
Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more exact – MySQL performance on bigger data sets. You can watch me speak via this link through YouTube – it will be fun! What is the Software Archite …
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 …