Docstoc

Sql 2012 development and programming

Document Sample
Sql 2012  development and programming Powered By Docstoc
					SQL 2012:
Development & 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.     Copyright © by Application Developers Training Company
                                        All 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.     Copyright © by Application Developers Training Company
                                        All 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 attributes
      • The magic: files exposed through a file share

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


                                    Learn More @ http://www.learnnowonline.com
Copyright 2012, AppDev Products, LLC.     Copyright © by Application Developers Training Company
                                        All Rights Reserved.
  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.     Copyright © by Application Developers Training Company
                                        All 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 file

                                    Learn More @ http://www.learnnowonline.com
Copyright 2012, AppDev Products, LLC.     Copyright © by Application Developers Training Company
                                        All 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.     Copyright © by Application Developers Training Company
                                        All 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 editing in the T-SQL Editor



                                    Learn More @ http://www.learnnowonline.com
Copyright 2012, AppDev Products, LLC.     Copyright © by Application Developers Training Company
                                        All Rights Reserved.
  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.     Copyright © by Application Developers Training Company
                                        All Rights Reserved.
  Using SQL Server Data Tools
      • Two ways
             • Connected
             • Disconnected




                                    Learn More @ http://www.learnnowonline.com
Copyright 2012, AppDev Products, LLC.     Copyright © by Application Developers Training Company
                                        All Rights Reserved.
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

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:4
posted:10/4/2012
language:English
pages:12
Description: Miscellaneous Development & Programming Changes within SQL Server 2012.