Daily Coping 26 Oct 2020
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...
2020-10-26
19 reads
Blog Posts
How To: Create Schema Only Database Copies
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...
2020-10-26 (first published: 2020-10-20)
1,432 reads
Using Managed Identities to authenticate Function Apps
I have a video detailing how to use Managed Identities to authenticate function apps in Azure.
2020-10-26
7 reads
Daily Coping 23 Oct 2020
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...
2020-10-23
26 reads
Synapse and federated queries
As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about...
2020-10-23 (first published: 2020-10-15)
466 reads
Using Durable Functions in Azure Data Factory - Support for long running processes in Azure Functions
(2020-Oct-14) Ok, here is my problem: I have an Azure Data Factory (ADF) workflow that includes an Azure Function call to perform external operations and returns output result, which in...
2020-10-23 (first published: 2020-10-15)
1,132 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-23
6 reads
Azure Databricks – Pin Cluster
Before discussing why you would want to pin a cluster it would be useful to understand the different states of a cluster. We can have: I usually have “auto...
2020-10-22
123 reads
Daily Coping 22 Oct 2020
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...
2020-10-22
24 reads
One Thousand SQL Saturdays (*ish)
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule, with lots of neat sessions. I’ll be speaking in the am, and am happy to...
2020-10-22
107 reads
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers