Data Science Training

 

SequelGate Technologies offers best Data Science LIVE Online Training with most experienced professionals. Our Instructors are Real-time Professionals in Big Data and Data ANalytics areas with proven expertize. All our training sessions are completely Real-time, hands-on. We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Register Today

 

This course includes : Hadoop, R Studio, Python, Scala, Machine Learning, Tableau, Excel and more..!

 

REGULAR SCHEDULES: Classroom Training

Schedule Free Demo Start Date
6:30 AM July 14th July 15th Register
11:30 AM July 20th July 21st Register
 

WEEKEND SCHEDULES: Classroom Training

Schedule Free Demo Start Date
11:30 AM July 15th July 16th Register

Trainer: Mr Vamsi (18+ Yrs Exp)

Dur: 16 Weeks (Mon - Fri).

Total Course Fee: INR 35,000/- INR 30,000/-

 

Highlights

  • ✔ Completely Practical and Realtime
  • ✔ Theory Material provided in Advance
  • ✔ Highly Interactive and Interesting
  • ✔ Certification Guidance and FAQs
  • ✔ 80% Hands on Training, 20% Theroy part Explanantion

Pre-requisites for this course: NONE. Anyone can join!

 

Data Science Training Course Content

Data Science Training

 

 

Hadoop Training

Scala & Spark Training

Statistics, R-Language & Meachine Learning

HDFS

  • What is Big Data?
  • Challenges for processing big data?
  • What technologies support big data?
  • What is Hadoop?
  • Why Hadoop?
  • History of Hadoop
  • Use Cases of Hadoop
  • Hadoop eco Systems

Understanding the Cluster

  • Typical Workflow
  • Writing files to HDFS
  • Reading files from HDFS
  • Rack Awareness, 5 daemons

Map Reduce:

  • Before Map reduce
  • Map Reduce Overview
  • Job Tracker
  • Task Tracker Job Scheduling
  • Mapper and Reducer code
  • Configuring development environment – Eclipse

How MapReduce Works:

  • Anatomy of Map Reduce Job run
  • Job Submission, Job Initialization
  • Task Assignment
  • Job Completion, Job Scheduling
  • Job Failures, Shuffle and sort

PIG

  • Pig basics
  • Install and configure PIG on a cluster
  • PIG Vs MapReduce and SQL
  • Pig Vs Hive
  • Pig Latin
  • Primitive  Data Types and Complex Data Types
  • Types of Modes
  • Interactive mode
  • Script mode
  • Embedded mode
  • Modes of running PIG
  • Running in Grunt shell
  • Programming in Eclipse
  • Loading and Storing Datasets, Filters, Groups, Co-Groups, Foreach, Nested Foreach, Parallel, Distinct, Limit, Sample, Different Types of Joins
  • Debugging Commands(Illustrate and Explain)
  • Processing XML Files using Piggy bank
  • Processing Logfiles using Regex
  • Pigdate Function
  • PIG UDFs,UDAFs
  • Working with Predefine Functions, User Define Functions
  • Pig Macros
  • How To Load and Write JSON DATA using PIG
  • Accessing HBASE USING PIG

HIVE

  • Hive Introductions
  • Hive Architecture
  • Different Modes to Access HIVE
  • Command Line Interface
  • Web Interface(HWI)
  • Thrift Interface
  • Hive Meta Store
  • Hive QL
  • Primitive Data Types and Complex Data Types
  • Working with Partitions
  • Hive Bucketed Tables and Sampling
  • External Tables
  • Nested Queries
  • Multiple Inserts
  • Dynamic Partitions
  • Different Types of Joins
  • ORDER BY,SORT BY, DISTRIBUT BY,CLUSTER BY
  • INDEXES,VIEWS
  • Compression on Hive Tables and Migrating Hive Tables
  • Hive SerDe's
  • Processing XML Files using Regex
  • Processing Log Files using Regex
  • Accessing Hbase Tables using Hive
  • Hive UDF
  • Hive UDAF
  • Hive UDTF

Hbase

  • Hbase introduction
  • Hbase Data Model and Comparison between RDBMS and NOSQL
  • HBase  Architecture
  • HMaster,HRegionServer,Zookeeper,HRegion
  • File storage architecture
  • HFiles Compction,DeCompaction,Region Splits
  • HBase Opreations(DDL AND DML)Through Shell
  • Hbase Installation
  • Internal Zookeeper,External Zookeeper
  • Hbase Counters
  • Hbase Filters
  • HBase use Cases
  • Install and Configure HBase on a Multi Node Cluster
  • Create Database, Develop and Run Sample Applications
  • Access Data Stored in HBase  using Clients like Java, Python
  • MapReduce Client to Access the HBase  Data
  • HBase  and Hive Integration
  • HBase  Admin Tasks

Cassandra

  • Introduction
  • Installation
  • Creation of Database

DAY 14: DATABASE BACKUPS - OPTIONS

  • Backups - Background Threads, MSDB
  • Backups - Types, Importance, Options
  • Data Backups, Checkpoints, Page Level
  • File Backups, Filegroup Backups - Extents
  • Log Backup Mechanism, Data Truncates
  • Partial Backups with ReadOnly Filegroups
  • Tuning Database Backup Operations
  • Mirrored Backups, FORMAT, SKIP, STATS
  • Tape Backups - LOAD, UNLOAD, ERRORS
  • COMPRESSION, CHECKSUM, VERIFY
  • ContinueOnError, Backup Validation
  • Backup History From MSDB Database
  • Backup Audits - Media Set, Media Family
  • Remote Backups and Security Options
  • Compatibility, Recovery Model Options
  • COPY_ONLY Backups and Importance
  • Important Queries for Backup Audits
  • Backup Verification, Security KEYS
  • Backups using GUI and T-SQL Scripts
  • Backup Devices - Purpose, Options
  • Real-time Errors, Solutions @ Day 37

DAY 15: RESTORES AND DB RECOVERY

  • Data Recovery using Backups, Log Files
  • Restore Phases - COPY, REDO, UNDO
  • Database Restores & FILELIST Options
  • File Restores and Filegroup Restores
  • FILELISTONLY, VERIFYONLY, REPLACE
  • PARTIAL & PIECEMEAL Restores - Tuning
  • Tail Log Backups & DB Recovery Options
  • REDO Phase with T-Log Backups, Purpose
  • Tail Log Backup Restores, UNDO Phase
  • Partial Backups - STATS, VERIFY Options
  • Strategies: Piecemeal/Piecemeal Restores
  • SQL Server 2012 to 2014,2016 Restores
  • Choosing correct DB Recovery Model
  • Point-In-Time Restores and Log Recovery
  • Restores From Backup Devices & Mirrors
  • Restores From existing Databases, Files
  • Restores using SQL Server T-SQL Script
  • Restores using GUI. Data & Log Options
  • Transaction Undo Files (TUF) Purpose
  • Restore Audits and Standby Databases
  • Checkpoint LSN and Restore Positions
  • Real-time Errors, Solutions @ DAY 37

DAY 16: JOBS, SQL SERVER AGENT

  • SQL Server Agent Service, Agent XPs
  • SQL Agent Jobs - GUI Options, MSDB
  • Job Steps: T-SQL, SSIS, Replication
  • Job Schedules and Frequency Options
  • Job Schedules and Email Notifications
  • Job Executions, Disable/Enable Options
  • Job History and Job Activity Monitor
  • Import & Export (SSIS) Operations
  • OLE-DB, SQLNCLI and MS Jet Drivers
  • SSIS Packages for Data Import/Export
  • SSIS Package Store - File System, MSDB
  • SSIS Jobs - Scheduling SSIS Packages
  • Backup Strategies For Minimal Data Loss
  • Backup Jobs and Recovery Modes - Usage
  • Backup Limitations with Recoery Modes
  • Startup Jobs, Onetime, Recurring Jobs
  • Job Activity Monitor and Agent Threads

DAY 17: PERFORMANCE TUNING - 1

  • Identifying Long Running Queries
  • Dynamic Management Objects: DMV, DMF
  • Audit Long Running Queries - DMV/DMF
  • Audit Frequent Running Queries - DMF
  • Query Audits and DMVs / DMFs with Joins
  • Query Statistics & LIVE Execution Plans
  • CROSSAPPLY with Dynamic Views
  • Avoding Sub Queries and Conditions
  • Comparing Sub Queries and Query Joins
  • Query Tuning and Resource Optimization
  • Common Table Expressions (CTE) & Uses
  • Using CTE, Data Retrieval in Stored Procs
  • CTEs for Avoiding Self Joins, Scenarios
  • CTE Advantages and Limitations
  • Anchor, Recursive Members, Termination
  • HASH JOIN Examples and Precautions
  • MERGE JOIN Examples and Precautions
  • LOOP JOIN Examples and Precautions
  • OUTER APPLY and Multi - Level Joins

DAY 18: PERFORMANCE TUNING - 2

  • Table Partitions and Query Tuning Options
  • Partition Functions and Partition Schemes
  • Partition Ranges, Values and Sort Orders
  • Partition Un-partitioned Tables: Indexes
  • Aligned / Indexed Partitions - Importance
  • Data Compression - ROW & PAGE Levels
  • Partition Numbers & Filtered Compression
  • Managing Partitions and Tuning Options
  • Partition Management @ SPLIT, MERGE
  • Partition Elements, Concolation Options
  • STATISTICS - Purpose and Tuning Options
  • Column Statistics - Usage Advantages
  • Index Statistics - Auto Index Creations
  • Manual Update of Column Statistics
  • Statistics in Query Tuning Process
  • STATISTICS in Indexes, Query Conditions
  • LIVE Query Statistics, Table Statistics

DAY 19: PERFORMANCE TUNING - 3

  • LIKE Operator - Using Wild-cards
  • Full Text Search Service Configuration
  • Full Text Search - Database Settings
  • Database Catalogs (FTC) and Storage
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Columns and Primary Key Index
  • Full Text Index - Search Query Issues
  • Full Population, Incremental Population
  • CONTAINS() and FREETEXT() Functions
  • Token Search and Inflectional Forms
  • Performance Tuning @ Full Text Indexes
  • CONTAINSTABLE and FREETEXTTABLE
  • Real-world Considerations with FTS
  • FT Index Management Options, Statistics
  • Stop Words Management, Tuning Options
  • New Tuning Options @ SQL 2016

DAY 20: PERF. TUNING - LEVEL 4

  • Index Internals and Execution Plans
  • Execution Plans, Statistics, Query Cost
  • Index Fragmentation Issues, Performance
  • SAMPLED and DETAILED Scans. FillFactor
  • Index Rebuilds (Online/Offline), Tuning
  • Index Reorganization and Advantages
  • Page, Row Compressions with Indexes
  • Filtered & Online Indexes, Indexes Views
  • GAM, SGAM Pages, Metadata Info
  • Filtered Indexes and Size Limitations
  • Table Statistics, Query Tuning Options
  • Heaps, Clustered, Nonclustered Indexes
  • Fill Factor, Pad Index and Query Tuning
  • DTA: Sequential / Parallel Query Tuning
  • DTA Tool with Profiler, Trace Tables, Cache
  • Workload Files & Tables in Profiler
  • SQL Profiler Tuning and Tuning Templates
  • Database Tuning Advisor (DTA) - Usage
  • DTA for Procedure Cache, Recent Queries
  • DTA Tool for Multi-Database Connections
  • Understanding PDS Options with Indexes
  • MORE TUNING CONCEPTS: DAYS 35, 36

DAY 21: REPLICATION For HA -- LEVEL 1

  • Replication Architecture and Entities
  • Replication Topology, Plan, Connections
  • Distributor Server Configurations, Options
  • Distribution DB Configuration, Snapshots
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • PULL Subscription Options and Types
  • Snapshot Replication and Repl Agents
  • Configure, Secure, Schedule Snapshots
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Tracer Tokens - Latency and Ranking
  • Replication Monitor - Usage and Options
  • Read Only Subscribers & Load Balancing
  • Replication Jobs and Verification Options
  • Adding Articles to Existing (LIVE) Replica
  • Adding Subscribers to Existing Replica
  • Stopping, Starting Replication Agents
  • Scripting Replication Jobs, Publications
  • Disable/Enable Replication, Agent Stops
  • Real-time Errors, Solutions @ DAY 37

DAY 22: REPLICATION For HA -- LEVEL 2

  • Transactional Replication, Tracer Tokens
  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Peer-Peer Replication Connections, Nodes
  • Adding Peer Nodes, Node ID Conflicts
  • Replication across Lower/Higher Versions
  • Replication Conflicts: Options, sp_MSRepl
  • IDENTITY Property & Schema Replication
  • PUSH and PULL Subscriptions - Options
  • Domain Account Security in Replication
  • Merge, Snapshot Replication Limitations
  • Replica Initialization with Backups, Issues
  • Transactional Versus Snapshot Replication
  • Peer-Peer Vs Merge Replication For HA
  • Load Balancing Options with Replication
  • Replica Server @ Appl Connection Strings
  • Replication Conflicts, Errors and Solutions
  • Replication Warnings and Agent Alerts
  • Replication for HA and DR - Strategies
  • Replication Errors, Solutions @ DAY 37

DAY 23: LOG SHIPPING - DISASTER RECOVERY

  • Log Shipping Topology, Operation Modes
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor Settings, Alerts
  • NORECOVERY Configuration and Usage
  • STANDBY Mode Configuration, Purpose
  • Log Shipping Jobs & Restore Schedules
  • Copy and Restore Jobs with Secondary
  • Log Shipping Monitor Status Reports
  • Manual Failover Process and Recovery
  • Versioning Issues, Data Traffic. Data Loss
  • Log Shipping Jobs - Errors and Solutions
  • Log Shipping Reports and Data Recovery
  • Log Shipping Standby: Delay Restores
  • Scripting Log Shipping Configurations
  • Standby Disconnections, Latency Options
  • Real-time Errors, Solutions @ DAY 37

DAY 24: DATABASE MIRRORING: HA / DR

  • DB Mirroring Architecture For HA,DR
  • DB Mirroring Configuration Scenarios
  • TCP Endpoints and TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Service Accounts Configurations, Use
  • Automatic Fail-Over Procedures, Tests
  • Manual Failover Options and Scenarios
  • PARTNER OFFLINE Conditions & Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • Manual Failover and HA Partner Roles
  • Mirroring Monitor, Stop/Resume Options
  • DR & HA with DB Mirroring Advantages
  • Need for Always-On & Higher Availability
  • SET PARTNER Options and Db Recovery
  • DB Recovery without Witness. Failover
  • DB Mirroring Errors, Solutions @ DAY 37

DAY 25: DB HEALTH CHECKS, AUDITS

  • Query Resources - CPU, IO and Memory
  • Activity Monitor (AM) Tool - CPU, Memory
  • Database File IO, Processes, Query Stats
  • SQL Profiler Tool Usage, Audit Trace Files
  • SQL Profiler Templates: Standard, Tuning
  • Event Extraction Settings, Filter Columns
  • DB ID Filters, CPU Filters, SSID Filters
  • Profile Trace File Rollover, Size Settings
  • Database Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • ESTIMATEONLY, NO_INFOMSGS, Tempdb
  • Log Space Audits and Tempdb Audits
  • Dynamic Management Views (DMVs)
  • Important Dynamic Management Functions
  • Memory Usage & Disk Usage Audit DMVs
  • Storage Allocation Issues (Page, Extent)
  • LOCKS - Types, Impact, Monitoring
  • Shared Locks, Exclusive Locks, WAITS
  • Deadlock Graphs with SQL Profiler Tool
  • DEADLOCKS - Avoidance, Prevention
  • LIVELOCKS - Avoidance, Prevention
  • Deadlock Graphs @ SQL PROFILER, XDL
  • Isolation Levels For OLTP - TempDB

DAY 26, 27: SECURITY MANAGEMENT

  • Authentication Types - WINDOWS, SQL
  • Windows Logins and REGEIDT Settings
  • SQL Server Logins, POLICIES, EXPIRY
  • LOGINS: Server Level Security, Options
  • USERS: Database Level Security, Options
  • SCHEMAS: Object Level Security, Options
  • System Server Roles, Database Roles
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • Testing Security Operations, Scripting
  • Common Security Functions & Queries
  • DMVs for Server and DB Security Audits
  • KEYS, Passwords - Data Level Encryption
  • CERTIFICATES & TRIPLE-DES Algorithm
  • Master Passwords and Data Encryption
  • SQL Server Credentials, Job Security
  • Proxies - Purpose, Usage and Options
  • SSIS Proxies for Job Level Subsytems
  • Password Resets and Disabling Logins
  • Scripting Logins, Users, Roles, Schemas
  • Security Audits, Role Membership
  • Containment Databases and Purpose
  • Contained Database Users and Roles

DAY 28: MAINTENANCE PLANS, REPAIRS

  • Database Maintenance Plans (SSIS)
  • DB Maintenance Strategies & Schedules
  • MSDB History Management Options
  • Backup Files and Space Management
  • Reorganizing Indexes with Maint. Plans
  • Stats Updates (Automatic) and Jobs
  • Modifying SSIS DB Maintenance Plans
  • Scheduling and Maintaining SSIS Plans
  • Log File Issues & Shrinking Operations
  • SQL DB Engine Properties & Guidelines
  • Service Configuration Manager Options
  • PAGE REPAIRS - suspect pages @ MSDB
  • FILE REPAIRS, FILEGROUP REPAIRS
  • DATABASE REPAIRS - DB Consistency
  • DATABASE REPAIRS - Data Allocation
  • DB Modes, Emergency, NOWAIT Options
  • Managed DB Backups @ SQL 2016

DAY 29: DB MIGRATIONS, DMA TOOL

  • Database Migration Options with SSIS
  • DB Design Audits @ File System Store
  • Database Detach Options and Downtime
  • Database Attach Options and Scripting
  • Scripting: Schemas, Object, Keys, Data
  • Scripting Security Logins, Permissions
  • Copy Database Wizard (SSIS) Tool Usage
  • File System, SQL Server Package Store
  • Migration Schedules, Jobs, Alerts, Logs
  • Corrupted Logs, FORATTACH, REBUILDS
  • Linked Server Security, Management
  • Server Dashboard, Connection Audits
  • Data Migration Assistant (DMA) Tool
  • Using DMA Tool for DB Analysis, Upgrades
  • DMA Tool: DB Assessment, Migration

DAY 30: PATCHES, SERVER UPGRADES

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • Service Packs and Patch/hotfix Activities
  • Instance Selectivity for Updates, Cautions
  • Pre & Post Patch Operations. Process
  • Verifications, SmokeTest and Rollbacks
  • Upgrade Advisor Tool - Analysis Reports
  • Upgrade Advisor Issues and Warnings
  • Server Upgrades and Precautions
  • Planning for Maintenance Activities
  • Rebuilding System Databases & DAC
  • Pre Database Maintenance Activities
  • Post Database Maintenance Activities
  • Real-world Management Considerations

DAY 31: CLUSTERING CONFIGURATION

  • Understanding SQL Clustering Service
  • SQL Server Clustering Architecture
  • Windows and SQL Server Licensing
  • Windows Server Installation Options
  • Service Pack and Patch Installations
  • QUORUM Options for Windows Clusters
  • SQL Server Cluster Plan - Licensing
  • Installing Windows MSCS Service, Tests
  • Ping Tests and Heart-beat Checks, DC
  • Domain Configurations, Precautions
  • MSCS - Microsoft Cluster Services, Nodes
  • MSCS Service Startup Options, Issues
  • Verifying SQL Server Cluster Installation

DAY 32: CLUSTERS: ACTIVE DIRECTORY

  • Need for Centralized Authentication
  • Domain Controller (DC) Configuration
  • Active Directory Settings and Usage
  • DCPROMO Settings for Active Directory
  • Server Configuration Manager, Options
  • Configuration Manager - Users & Groups
  • Working with Active Directory (AD) Edits
  • Network Configurations and Precautions
  • PING Configurations and DTC Options
  • QUORUM settings and SAN Options
  • SQL Server Cluster Installation
  • Cluster Configurations - Active/Active
  • Cluster Configurations - Active/Passive
  • MS DTC Configurations (Local/Remote)

DAY 33: CLUSTERS NODES, ALWAYS-ON

  • Install SQL Server Clusters
  • Clustering Nodes : Install, Update
  • Need for Always - On Availability
  • Always-On Prerequisites, Node Config
  • SQL Group & AD Syncup Operations
  • SAN System for Shared Data Storage
  • Smoke Test Procedures in Real-time
  • Fail-Over Disk & RAID Implementation
  • Cluster Connection Issues and Drains
  • Installing Updates - SQL Server Clusters
  • Add Nodes to SQL Cluster - Active/Active
  • SQL Server Cluster Utilities & Quorum
  • Cluster Working and Operative Modes
  • Configuration Settings, SQL Monitors
  • Always-On Availability Groups (AAG)
  • Prerequisites for Always-On for HA/DR
  • Primary & Secondary Configurations
  • Synchronization Settings, HA Options
  • Port Settings, Backup Strategies in AAG

Applicable for PLAN B Registrations:

DAY 34: SQL CLUSTERS, ALWAYS-ON

  • IP Configurations & WSFC Settings
  • Node Majority, Disk & File Share Majority
  • Active-Passive Cluster Configurations
  • Network Security Issues with Solutions
  • RAID, Storage Issues with Solutions
  • Availability Replica - Readable Secondary
  • Active Secondary, SYNC, ASYNC (AAG)
  • Replica Recommendations for Always-On
  • Routine DBA Challenges for AAG - HA/DR
  • SLA/OLA Challenges, Tickets in Always-On
  • Temporal Tables - AAG : SQL 2016
  • Stretch Databases @ SQL 2016

DAY 35: PERF. TUNING - LEVEL 5

  • Memory Optimized Tables and Filegroups
  • Memory Snapshot Settings in Real-world
  • Temporal Tables, SYSTEM_VERSIONING
  • Temporal Tables For Audits, Performance
  • In-Memory Tables and Index Options
  • Extended Events & Performance Impact
  • LIVE Query Statistics - Monitoring, Metrics
  • LIVE Query Statistics - Tracing, Baselining
  • Performance Baseline Methodologies
  • Optimize configuration of your databases
  • Use DMVs and DB Performance Metrics
  • Memory Tables Versus Temp Tables/Tables
  • LIVE Execution Statistics, Hash Plans
  • System Versioned Temporal Tables
  • Querying, Modifications to Temporal Tables
  • Tuning For Bulk Inserts - Recovery Models
  • Cached Plans and Memory Store for SPs
  • Performance Tuning - Checklist Activities

DAY 36: PERF. TUNING - LEVEL 6

  • PERFMON Counters and MSDTC Service
  • Memory, IO Resources : Performance
  • MEMORY LEAKS and PAGE WAITS
  • LATCH WAITS and Query Performance
  • CPU, Thread Management, Windows Fibres
  • Working with Machine Code @ SQL Server
  • Resource Governor - Resource Pools
  • Resource Workload Groups, Settings
  • LOW, HIGH, MEDIUM Priority Queries
  • Classifier Function, Cost Based Optimize
  • Query Priority, CPU / Memory / IO Limits
  • Windows Fibres and Priority Boost
  • Degree Of Parallelism (DOP) Settings
  • Processor Settings, Counter Thresholds

DAY 37: COMMON ERRORS, SOLUTIONS

  • ROOT CAUSE ANALYSIS STRATEGIES
  • Common Backup Errors, Solutions
  • Restore Errors and DB Offline Errors
  • Replication Errors and Solutions
  • Log Shipping Errors and Solutions
  • Trace Flags and Usage. DBCC PAGE
  • DB Suspect Errors and Solutions
  • Dynamic Data Masking (DDM)
  • Security Scenarios with DDM Feature
  • 3rd Party Tools (Litespeed) and Usage
  • Ticketting Tools and SLA / OLA
  • Database Support Levels, Escalations
  • Descalations and KB Articles

DAY 38, 39: Real-time Project for SQL DBA

  • Always-On with HR, DR, PSSDIAG
  • 3rd Party Tools, SLA/OLA
  • Server Aliases, Configuration Manager, Ports
  • Database Migration to SQL Azure
  • SQL DBA Checklist - 1 : Errors, Solutions
  • SQL DBA Checklist - 2 : Errors, Solutions

Register Today