A VISUAL TAKE-continued

To help determine overall capacity and provide information related to Transactions per second, CPU, memory utilization, disk contention, number of users, database size etc. 

On a regular basis, verify when the last known successful integrity check was performed and identify any possible corruption early on!

 To profile the data contained in the table and its columns.

To dynamically explore, document and understand all database object dependencies.

To write, format, analyze and refactor SQL code and cut down on time coding time.

Contains Powerful, reliable, automated scripting by SQL Server experts.

One of the complex SSIS packages that I have created.

To copy data between an instance of Microsoft SQL Server and a data file in a user-specified format. 

DTS package - SQL Server 2000 version.

Use for Initial Loads and Incremental loads by checking for delta's in data.

To connect to Oracle and Teradata data source or destinations.

To connect to PostgresSQL databases.

Open Database Connectivity interfaces.

To connect to the cloud platform.

To connect to MySQL databases.

To connect to excel sheets.

To connect to Access databases

To connect to flat files, notepad files etc.

Shows fragmentation levels across SQL Servers and shows index type, fragmentation percentages, size and fill-factor.

To automate defragmentation and efficiently manage the improvement of the performance of SQL Server.

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. 

Built-in functions, DBCC, DTA, Error Logs, Extended Events, DMV's, DMF's, sp_who2, sp_lock,sp_monitor, Performance Dashboard.

To get a visual view of storage utilization in all tables of a database and drill down into each table and index for details 

Shows how busy SQL Server is when we add Batch Requests/sec and Transaction/sec counters in Perfmon.

Native SQL Server Job Activity Monitor on that particular server.

Provides comprehensive monitoring of SQL Server agent jobs across the entire SQL Server landscape 

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. 

Generate T-SQL scripts for copying of user permissions.

To ensure SQL Server environment complies with industry regulations such as CIS, DISA STIG, HIPAA, NERC, NIST, PCI DSS, and SOX. 

To protect sensitive data from exposure in non-production or DevOps environments.

To find potentially sensitive data.

Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. 

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. 

To generate realistic test data fast.

Find fragments of SQL in tables, views, stored procedures, functions, jobs etc.

Password Manager