ADMINISTRATING A SQL SERVER DATABASE-TECHNICAL TALK- WORKSHOP - By Microsoft Awarded Azure MVP

ADMINISTRATING A SQL SERVER DATABASE

TECHNICAL TALK- WORKSHOP 



Agenda:



Technologies Focused : Administrating a  SQL Server DataBase.

Number of Students : 50

Date of the Programme : 06-01-2018

Location of the Programme : Chennai KaaShiv InfoTech

Programme Mission :


1. Social activities in spreading Microsoft Technologies to the students.
2. Awareness on Microsoft SQL Servers and Database Roles .
3. Practical demos on Microsoft SQL Servers
4.Micosoft Today: Advanced SQL Server Applications in Azure.
5.Talk on SQL Applications and Its Design.


 Overview of Administrating  a SQL Server Data Base :


Describe core database administration tasks and tools:



Install and configure SQL Server:



Configure SQL Server databases and storage:



Assign  Server and  Data Base role:


Plan and implement a backup strategy:



Restore databases from backups:


Authorize user to access resources:

Import and export data:




Backup Server DataBase :


Trace SQL Server activity:



Additional Information about Administrating a SQL:


Comments

Post a Comment

Popular posts from this blog

IMPLEMENT GEO-DISTRIBUTED DATABASE IN SQL- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
IMPLEMENT GEO-DISTRIBUTED DATABASE IN SQL TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :Implement Geo-Distributed data base in SQL Number of Students : 50 Date of the Programme : 07-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Implement Geo-Distributed data base in SQL: How to create a Data base users and how to grant them permission: how to create a server level fire -wall: Set-up a Data base level fire-wall group: Why we need a Geo-Distributed data base:  vital  role of Geo-distributed Database: what is a replication: Capability  ...
Read more

SQL SERVER MANAGEMENT ISSUES- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER MANAGEMENT ISSUES TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Management Issues Number of Students : 50 Date of the Programme : 13-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL  Server Management Issues: Troubleshoot the problem using query analyser: What is in the SQL Server Error log and  Various types of tuning:  E xceptions in  SQL Server Management Objects: What is SQL Server Crash-What  is response time: Focus on Response time and  Solutions for the Issues: Review for performance Count...
Read more

SQL SERVER BUSINESS INTELLIGENCE DATA MODELING -TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER BUSINESS INTELLIGENCE DATA MODELING TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Business Intelligence Data Modeling. Number of Students : 80 Date of the Programme :08-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. SQL Server Business Intelligence overview: What is Data Modeling-Data Modeling a Warehouse: Understanding the data-Building the Data model: Conceptual of Data Model:  Usage of Data Modeling: How to Implement the table in Data Base system: Create Tables Using Designer Tools:
Read more