Transcript SQL Server & High Availability - E

By George Squillace
New Horizons Great Lakes
Husband, Dad, Coach, MCT, MCSE, MCDBA
MCITP – SQL 2008 Business Intelligence Development
MCITP – Database Administration
MCTS – Database Development
MCITP – Enterprise Messaging Administrator on Exchange 2007
MCITP – Enterprise Administrator on Windows Server 2008
MCTS – Vista Deployment
CompTIA A+, Network+
»
Product knowledge is in high demand
˃
˃
˃
»
The product is becoming increasingly entrenched
It’s market share is growing
The need to learn the product is in high demand.
The following Microsoft products require some edition of SQL Server
˃
˃
˃
˃
˃
˃
˃
SharePoint
System Center Configuration Manager (SCCM)
System Center Virtual Machine Manager (SCVM)
System Center Operations Manager (SCOM)
System Center Data Protection Manager (SCDPM)
ForeFront Endpoint Protection
Microsoft Dynamics CRM
»
More confidently sell high margin courses that are not provided by many vendors.
»
Be able to respond to customer questions more rapidly.
»
Make better course recommendations.
»
Grow in your career skills.
» SQL (Structured Query Language) is a
data-oriented programming language
» SQL is an industry standard (ANSI, ISO)
» SQL permits a nearly universal method of
querying (interacting with and changing)
database data
» Most popular database servers support their
own form of SQL
(Microsoft’s is “Transact-SQL” or “T-SQL”)
» Microsoft SQL Server is a software product
The least amount of
SQL code that can
successfully be
submitted for
processing is a
statement.
Statements are
organized in to
statement
categories, such as
“DML” and “DDL”.
•
Database Administrators would use most or all categories of SQL statements.
•
Database Developers would use most or all categories of SQL statements.
•
Ad hoc query writers and report writers would primarily use
the SELECT DML statement.
» SQL Server was originally a
product by Sybase
» Microsoft joint-developed the
product early on but later severed
ties to Sybase
» There have been many versions of
the product
» Having gone through many
versions and refinements SQL
Server is a mature, robust, &
stable product
» SQL 2012 was released on
April 1, 2012.
Reference:
http://en.wikipedia.org/wiki/Microsoft_Sql_Server
» There are
many
installable
components to
the SQL Server
product
» All these
features are
included with
the price
(depending on
the Edition
purchased)
Reference:
What SQL Server is
best known for, the
relational database
service.
http://www.e-squillace.com/tech/screenshotgallery/SQL/SQL2008/SQL2008_InstallScreenshots/Step9a-FeatureSelection_Empty.JPG
» www.microsoft.com/express
» There are also free editions of the Visual Studio
Windows and Web development tools!
» The free edition of SQL Server (SQL Server
Express Edition) and the free versions of Visual
Studio are found at the URL above
Compare this model to:
Microsoft Access
FileMaker
FoxPro
»Front-End Application Design
˃Custom Windows application using Visual Studio or alternatives
˃Custom Web application using Visual Studio or alternatives
˃Many Custom-made Applications Involve a Database
»Back-End
Database Design
˃Built Using
Transact-SQL
and/or GUI Tools
+Stored Procedures
+Views
+Functions
+Triggers
Reference:
Database Construction Building Blocks Diagram
Programming Objects
Views
User-Defined
Functions
Stored
Procedures
Triggers
Data Integrity Design
Data Retrieval Design
(Constraints, Defaults and Rules)
(Indexes)
Table Design
(Columns, Data Types, Relationships [Logical Data Model])
Database Snapshot Design (SQL Server 2005, Enterprise Edition)
Schema Design (SQL Server 2005)
Database Creation, Files, Filegroup & Logfile Design
(Ask: Do I need more than just the Primary Filegroup, and/or more than one file per filegroup?)
Operating System & File System Design
(Number of Drive letters, placement of \Windows folder, Pagefile, SQL Server binaries, etc.)
Server Hardware
(CPU, RAM, Number and size of Disks, Number of Drive Channels)
» Database Administrator (DBA)
(including “Accidental DBAs”)
» Database Developers
» Business Intelligence Developers
˃ Report Writers / Developers
˃ OLAP (Online Analytical Processing) and Data Mining Developers and
Users
˃ ETL Developers (Extract, Transform, & Load)
» Business Analysts
» 2778A – Writing Queries Using SQL Server 2008 Transact-SQL
(3-days)
˃
˃
Target: All data professionals (DBAs and Devs), Report Writers, Business Analysts
The SQL 2012 successor is course 10774A (five days)
» 6231B – Maintaining a SQL Server 2008 Database
(5 – days)
»
»
Target: Database Administrators (DBAs)
The SQL 2012 successor is course 10775A (five days)
» 6232B – Implementing a SQL Server 2008 Database
(5 – days)
˃
˃
Target: Database developers (Devs)
The SQL 2012 successor is course 10776A (five days)
» We also offer courses from the courseware library, such as 50400
Ask: What do you need to know about the “B” revisions of these courses?
» From Wikipedia: Business intelligence (BI)
is a business management term which refers to applications
and technologies which are used to gather, provide access to,
and analyze data and information about company operations.
» Business intelligence systems can help companies have a more
comprehensive knowledge of the factors affecting their business,
such as metrics on sales, production, internal operations, and they
can help companies to make better business decisions.
» So, BI is about making better decisions.
» Use Tools 
Changes.
Get Facts  Draw Conclusions  Implement
» 6234A – Implementing SQL Server Analysis Services
(3-days) (If taking more than one BI course take this last!)
˃ Working with Multidimensional Databases (rather than Relational) and Data Mining)
» 6235A – Implementing SQL Server Integration Services
(3-days)
˃ Transferring and Transforming Data (a.k.a., ETL, “Extract, Transform, & Load”)
» 6236A – Implementing SQL Server Reporting Services
(3-days)
˃ Data Presentation Platform
These course revisions are more tool-oriented
than task-oriented, which (fortunately) changes
in the SQL 2012 courses.
These courses are combined into two, five day courses in
SQL 2012; courses 10777A and 10778A.
Reference:
SQL Server 2008 Certification Paths diagram
» Increases product knowledge
» Increases competency; can solve more and
different kinds of problems
» Increases confidence
» May lead to other job opportunities within and
outside of your current organization
» “You don’t know where you’ll be working next
Monday, so pack a parachute!” -me
» SQL 2008 BI Exams
˃ Case study, my MCTS BI exam v. my MCITP BI exam
(Very challenging…my MCITP BI exam was 88 lengthy story problems, three full
hours long)
» Remember, the BI exams cover all three functional BI
areas, and test over Analysis Services disproportionately,
which is the most challenging of the three areas!
» On my website homepage there is a link called
“Strategies for Passing Certification Exams”.
» Basic Windows User Interface
Knowledge
» Basic Windows Server Operating
System Knowledge
˃
˃
˃
User and Group Accounts
Services and Service Accounts
File System and Shared Folder Permissions
» Background Relational Database
Experience
˃ (Microsoft Access experience “counts”)
» Basic Windows User Interface Knowledge
» Basic Windows Server Operating System
Knowledge
» Background Database Experience
˃ (Microsoft Access experience “counts”)
» SQL Server Administration and Possibly
Programming Experience
˃ Course 2780 or 6231
˃ Course 2779 or 6232
» Basic Query Writing Knowledge
˃ Course 2778
» Microsoft released SQL 2008 R2
(the second SQL 2008 release, also known as
version 10.5) in April 2010.
» As of yet there are no plans to release
SQL 2008 R2-specific business intelligence course
versions.
» Miscellaneous note: Microsoft offers free versions
of SQL Server and Visual Studio with smaller
feature sets. These are called Express Editions.
» Microsoft SQL Server homepage
˃
www.microsoft.com/sql
» Microsoft Learning homepage
˃
www.microsoft.com/learning
» My website
September 17, 2011
˃ Homepage
»
www.e-Squillace.com (Search button, Test taking tips link)
˃ Diagrams
»
www.e-Squillace.com/tech/techdiagrams (several SQL and SQL BI diagrams)
˃ Screenshot Gallery
»
www.e-Squillace.com/tech/screenshotgallery (look in the SQL screenshot category; a SQL BI
category exists too)
˃ SQL Server reference homepage
»
www.e-Squillace.com/tech/techreference/sql (a huuuuge amount of links)
˃ SQL Server BI reference homepage
»
www.e-Squillace.com/tech/techreference/sqlbi/sqlbi.htm (also a huuuuge amount of links)
» My Library Books (click on this link)
» List of SQL Server User Groups in the Great Lakes Region, such as…
˃ Chicago.SQLPass.org
» Learn & study?
» Download?
» Call a client with a recommendation or new opportunity?
» Flee?
» Other?
Reference:
Suggested Action Items List