SQL Servers and databases are probably the most critical IT parts of an enterprise. The most important and confidential data are stored there and even a potential issue with that data can be business critical. In situations where significant preventive/protective actions are applied, such measures will not be of any help in determining the cause of an incident when it occurs. For that purpose, establishing the SQL Server continuous auditing and especially being informed, timely of security configuration changes have been of the utmost importance. Let us learn about Security Auditing.
SQL SERVER – How to Roll Back SQL Server Database Changes
In a perfect scenario, no unexpected and unplanned changes occur. There are no unpleasant surprises, no inadvertent changes. However, even with all precautions and testing, there is sometimes a need to revert a structure or data change. Let us learn about How to Roll Back SQL Server Database Changes.
SQL SERVER – How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio
This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article.
SQL SERVER – Free intellisense add-in for SSMS
This article shows how to use ApexSQL Complete, a free intellisense add-in. You can download ApexSQL Complete, and play along through the article.
SQL SERVER – Documentation Tool
This article explains how to use ApexSQL Doc, a SQL documentation tool. You can download ApexSQL Doc, and follow along with this article.
SQL SERVER – SQL Server Data Compare Tool
This article shows how to use ApexSQL Data Diff, a SQL data compare tool. You can download it here, install, and play along. Let us learn about SQL Server Data Compare Tool.
SQL SERVER – SQL Server Schema Compare Tool
In this article, I’ll show how to use ApexSQL Diff, a SQL Server Schema Compare Tool. You can download it here, install, and play along while reading this blog post.