DBI305: Developing Compelling Applications with Java and PHP on ...

yieldingrabbleInternet and Web Development

Dec 7, 2013 (3 years and 8 months ago)

258 views

DBI305

amisaify@microsoft.com
4


Buffered Queries with client
-
side
resultsets

& cursors


Paging results (LIMIT
-
equivalent clause)

Optimize Data Access for PHP Workloads


Enable new High Availability scenarios (
AlwaysOn

Connectivity)

Enterprise
-
class Connectivity & Performance


Enhance developer productivity with SQL Express Local Database

Improve Developer Productivity

Overview


Fetch
resultset

into client


Scrollable client
-
side cursor


Optional

Benefits


Common programming model for PHP applications


Reliable access to
RowCount

and faster scrollable cursor


Consumes results immediately and frees up server resources

Overview


Constrain
resultsets

into “pages” required by web applications


ANSI
-
syntax: OFFSET
X

ROWS FETCH FIRST
Y

ROWS ONLY


Supported by SQL Server ’Denali’


Equivalent to LIMIT/OFFSET from competing databases


Benefits


Standard programming model for PHP web applications (e.g. show top
10 news items)


Reduced memory footprint


Simpler syntax than previous SQL Server approaches

Overview


Added support for virtual network
name as the server name


Multi
-
subnet failover


Read
-
only Intent


Benefits


Allow applications to specify VNN as
server name


Disaster recovery


Read
-
only workload such as
reporting can be offloaded to
secondaries

A

A

A

A

Overview


Develop on machine with file
-
based database (no server)


Feature takes care of creating SQL instance on behalf of app

Benefits


No need to configure server


Enabled through connection string


Can deploy app and data together via file copy


Serverless

Express can also be used as production database for small deployments


Enable pure Java Kerberos integrated authentication


Provide single sign
-
on

Increase Breadth of Authentication Options


Provide high available connectivity to top tier applications (
AlwaysOn

Connectivity)


Increase scalability by enabling read scale
-
out

Enterprise
-
class Connectivity for SQL Server Developers


Provide common connectivity components across SQL and SQL Azure

Improved Connectivity to SQL Azure

Overview


Current Kerberos Integrated authentication (type
-
2) is available on Windows client only


New Kerberos Integrated authentication (type
-
4 pure Java implementation) provides multiplatform
support

Benefits


Enhanced security and provision for auditing


It does NOT fall back on NTLM


Two
-
tier Kerberos support


Three tier Kerberos support


Support Cross
-
realm


Primary focus


Windows KDC (active directory)


The driver will not take Kerberos user id and password in the connection string,


Application has to do the KDC authentication


Customers can customize the Login module by specifying a configuration file


TGT Cache,
keytab
,
etc.

15

Kerberos Service (KDC1)
[Windows]

Service Provider (SQL Server)

6. Provide ticket to use the service

7. Provide service to the user

App Server


TGT


Ticket Granting
Ticket


JVM 1.5 and 1.6


1. Credential

Client

8. Results

Windows/*Nix


Windows/*Nix

Kerberos Service (KDC2)
[Windows
/*nix]

Windows

SQL Server registered to
Windows KDC

Overview


Added support for virtual network
name as the server name


Multi
-
subnet failover


Read
-
only Intent

Benefits


Allow applications to specify VNN as
server name


Disaster recovery


Read
-
only workload such as reporting
can be offloaded to
secondaries

Connection Strings
:

Primary (1 subnet)
:
serverName
=
AG1_VNN
;
databaseName
=Db1;

Primary (2+ subnet)
:
serverName
=AG1_VNN;
databaseName
=Db1;
multiSubnetFailover
=True

Secondary
:
serverName
=N2;
databaseName
=Db1;
applicationIntent=
ReadOnly

New
DataSource

APIs

setMultiSubnetFailover
(
boolean
);

setApplicationIntent
(String);




A

A

A

A

Runtimes &

Services

Windows Azure

SDKs

Windows Azure

Tools for

Windows Azure Command
-
Line Tools for

Windows Azure

Companion

Client

Web Browser

Web Server

Windows/Tomcat/Java

SQL Server


http://sqlazuremw.codeplex.com/
http://phpazure.codeplex.com/
http://www.windowsazure4j.org/
http://wastarterkit4java.codeplex.com/
http://azurephptools.codeplex.com
http://code.msdn.microsoft.com/azurecompanion
http://www.interoperabilitybridges.com/projects/windows
-
azure
-
companion
PHP Script

SSRS SDK


for

PHP

Web Server

SOAP API

Report
Server

Web Service

SQL Connectivity Home
page:
http://
msdn.microsoft.com/en
-
us/sqlserver/ff688946


PHP Download
center:
http://
www.microsoft.com/downloads/en/details.aspx?FamilyID=80e44913
-
24b4
-
4113
-
8807
-
caae6cf2ca05

CodePlex.com:
http://www.codeplex.com/

Interoperability Bridges:
http://www.interoperabilitybridges.com/


http://
www.microsoft.com/downloads/en/details.aspx?FamilyID=ae924066
-
2946
-
40a7
-
93c6
-
c7e83f54072f&displaylang=en
Required Slide


Track PMs
will supply the
content for this slide,
which will be inserted
during the final scrub.

Try the new SQL Server Mission Critical
BareMetal

Hand’s on
-
Labs

Visit the updated website for SQL Server
®

Code Name “Denali” on
www.microsoft.com/sqlserver

and sign to be notified when the next
CTP is available

Follow
the @SQLServer Twitter account to watch for
updates

Visit the
SQL
Server Product Demo Stations in the DBI Track section of the
. Bring
your questions, ideas and
conversations!




Microsoft® SQL Server® Security & Management


Microsoft® SQL Server® Optimization and Scalability


Microsoft® SQL Server® Programmability


Microsoft® SQL Server® Data Warehousing


Microsoft® SQL Server® Mission Critical


Microsoft® SQL Server® Data Integration

www.microsoft.com/teched

www.microsoft.com/learning


http://microsoft.com/technet


http://microsoft.com/msdn


http://northamerica.msteched.com