go from Blog Posts – SQLServerCentral
Starter Template
I saved this as a snippet for vscode to get up and running quickly with something better than the defaults for handling func...
Azure SQL Database administration Tips and Hints Exam (DP-300) from Blog Posts – SQLServerCentral
Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many...
Persistent Server Name Metadata When Deploying SQL Server in Kubernetes from Blog Posts –...
In this post, we will explore how a Pod name is generated, Pod Name lifecycle, how it’s used inside a Pod to set the...
Protect your SQL Server from Ransomware: Backup Your Service Master Key and More from...
Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
Some do.
Recently, by far the most...
Daily Coping 2 Nov 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Database Fundamentals #29: Create Foreign Keys With Table Designer from Blog Posts – SQLServerCentral
The purpose of a foreign key is to ensure data integrity by making sure that data added to a child table actually exists in...
Azure DevOps–Using Variable Groups from Blog Posts – SQLServerCentral
I was in a webinar recently and saw a note about variable groups. That looked interesting, as I’ve started to find that I may...
Migrating SSIS to Azure – an Overview from Blog Posts – SQLServerCentral
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an...
Azure Databricks – Adding Libraries from Blog Posts – SQLServerCentral
It is a really common requirement to add specific libraries to databricks. Libraries can be written in Python, Java, Scala, and R. You can...
External tables vs T-SQL views on files in a data lake from Blog Posts...
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between...