Manually updating Statistics
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2021-02-16
229 reads
Blog Posts
Unable to Connect to Target Server? But, I'm Already Connected!
I am working on an Azure SQL Database migration from an on-premises VM, and at the client's request I am working through the BACPAC Import/Export process rather than using...
2021-02-16 (first published: 2021-02-08)
335 reads
Using Data Compare with Recent Data Only
This is a post that looks at how to compare data changes in recent data. A customer recently asked me about looking at a table, and choosing specific data...
2021-02-16 (first published: 2021-02-08)
277 reads
About Friendship and Using Optional Stored Procedure parameters in Azure Data Factory
(2021-Feb-07) "You've Got a Friend in Me" is a well-known song written by Randy Newman and featured in one of Disney's animated films. If I hadn't had a chance...
2021-02-15 (first published: 2021-02-07)
215 reads
Daily Coping 15 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-15
14 reads
Exploring a Docker container’s file system
There are three ways to get into bash in a docker container: docker exec -it containername bash docker exec -it containername “bash” docker exec -it containername /bin/bash Once you...
2021-02-15
25 reads
How to Prep a SQL Server Availability Group for VM-Level DR Replication
If you have a SQL Server Availability Group (AG) and the VMs are being replicated to a disaster recovery site (cloud or on-prem), chances are the networking topology is...
2021-02-15 (first published: 2021-02-08)
314 reads
Speaking at the Kansas City SQL Server User Group
I will be presenting my session “Backup Basics with PowerShell and dbatools” this Thursday, February 18th at 2:30 PM Central Time at the Kansas City SQL Server User Group....
2021-02-15
5 reads
Installing and Configuring containerd as a Kubernetes Container Runtime
In this post, I’m going to show you how to install containerd as the container runtime in a Kubernetes cluster. I will also cover setting the cgroup driver for...
2021-02-14
6 reads
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
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers