ADF, XML objects and XPath in the expression language
When you use ADF, there are two sides to the coin. The first is the data itself that ADF does very well, from moving it from one site to...
2021-02-12
24 reads
Blog Posts
Daily Coping 12 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-12
19 reads
Published Azure Arc-Enabled Data Services Revealed
I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed available now at Apress and your favorite online book sellers! Buy...
2021-02-12 (first published: 2021-02-05)
145 reads
Release Your Inner Synapse
I don’t know about you, but as Microsoft has produced the Azure Synapse platform, I see a plethora of needs that could be fulfilled by it. Being in a...
2021-02-12 (first published: 2021-02-08)
334 reads
Added another 3 new PowerShell functions for reports on Power BI Report Server
I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here. I can’t tell you how many times I’ve...
2021-02-11 (first published: 2021-02-03)
590 reads
Build a Beautiful Site in the WordPress Mobile Apps with Predesigned Page Layouts
We think you'll love the new Starter Page Layouts feature.
2021-02-11
6 reads
Daily Coping 11 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-11
10 reads
Friend of RedGate 2021
This past month RedGate graciously allowed me to be a part of their Friend of RedGate program. It’s been a great seven year run with this program and I...
2021-02-11
18 reads
Set up connection from Azure Data Factory to Databricks
Both, Azure Data Factory and Azure Databricks offer transformations at scale when it comes to ELT processing. On top of that, ADF allows you to orchestrate the whole solution...
2021-02-11 (first published: 2021-02-04)
225 reads
Azure SQL DB – Troubleshooting CPU issues
When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and...
2021-02-10
217 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers