Sql 2012 development and programming

SQL 2012: Development & Programming Programming

Learn More @ http://www.learnnowonline.com Copyright Š by Application Developers Training Company

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 Rights Reserved. © by Application Developers Training Company

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 Rights Reserved. © by Application Developers Training Company

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 attributes

• The magic: files exposed through a file share Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC.

AllCopyright Rights Reserved. © by Application Developers Training Company

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 • Doesn’t support memory-mapped files Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC.

AllCopyright Rights Reserved. © by Application Developers Training Company

SQL Server 2012 Express LocalDB • 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 Rights Reserved. © by Application Developers Training Company

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 file Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC.

AllCopyright Rights Reserved. © by Application Developers Training Company

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 Rights Reserved. © by Application Developers Training Company

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 editing in the T-SQL Editor

Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC.

AllCopyright Rights Reserved. © by Application Developers Training Company

Installing SQL Server Data Tools • 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 Rights Reserved. © by Application Developers Training Company

Using SQL Server Data Tools • Two ways • Connected • Disconnected

Learn More @ http://www.learnnowonline.com Copyright 2012, AppDev Products, LLC.

AllCopyright Rights Reserved. © 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