Data

External tables vs T-SQL views on files in data lake from Blog Posts – SQLServerCentral

A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what…

3 years ago

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,…

3 years ago

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…

3 years ago

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…

3 years ago

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,…

3 years ago

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,…

3 years ago

Protect your SQL Server from Ransomware: Backup Your Service Master Key and More from Blog Posts – SQLServerCentral

Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.  Some…

3 years ago

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…

3 years ago

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…

4 years ago

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…

4 years ago