Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
4,536 reads
Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]
2021-01-12
2,645 reads
Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.
2020-12-17
6,437 reads
Introduction Azure Cosmos DB is Microsoft's globally distributed, multi-model platform-as-a-service (PaaS) database. Any web, mobile, gaming, and IoT application that needs to handle massive amounts of structured, semi-structured and unstructured data may use Azure Cosmos DB. Guaranteed high availability, high throughput, low latency, and tunable consistency help in reading and writing data at a global […]
2020-11-16
6,367 reads
Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]
2020-09-24
45,049 reads
Introduction The Azure Synapse workspace is in preview mode as of July 2020. The workspace brings together enterprise data warehousing and big data analytics. This workspace has the best of the SQL technologies used in enterprise data warehousing, Spark technologies used in big data analytics, and pipelines to orchestrate activities and data movement. Here, I […]
2020-08-24
12,609 reads
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
27,764 reads
This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.
2020-07-20
11,077 reads
Learn how to create a Synapse resource and upload data using the COPY command.
2020-07-13
16,131 reads
Details discussion on the different isolation levels available in SQL Server
2019-03-12
174,916 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
Code Inc Solutions is a top-tier SMO Company in India that truly knows how...
Code Inc Solutions is a top-tier Social Media Optimization Company in India that truly...
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers