
2020 review: the year by the numbers
The last post of the year! It’s been a terrible year all round, as I’m sure you’ll all agree, and I’m very glad we’re rolling into 2021 in a few hours. Now it’s time for my traditional post counting down some of the …

2010s: the decade in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been enjoying it, so I’ve continued the tradition ever since. Until 2020. I do most of my reading while traveling, which I only did onc …

Your Ten Favorite Blog Posts from 2020
The most popular posts this year were when I ran my Fundamentals classes for free throughout the year. I ran a different class per month, and posted signups and videos here on the blog. I’m setting those aside, though, because they’re not e …
SSRS Install, Setup and Configuration
The post SSRS Install, Setup and Configuration appeared first on SQLServerCentral.
PowerShell Day By Day: The Pipeline
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hope …
[Video] Office Hours: SQL Server Career Q&A, Part 3
Here’s the last video in my vacation series with the answers to your most-upvoted professional development questions. Enjoy! I won’t be taking new questions in the comments, but I’m leaving the comments open on this post so that …
Save costs with Azure Data Factory
A typical project following any industry standard process for building Azure Data Factory (ADF) pipelines will have different environments as part of development lifecycle. They might be named Development, Staging, Production, and so on. This article d …
Azure Synapse Analytics Data Integration and Orchestration
The post Azure Synapse Analytics Data Integration and Orchestration appeared first on SQLServerCentral.
As an Attendee, What’s Important to You In a New Data Community?
With PASS shutting down, it’s time to think about what the community builds in its place. There are a lot of efforts going towards building replacements for PASS, including Microsoft’s own efforts. Because these efforts are often led by act …
Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs
The post Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs appeared first on SQLServerCentral.
SQL Server REPLACE
The post SQL Server REPLACE appeared first on SQLServerCentral.
Migrate the SSIS Catalog in Just a Few Clicks
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS, called the project deployment model. This new model has many benefits in terms of managing SSIS project deployments, executions, and configurations. With every new versi …
Stored Procedure in SQL Server with R Code
The post Stored Procedure in SQL Server with R Code appeared first on SQLServerCentral.
Database Build Blockers: Four-part Object References
The post Database Build Blockers: Four-part Object References appeared first on SQLServerCentral.
[Video] Office Hours: SQL Server Career Q&A, Part 2
Last week, I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here’s the next video with the questions you upvoted the most, and I’ll post the last round of ’ …