AGILE LEARNER | ANALYTICAL THINKER | PROBLEM FINDER+SOLVER
CYBER SECURITY ATTACK+DEFENSE | PROJECT MANAGEMENT
Project Management Professional (PMP), Microsoft Certified Professional and Microsoft Certified Technology Specialist with over 10 Years of experience in SQL Server Architecture, Design, Development, Administration, Programming, Business Intelligence, System Analysis, Data/Database/Server Management, High Availability & Disaster Recovery Solutions in Development, Test & Production environments of Microsoft SQL Server 2000/2005/2008/2008 R2/2012/2014/2016/2017/2019 CTP/Azure versions and Oracle Servers in Windows/Unix based traditional and virtual environments, equipped with excellent communication, leadership, interpersonal, problem-solving and analytical skills with an in-depth understanding of all stages of Software Development Life Cycle.
To Create Workloads and apply database recommendations as necessary.
To capture all processes running in SQL.
Snapshot: Like the name suggests, it is just a snapshot and data could be out of sync.
Transactional: Committed transactions on publisher are written to distributor and then to subscriber.
Merge: Transaction occurred at publisher or subscriber are propagated both ways by the distributor.
Peer to Peer Replication: Enables scaling out of read operations, write performance for the topology is like that for a single node, this is because ultimately all inserts, updates, and deletes are propagated to all nodes
To Compare and Deploy SQL Server database contents.
Copyright © 2019 AWESOME SQL DBA - All Rights Reserved.
Powered by Awesome SQL DBA