Start learning with our library of video tutorials taught by experts. Get started

SQL Server 2012 New Features
Illustration by John Hersey

SQL Server 2012 New Features

with Martin Guidry

Video: Welcome

Hi! I am Martin Guidry! And welcome to SQL Server 2012 New Features. In this course, we'll look at numerous innovative features Microsoft added to its latest release of SQL Server. I'll start by showing you how to search and manipulate files using the new file tables. We'll write efficient code that pages through data, and handles errors elegantly. Then, I'll show you how to use SQL Server Management Studio to debug your queries more effectively by setting breakpoints, using the Watch windows, and understanding the improvements to IntelliSense.
Expand all | Collapse all
  1. 2m 0s
    1. Welcome
      55s
    2. What you should know
      35s
    3. Using the exercise files
      30s
  2. 7m 40s
    1. Finding and downloading SQL Server 2012 Express edition
      1m 52s
    2. Setting up the SQL Server 2012 Express edition environment
      5m 48s
  3. 28m 20s
    1. Using FileTables to enhance FileStream
      8m 38s
    2. Exploring the new semantic search for unstructured data
      10m 4s
    3. Exploring enhancements to full text search
      2m 16s
    4. Implementing ad-hoc paging with offset and fetch
      2m 57s
    5. Using the new throw statement to enhance try-catch blocks
      4m 25s
  4. 12m 50s
    1. Using breakpoint condition, breakpoint hit count, breakpoint filter, and breakpoint action
      5m 23s
    2. Exploring the Watch, Quick Watch, and Quick Info windows
      3m 8s
    3. Reviewing Transact-SQL IntelliSense improvements
      4m 19s
  5. 12m 24s
    1. Understanding changes to user passwords and logins
      5m 37s
    2. Creating user-defined server roles
      2m 21s
    3. Understanding auditing
      4m 26s
  6. 7m 23s
    1. Exploring AlwaysOn
      5m 6s
    2. Examining changes to replication
      2m 17s
  7. 12m 56s
    1. Choosing an edition
      4m 53s
    2. Licensing SQL Server 2012 in a non-virtual environment
      5m 19s
    3. Licensing SQL Server 2012 in a virtual environment
      2m 44s
  8. 24m 38s
    1. Introducing new conversion, logical, and string functions
      7m 9s
    2. Understanding changes to hardware and operating system support
      3m 26s
    3. Exploring new types of indexes and new options on indexes
      5m 10s
    4. Understanding new administrative options
      6m 12s
    5. Accommodating changes to database structure
      2m 41s
  9. 2m 1s
    1. Goodbye
      2m 1s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
SQL Server 2012 New Features
1h 50m Intermediate Nov 16, 2012

Viewers: in countries Watching now:

SQL Server 2012 is the first cloud-ready information platform for Microsoft. In this course, author Martin Guidry explores its new possibilities, showing you how to protect, unlock, and scale the power of your data, and work with a variety of devices and data sources. The course also provides an overview on obtaining, installing, and running SQL Server 2012 and will be of immense interest to anyone considering upgrading or installing this latest edition.

Topics include:
  • Choosing an edition
  • Finding and downloading SQL Server 2012
  • Using FileTables to enhance FileStream
  • Searching unstructured data semantically
  • Searching text
  • Exploring the Watch, Quick Watch, and Quick Info windows
  • Creating user-defined server roles
  • Understanding the changes to replication
  • Exploring new types of indexes and new options on indexes
  • Accommodating changes to database structure
Subjects:
Developer Servers Databases IT
Software:
SQL Server
Author:
Martin Guidry

Welcome

Hi! I am Martin Guidry! And welcome to SQL Server 2012 New Features. In this course, we'll look at numerous innovative features Microsoft added to its latest release of SQL Server. I'll start by showing you how to search and manipulate files using the new file tables. We'll write efficient code that pages through data, and handles errors elegantly. Then, I'll show you how to use SQL Server Management Studio to debug your queries more effectively by setting breakpoints, using the Watch windows, and understanding the improvements to IntelliSense.

We'll see how to store user passwords at the database level instead of the server level. We'll cover all these features along with some other tools and techniques and we'll try to have a little fun along the way too. Now let's get started with SQL Server 2012 New Features.

There are currently no FAQs about SQL Server 2012 New Features.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed SQL Server 2012 New Features.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.