LearnNowOnline, profile picture
Uploaded byLearnNowOnline
KEY, PPTX919 views

Sql 2012 development and programming

The document discusses new features in SQL Server 2012 including the removal of native XML web services, enhancements to full-text search such as searching document properties and customizable NEAR search, statistical semantic search that builds on full-text search to allow querying the meaning of documents, and FileTables which allow storing file and directory hierarchies in SQL Server tables using both Windows file APIs and T-SQL.

Download as KEY, PPTX
SQL 2012: Development & Programming Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Miscellaneous Development & Programming Changes Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Miscellaneous Development & Programming Changes • No more native XML Web services Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists • Customizable NEAR search option Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists • Customizable NEAR search option • New word breakers and stemmers Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document • Semantic search lets you query the meaning Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document • Semantic search lets you query the meaning • Semantic search and FileTables were made for each other Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables • Windows file management meets SQL Server document storage Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema • Stores FILESTREAM data Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema • Stores FILESTREAM data • Stores file and directory hierarchy and Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access • Specify a directory for FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access • Specify a directory for FileTables • Limitation Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express • A new version of SQL Express for developers Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express • A new version of SQL Express for developers • Easy to install Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express • No longer need to install SQL Express for development Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server 2012 Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express • No longer need to install SQL Express for development • Can use as an embedded database Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string • "Data Source=(localdb)v11.0;Integrated Security=true" Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string • "Data Source=(localdb)v11.0;Integrated Security=true" • Use AttachDbFileName for local database Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact • The two sound similar Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact • The two sound similar • But there are differences Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact • The two sound similar • But there are differences • Execution mode Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact • The two sound similar • But there are differences • Execution mode • Disk usage Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Comparison to SQL Server Compact • The two sound similar • But there are differences • Execution mode • Disk usage • Features Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools • Latest of a long line of attempts to make creating databases like writing software Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured • If you use Visual Studio, you’ll feel right at home Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
SQL Server Data Tools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured • If you use Visual Studio, you’ll feel right at home • Code navigation, IntelliSense, language support similar to C# and VB, platform- specific validation, debugging and declarative Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project • Platform Web installer Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Installing SQL Server Data • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project • Platform Web installer • Administrative installation point Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using SQL Server Data Tools Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using SQL Server Data Tools • Two ways Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using SQL Server Data Tools • Two ways • Connected Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Using SQL Server Data Tools • Two ways • Connected • Disconnected Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
Learn More! Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
Learn More! • This is an excerpt from a larger course. Visit www.learnnowonline.com for the full details! Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company

More Related Content

PDF
Con3429 pdf 3429_0001
byjuancaJdev
 
PPT
Top 10 Ways To Integrate With Oracle Enterprise Content Management (ECM)
byBrian Huff
 
PPT
Creating and Maintaining An Internationalized Website
byBrian Huff
 
PPT
WebCenter Content & Portal Methodology Deep Dive with Case Studies
byBrian Huff
 
PDF
Oracle ADF Architecture TV - Design - ADF Service Architectures
byChris Muir
 
PDF
TAUS OPEN SOURCE MACHINE TRANSLATION SHOWCASE, Beijing, Yu Gong, Adobe, 23 Ap...
byTAUS - The Language Data Network
 
PPT
Deep Dive: Oracle WebCenter Content Tips and Traps!
byBrian Huff
 
PPTX
Social Media - Why a Database Person Should Care
byJeff Smith
 
Con3429 pdf 3429_0001
byjuancaJdev
 
Top 10 Ways To Integrate With Oracle Enterprise Content Management (ECM)
byBrian Huff
 
Creating and Maintaining An Internationalized Website
byBrian Huff
 
WebCenter Content & Portal Methodology Deep Dive with Case Studies
byBrian Huff
 
Oracle ADF Architecture TV - Design - ADF Service Architectures
byChris Muir
 
TAUS OPEN SOURCE MACHINE TRANSLATION SHOWCASE, Beijing, Yu Gong, Adobe, 23 Ap...
byTAUS - The Language Data Network
 
Deep Dive: Oracle WebCenter Content Tips and Traps!
byBrian Huff
 
Social Media - Why a Database Person Should Care
byJeff Smith
 

What's hot

PDF
Oracle ADF Architecture TV - Design - Designing for Security
byChris Muir
 
PPTX
Designing SharePoint solutions – Big Decisions for Big Success
bySPC Adriatics
 
PPTX
Responsive Web Design ~ Best Practices for Maximizing ROI
byJuan Carlos Duron
 
PPT
Oracle web-applications
byurskeshav
 
PDF
20100604 unyoug apex40_bauser
byahmed farouk
 
KEY
WordPress Filters and Actions
byGlenn Ansley
 
PPT
Exploiting Linked (Open) Data via Microsoft Access
byKingsley Uyi Idehen
 
PDF
Designing your API Server for mobile apps
byMugunth Kumar
 
PPT
Using SAP Crystal Reports as a Linked (Open) Data Front-End via ODBC
byKingsley Uyi Idehen
 
PDF
Oracle ADF Architecture TV - Development - Naming Conventions & Project Layouts
byChris Muir
 
PPT
Exploiting Linked Data via Filemaker
byKingsley Uyi Idehen
 
PPT
Tableau Desktop as a Linked (Open) Data Front-End via ODBC
byKingsley Uyi Idehen
 
PPTX
WebCenter Content 11g Upgrade Webinar - March 2013
byFishbowl Solutions
 
PPTX
SharePoint 2010 Online for Developer
byK.Mohamed Faizal
 
PPT
Oracle Application Express
byHBoone
 
PDF
Oracle ADF Architecture TV - Development - Programming Best Practices
byChris Muir
 
PDF
Moving to Web 2.0 - Best Practices for Business and Application Migration
byanilmadugula
 
PDF
Interactive Forms Review - SDN Day 2008 - Las Vegas
bydr.j
 
DOC
Thomas_Rock_Resume_50B
byThomas Rock
 
PDF
Business Applications Integration In The Cloud
byAnna Brzezińska
 
Oracle ADF Architecture TV - Design - Designing for Security
byChris Muir
 
Designing SharePoint solutions – Big Decisions for Big Success
bySPC Adriatics
 
Responsive Web Design ~ Best Practices for Maximizing ROI
byJuan Carlos Duron
 
Oracle web-applications
byurskeshav
 
20100604 unyoug apex40_bauser
byahmed farouk
 
WordPress Filters and Actions
byGlenn Ansley
 
Exploiting Linked (Open) Data via Microsoft Access
byKingsley Uyi Idehen
 
Designing your API Server for mobile apps
byMugunth Kumar
 
Using SAP Crystal Reports as a Linked (Open) Data Front-End via ODBC
byKingsley Uyi Idehen
 
Oracle ADF Architecture TV - Development - Naming Conventions & Project Layouts
byChris Muir
 
Exploiting Linked Data via Filemaker
byKingsley Uyi Idehen
 
Tableau Desktop as a Linked (Open) Data Front-End via ODBC
byKingsley Uyi Idehen
 
WebCenter Content 11g Upgrade Webinar - March 2013
byFishbowl Solutions
 
SharePoint 2010 Online for Developer
byK.Mohamed Faizal
 
Oracle Application Express
byHBoone
 
Oracle ADF Architecture TV - Development - Programming Best Practices
byChris Muir
 
Moving to Web 2.0 - Best Practices for Business and Application Migration
byanilmadugula
 
Interactive Forms Review - SDN Day 2008 - Las Vegas
bydr.j
 
Thomas_Rock_Resume_50B
byThomas Rock
 
Business Applications Integration In The Cloud
byAnna Brzezińska
 

Viewers also liked

PDF
Sql Saturday 111 Atlanta applied enterprise semantic mining
byMark Tabladillo
 
PDF
Secrets of Enterprise Data Mining 201310
byMark Tabladillo
 
PPTX
FileTable and Semantic Search in SQL Server 2012
byMichael Rys
 
PDF
72
byguest542ac0
 
PDF
SQL Sever 2012: Going Beyond the Data
byJennifer Stevenson
 
PPTX
Understanding indices
byRichard Douglas
 
PDF
Applied Semantic Search with Microsoft SQL Server
byMark Tabladillo
 
PPTX
SQL Server - Full text search
byPeter Gfader
 
PDF
インフラ屋の友:Tera Term
bynetopscoding
 
PDF
Gns3
byBahaa Aladdin
 
PPT
Effective Usage of SQL Server 2005 Database Mirroring
bywebhostingguy
 
PDF
Programming in c++
byChristalin Nelson
 
PDF
SQL Server Performance Tuning Baseline
by► Supreme Mandal ◄
 
PPT
Sql Server Performance Tuning
byBala Subra
 
PDF
SQL Server - Querying and Managing XML Data
byMarek Maśko
 
PPT
Cisco Packet Tracer Overview 20 Jul09
byTumennast Erdenebold
 
PPTX
Always on in SQL Server 2012
byFadi Abdulwahab
 
PPT
C#/.NET Little Wonders
byBlackRabbitCoder
 
PPT
File Upload
bywebhostingguy
 
PPTX
What's new in SQL Server 2016
byJames Serra
 
Sql Saturday 111 Atlanta applied enterprise semantic mining
byMark Tabladillo
 
Secrets of Enterprise Data Mining 201310
byMark Tabladillo
 
FileTable and Semantic Search in SQL Server 2012
byMichael Rys
 
72
byguest542ac0
 
SQL Sever 2012: Going Beyond the Data
byJennifer Stevenson
 
Understanding indices
byRichard Douglas
 
Applied Semantic Search with Microsoft SQL Server
byMark Tabladillo
 
SQL Server - Full text search
byPeter Gfader
 
インフラ屋の友:Tera Term
bynetopscoding
 
Gns3
byBahaa Aladdin
 
Effective Usage of SQL Server 2005 Database Mirroring
bywebhostingguy
 
Programming in c++
byChristalin Nelson
 
SQL Server Performance Tuning Baseline
by► Supreme Mandal ◄
 
Sql Server Performance Tuning
byBala Subra
 
SQL Server - Querying and Managing XML Data
byMarek Maśko
 
Cisco Packet Tracer Overview 20 Jul09
byTumennast Erdenebold
 
Always on in SQL Server 2012
byFadi Abdulwahab
 
C#/.NET Little Wonders
byBlackRabbitCoder
 
File Upload
bywebhostingguy
 
What's new in SQL Server 2016
byJames Serra
 

Similar to Sql 2012 development and programming

PDF
Sql server common interview questions and answers page 6
byKaing Menglieng
 
PDF
Sql Performance Tuning For Developers
bysqlserver.co.il
 
PDF
DB2 Web Query whats new
byCOMMON Europe
 
PDF
Session 2: SQL Server 2012 with Christian Malbeuf
byCTE Solutions Inc.
 
PPTX
Performance By Design
byGuy Harrison
 
PPTX
SQL Server 2012 Best Practices
byMicrosoft TechNet - Belgium and Luxembourg
 
PDF
Sql server common interview questions and answers page 5
byKaing Menglieng
 
PPTX
The Microsoft BigData Story
byLynn Langit
 
PPTX
SSDT Workshop @ SQL Bits X (2012-03-29)
byGert Drapers
 
KEY
A tour of SQL Server
byLearnNowOnline
 
PDF
My Article on MySQL Magazine
byJonathan Levin
 
PDF
Bb world 2012 using database statistics to make capacity planning decisions...
byGeoff Mower
 
PPTX
Sql killedserver
byColdFusionConference
 
PPTX
My SQL Skills Killed the Server
bydevObjective
 
PPTX
Bb world 2011 capacity planning
bySteve Feldman
 
PDF
Speed up sql server apps - visual studio magazine
byKaing Menglieng
 
PDF
10g sql e book
byMansoor Abd Algadir
 
PDF
Sql server common interview questions and answers
byKaing Menglieng
 
PPTX
Pass bac jd_sm
byJoseph D'Antoni
 
PPTX
Sql server infernals
byGianluca Sartori
 
Sql server common interview questions and answers page 6
byKaing Menglieng
 
Sql Performance Tuning For Developers
bysqlserver.co.il
 
DB2 Web Query whats new
byCOMMON Europe
 
Session 2: SQL Server 2012 with Christian Malbeuf
byCTE Solutions Inc.
 
Performance By Design
byGuy Harrison
 
SQL Server 2012 Best Practices
byMicrosoft TechNet - Belgium and Luxembourg
 
Sql server common interview questions and answers page 5
byKaing Menglieng
 
The Microsoft BigData Story
byLynn Langit
 
SSDT Workshop @ SQL Bits X (2012-03-29)
byGert Drapers
 
A tour of SQL Server
byLearnNowOnline
 
My Article on MySQL Magazine
byJonathan Levin
 
Bb world 2012 using database statistics to make capacity planning decisions...
byGeoff Mower
 
Sql killedserver
byColdFusionConference
 
My SQL Skills Killed the Server
bydevObjective
 
Bb world 2011 capacity planning
bySteve Feldman
 
Speed up sql server apps - visual studio magazine
byKaing Menglieng
 
10g sql e book
byMansoor Abd Algadir
 
Sql server common interview questions and answers
byKaing Menglieng
 
Pass bac jd_sm
byJoseph D'Antoni
 
Sql server infernals
byGianluca Sartori
 

More from LearnNowOnline

PPT
Windows 8: Shapes and Geometries
byLearnNowOnline
 
PPT
SQL: Permissions and Data Protection
byLearnNowOnline
 
PPT
New in the Visual Studio 2012 IDE
byLearnNowOnline
 
KEY
Attributes, reflection, and dynamic programming
byLearnNowOnline
 
KEY
Asynchronous Programming
byLearnNowOnline
 
KEY
WPF: Working with Data
byLearnNowOnline
 
KEY
WPF Binding
byLearnNowOnline
 
KEY
Introducing LINQ
byLearnNowOnline
 
KEY
Generics
byLearnNowOnline
 
KEY
Object oriented techniques
byLearnNowOnline
 
KEY
Object-Oriented JavaScript
byLearnNowOnline
 
KEY
SharePoint Document Management
byLearnNowOnline
 
KEY
SharePoint: Introduction to InfoPath
byLearnNowOnline
 
KEY
Managing site collections
byLearnNowOnline
 
KEY
Web API HTTP Pipeline
byLearnNowOnline
 
KEY
Web API Basics
byLearnNowOnline
 
KEY
SQL Server: Security
byLearnNowOnline
 
KEY
What's new in Silverlight 5
byLearnNowOnline
 
KEY
KnockOutJS with ASP.NET MVC
byLearnNowOnline
 
KEY
Expression Blend Motion & Interaction Design
byLearnNowOnline
 
Windows 8: Shapes and Geometries
byLearnNowOnline
 
SQL: Permissions and Data Protection
byLearnNowOnline
 
New in the Visual Studio 2012 IDE
byLearnNowOnline
 
Attributes, reflection, and dynamic programming
byLearnNowOnline
 
Asynchronous Programming
byLearnNowOnline
 
WPF: Working with Data
byLearnNowOnline
 
WPF Binding
byLearnNowOnline
 
Introducing LINQ
byLearnNowOnline
 
Generics
byLearnNowOnline
 
Object oriented techniques
byLearnNowOnline
 
Object-Oriented JavaScript
byLearnNowOnline
 
SharePoint Document Management
byLearnNowOnline
 
SharePoint: Introduction to InfoPath
byLearnNowOnline
 
Managing site collections
byLearnNowOnline
 
Web API HTTP Pipeline
byLearnNowOnline
 
Web API Basics
byLearnNowOnline
 
SQL Server: Security
byLearnNowOnline
 
What's new in Silverlight 5
byLearnNowOnline
 
KnockOutJS with ASP.NET MVC
byLearnNowOnline
 
Expression Blend Motion & Interaction Design
byLearnNowOnline
 

Sql 2012 development and programming

  • 1.
    SQL 2012: Development & Programming Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
  • 2.
    Miscellaneous Development & Programming Changes Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 3.
    Miscellaneous Development & Programming Changes • No more native XML Web services Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 4.
    Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 5.
    Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 6.
    Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists • Customizable NEAR search option Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 7.
    Miscellaneous Development & Programming Changes • No more native XML Web services • Full-Text Search enhancements • Search document properties with Search Property Lists • Customizable NEAR search option • New word breakers and stemmers Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 8.
    Statistical Semantic Search Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 9.
    Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 10.
    Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 11.
    Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 12.
    Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document • Semantic search lets you query the meaning Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 13.
    Statistical Semantic Search • Deep insight into unstructured documents stored in SQL Server • Builds on full-text search • Query the words in a document • Semantic search lets you query the meaning • Semantic search and FileTables were made for each other Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 14.
    FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 15.
    FileTables • Windows file management meets SQL Server document storage Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 16.
    FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 17.
    FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 18.
    FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema • Stores FILESTREAM data Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 19.
    FileTables • Windows file management meets SQL Server document storage • Compatible with both the Windows file access APIs and relational data access through T-SQL • A FileTable is a database table with set schema • Stores FILESTREAM data • Stores file and directory hierarchy and Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 20.
    Using FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 21.
    Using FileTables • Enable prerequisites Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 22.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 23.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 24.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 25.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 26.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access • Specify a directory for FileTables Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 27.
    Using FileTables • Enable prerequisites • Enable FILESTREAM for the SQL Server instance • For the database: • Provide a FILESTREAM file group • Optionally enable non-transaction access • Specify a directory for FileTables • Limitation Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 28.
    SQL Server 2012Express Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 29.
    SQL Server 2012Express • A new version of SQL Express for developers Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 30.
    SQL Server 2012Express • A new version of SQL Express for developers • Easy to install Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 31.
    SQL Server 2012Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 32.
    SQL Server 2012Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express • No longer need to install SQL Express for development Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 33.
    SQL Server 2012Express • A new version of SQL Express for developers • Easy to install • Provides full features of SQL Express • No longer need to install SQL Express for development • Can use as an embedded database Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 34.
    Overview of LocalDB Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 35.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 36.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 37.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 38.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 39.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string • "Data Source=(localdb)v11.0;Integrated Security=true" Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 40.
    Overview of LocalDB • Uses the same sqlserver.exe as SQL Express and other editions • Install once per machine • Doesn’t create or use database services • Connection string • "Data Source=(localdb)v11.0;Integrated Security=true" • Use AttachDbFileName for local database Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 41.
    Comparison to SQLServer Compact Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 42.
    Comparison to SQLServer Compact • The two sound similar Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 43.
    Comparison to SQLServer Compact • The two sound similar • But there are differences Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 44.
    Comparison to SQLServer Compact • The two sound similar • But there are differences • Execution mode Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 45.
    Comparison to SQLServer Compact • The two sound similar • But there are differences • Execution mode • Disk usage Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 46.
    Comparison to SQLServer Compact • The two sound similar • But there are differences • Execution mode • Disk usage • Features Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 47.
    SQL Server DataTools Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 48.
    SQL Server DataTools • Latest of a long line of attempts to make creating databases like writing software Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 49.
    SQL Server DataTools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 50.
    SQL Server DataTools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 51.
    SQL Server DataTools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured • If you use Visual Studio, you’ll feel right at home Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 52.
    SQL Server DataTools • Latest of a long line of attempts to make creating databases like writing software • And this time Microsoft nailed it! • Data Dude has come of age and matured • If you use Visual Studio, you’ll feel right at home • Code navigation, IntelliSense, language support similar to C# and VB, platform- specific validation, debugging and declarative Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 53.
    Installing SQL ServerData Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 54.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 55.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 56.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 57.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 58.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project • Platform Web installer Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 59.
    Installing SQL ServerData • System Requirements: same as Visual Studio 2010 SP1 • Ways to install: • As part of SQL Server 2012 installation • When creating a Visual Studio 2010 project • Platform Web installer • Administrative installation point Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 60.
    Using SQL ServerData Tools Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 61.
    Using SQL ServerData Tools • Two ways Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 62.
    Using SQL ServerData Tools • Two ways • Connected Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 63.
    Using SQL ServerData Tools • Two ways • Connected • Disconnected Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC. AllCopyright © by Application Developers Training Company Rights Reserved.
  • 64.
    Learn More! Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company
  • 65.
    Learn More! • Thisis an excerpt from a larger course. Visit www.learnnowonline.com for the full details! Learn More @ http://www.learnnowonline.com Copyright © by Application Developers Training Company

Editor's Notes