AGILE LEARNER | ANALYTICAL THINKER | PROBLEM FINDER+SOLVER
CYBER SECURITY ATTACK+DEFENSE | PROJECT MANAGEMENT
To connect to excel sheets.
To connect to flat files, notepad files etc.
IndexOptimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics. IndexOptimize is supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Azure SQL Database, and Azure SQL Database Managed Instance.
Native SQL Server Job Activity Monitor on that particular server.
SSIS execution history allows you to search for a particular package execution and then drill down into the steps executed and see performance statistics and status.
To protect sensitive data from exposure in non-production or DevOps environments.
SQL Server 2019 with SSMS 18.0 (preview 5 and higher) introduces a new security feature called Static Data Masking. This technique follows the idea of applying Static Data Masking against a production database and then creating a backup of the database with the mask applied, followed by restoring this masked copy to non-production environments.
Copyright © 2019 AWESOME SQL DBA - All Rights Reserved.
Powered by Awesome SQL DBA