Financial Advice for Techies
I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s...
2019-02-22 (first published: 2019-02-01)
2,899 reads
Blog Posts
SQL Server 2017 Reporting Services: The Basics Part 2
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-22 (first published: 2019-02-01)
3,061 reads
Appearance: SQL Data Partners Podcast #161
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
5 reads
Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
183 reads
Copy Data From On-Premise SQL Server To Azure Database Using Azure Data Factory
Let’s take a break from our SQL Server 2017 Reporting Services Basics Series and jump to Azure Data Factory (v2)....
2019-02-21
1,835 reads
How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,745 reads
Memory grants 7: DISTINCT (Distinct Sort)
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
398 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,465 reads
Webinar: Migrating SQL Server Integration Services to the Cloud
I will be doing a webinar for MSSQLTips.com about migrating your on-premises SSIS solutions to the Azure cloud. Specifically, the Azure-SSIS integration runtime environment in Azure Data Facture. The...
2019-02-21
19 reads
Azure Key Vault Logging
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
229 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers