SQL Server - resolving the issue - "Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created."
Shortened version of SQL Server High Availability and Disaster.
This post will tell us the use of Backup and shows a step-by-step guide to backup and restore a database.
Answer for - What is PolyBase?
What is Hadoop? What is Big Data?
What is Azure Data Lake? What is Azure Blob Storage?
Hello Friends, Today in this blog, we will discuss about how to migrate an on-premise SQL database to Azure SQL database (cloud). To make this possible, you must have an Azure subscription and if you don't have an Azure Sql database yet, create one Azure SQL Database. Because we are going to import our on-premise … Continue reading Azure – Migrate On Premise SQL Database To Azure (Cloud)
SQL Server - Cannot connect to SQL Server – A network related or instance specific error occurred
Graph databases support a highly flexible and fine-grained data model. Graphs are extremely useful in understanding a wide diversity of datasets such as below.
Top 10 Must have SQL Queries - SQL Server Series
This article covers basics of database modeling and designing based on information flow from customer’s imagination of a software application to a physical database design.
SQL Server Change Data Capture is a feature that reads changed data from the SQL Server transaction logs and stores them in a special table.
Resolving issue - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).