This tutorial looks at the SqlLocalDB.exe utility and how it is used to work with LocalDB instances. It explores the version switch, which shows what version of LocalDB are available on the computer. There is also a section that looks at the available instance names and explains esoteric naming conventions.
- [Voiceover] LocalDB uses a feature of SQL Server…called named instances.…Since we'll be seeing it throughout the course,…now is a good time to review what makes a named instance…and how it affects connecting to databases.…In a default install of SQL Server…during the configuration stage…you specify a name for the SQL instance.…By default, there is no name indicated,…that is known as the default instance.…Essentially it is identified by the server name.…Additional instances can be installed on the same computer.…Each additional instance must have a unique name.…
These are the named instances.…That means there is one default instance…and many named instances per computer.…Here's an example.…I have a server set up…with a default instance of SQL Server.…The server is named Maple.…An instance of SQL Server can host many databases.…In this example, I've got two databases…hosted in the Default Instance.…One named Tours and the other named Academy.…To connect to a database,…I need to configure a connection string.…In this example, I'll look at a subset…
- Exploring integration with Azure data sources and other Microsoft databases
- Working with SQL Server Express LocalDB
- Connecting to databases with Server Explorer
- Working with database tables
- Manipulating tables with the SQL Server Object Explorer
- Creating queries and custom views
- Creating stored procedures
- Comparing databases
- Building a data project in Visual Studio
- Refactoring a database object
- Deploying the database
- Connecting to Azure databases
- Deploying data projects to Azure
- Integrating Visual Studio with Entity Framework
Skill Level Beginner
Q: This course was updated on 08/23/2017. What changed?
A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- Mark as unwatched
- Mark all as unwatched
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.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.