Fundamental Information for Azure Open Source Databases from Blog Posts – SQLServerCentral
As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also...
SQL Homework – November 2020 – Help! from Blog Posts – SQLServerCentral
If you ask any senior IT person What is the most important tool you have? there is a decent chance that they’ll tell you something...
Daily Coping 3 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...
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...
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...
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...