overview of code coverage & code analysis€¦ · •enhanced windows server 2012 integration...

SQL Server 2014Programming

[PART-1]

[ Level-100 Webinar]

Meganadha Reddy K.

Technical Trainer

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Agenda

• Web Applications Introduction

• Database Objects

• OLTP and OLAP

• SQL Server History

• New Features of SQL Server 2014

• Q & A

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

How web applications work?

Application

Server

Database

HTML, CSS etc., for UI

Java / C# / VB or any programming

language for Business Logic

Oracle / SQL Server etc.,

for Database

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Database Software

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Database

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Tables

Views Columns

Constraints

Functions

Stored Procedures

Triggers

Joins

SysTables

Logins

indexes

Transactions

Backups

Data Warehouse (1 of 2)

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

OLTP vs. OLAP

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

SQL Server – History[Major /Intermediate Releases]

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

SQL Server 6.0

SQL Server 7.0

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

1995

2005 – Major Release

Included:

ETL Tool – SSIS

Reporting Server

OLAP and Data Mining Server - SSAS

SQL Server - Editions

SQL SERVER

Express Edition Standard Edition Enterprise Edition

Three more types:

a. Express with Tools

b. Express with Advanced Services.

c. Engine + Management Studio Compact Edition

SQL Server 2014 – New Features

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

• In-Memory OLTP Engine

• Enhanced Windows Server 2012 Integration

• Enhancements to Always On Availability Groups

• Enhancements to Backups

• Updateable Columnstore Indexes

• SQL Server Data Tools for Business Intelligence

• Power BI for Office 365 Integration

In-Memory OLTP Engine

• Big performance improvements for OLTP Applications.

• Moves select tables and stored procedures to memory Improvement in performance in OLTP Applications.

• Designed for high concurrency and uses a new optimistic concurrency control mechanism to eliminate locking delays.

• Stored Procedures performance is improved by compiling the SPs into native code DLLs.

• AMR tool – Analysis, Migrate and Report

Case Study:

Edgenet company saw 7x performance increase in its online and retail supply application by upgrading to SQL Server 2014

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Enhancements to Backups

• It now supports built-in database encryption.

• Previous releases all required a third party product to encrypt database

backups.

• Windows Azure integration to SQL Server’s backup capabilities. i.e., you can

specify a Windows Azure URL as target for your SQL Server 2014 database

backups.

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

SQL Server - Evolution

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/

Q & A

?

© Meganadha Reddy K., 2014 http://www.netcomlearning.com/