10 tips for Test Data Management success
The post 10 tips for Test Data Management success appeared first on SQLServerCentral.
Recover a Database from Suspect Mode Step by Step
On 19th June 2024, the world faced a major outage. The computer on which the Windows operating system was installed started crashing. The primary reason for the outage was a software update that was rolled out by an IT company named CrowdStrike. In our …
Change Data Capture Pipeline Automation in Snowflake
This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples will be using healthcare type data, but the basic tenets apply in most use cases. Introduction Thi …
[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 …