SQL Server Object Explorer main interface is focused on showing available SQL Server instances. This video looks at what default servers are shown in the main screen. Learn how to use the Add SQL Server button to explore Azure, the local network and the local machine for additional SQL Server instances.
- [Voiceover] Before I do any changes…to the SQL Server Object Explorer,…I like to put it back in its normal default docked position.…To do that, I right click on the tab up here,…and choose Dock.…Change the width of the window…to make sure I can see everything.…I want to talk about this SQL Server node.…This is where all of my current connections…that I have available…for SQL Server Object Explorer is stored.…You see I have four items in here right now at the top,…these are my local DB, or my named instances for local DB,…and I also have one down here.…
To add new SQL Server items to this list,…I can click on this plus button up here.…This dialog shows the three separate areas I can look,…on my local machine, on the computer network, and in Azure.…If I click on Local, I can see…my available local named instances for SQL Server 2016.…Let's say that one of these is not available,…I'll show you how to add it.…Cancel here,…I'll right click on this and choose Disconnect,…so it's removed from SQL Server Object Explorer.…
- 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.