In this blog, I have discussed the process of taking backup of MS SQL Database, the types of backups, and steps to take up the backup.
This blog demonstrates the detailed steps needed to set up transactional replication using a backup to initialize the subscriptions without taking the snapshot for all the articles, as we know the snapshot option is time-consuming for large databases.
In this blog, I have discussed the necessary steps for restoring database and retrieving encrypted data when CLE (Cell Level Encryption) is implemented .
“This blog demonstrates the detailed steps needed to set up Transparent Data Encryption with AlwaysOn Availability Group.”
The Microsoft SQL Server is very smart in terms of memory management, but sometimes memory pressure alerts and database engines demand more memory, leading to errors.
In my most recent blog post, Unified data platform and data virtualization through PolyBase: Part Two, I provided a demo of data virtualization through PolyBase.
In 2006, British mathematician Clive Robert Humby marked the words: “Data is the new Oil.” Since then, IT leaders have repeatedly heard this, resonated with the idea, and augmented it at every step.
Most release pipelines have some automation to do after configuration to a virtual machine (VM) to prepare it for use. Looking at SQL Server®, you can configure a lot of options to make it production-ready. What most people do not know is that a resource provider within Microsoft® Azure® configures basic SQL Server settings without the need for any post-configuration scripts.