Microsoft SQL Server 2012 Components and Tools (Quick Overview) - Rev 1.3

Microsoft SQL Server 2012 Components and Tools (Quick Overview) - Rev 1.3

• 1.
  SQL Server Overview Rev1.3-1406 By Naji El Kotob naji [@] dotnetheroes.com www.DotNETHeroes.com
• 2.
  Outlines  Introduction toSQL Server Tools and Core Services  SQL Server Tools  SQL Components  Database Engine  Business Intelligence  SQL Server Integration Services (SSIS)  SQL Server Reporting Services (SSRS)  SQL Server Analysis Services (SSAS)  Interactive in-class DEMO  QnA  References
• 3.
  SQL Server Tools Microsoft SQL Server Tools  SQL Server Management Studio (SSMS)  SQL Server Configuration Manager  SQL Server Profiler  Database Engine Tuning Advisor (DTA)  Data Profile Viewer  And more…  Third-party Tools  SQL Monitor - http://www.red-gate.com/products/dba/sql-monitor/  And more…
• 4.
  About SQL Tools| SSMS  SQL Server Management Studio (SSMS) is a software application first launched with the Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
• 5.
  SQL Server Tools| SQL Server Configuration Manager  SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.
• 6.
  SQL Server Tools| SQL Profiler  SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file.  You can then analyze or use the trace file to troubleshoot logic or performance problems.  You can use this utility to monitor several areas of server activity, such as:  Analyzing and debugging SQL statements and stored procedures.  Monitoring slow performance.  Stress analysis.  General debugging and troubleshooting.  Fine-tuning indexes.  Auditing and reviewing security activity. Ref: http://www.techrepublic.com/article/step-by-step-an-introduction-to-sql-server- profiler/
• 7.
  Tools Overview Demo
• 8.
  SQL Server CoreServices  Microsoft complements its relational database engine, SQL Server, with several add-on services for developing comprehensive business intelligence (BI) solutions.  Services include:  SQL Server Integration Services (SSIS)  SQL Server Reporting Services (SSRS)  SQL Server Analysis Services (SSAS)  And more…
• 9.
  Database Engine  TheDatabase Engine is the core service for storing, processing, and securing data.  Database Engine used to create relational databases for online transaction processing (OLTP) or online analytical processing data (OLAP). This includes creating tables for storing data, and database objects such as indexes, views, and stored procedures for viewing, managing, and securing data.
• 10.
  SQL Server IntegrationServices (SSIS)  SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL).  The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. (Wikipedia)
• 11.
  SQL Server AnalysisServices (SSAS)  Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server.
• 12.
  SQL Server ReportingServices (SSRS)  SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft.  It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).
• 13.
  INTERACTIVE DEMO  ExploringSQL Server Components
• 14.
  Q&A  Please sendyour feedback to naji [@] dotnetheroes.com
• 15.
  References  http://technet.microsoft.com/sqlserver/  http://sqlmag.com/database-performance-tuning/mega-guide-free-sql- server-tools