|
|
-
In the last and final part of the series, we look at ways to troubleshoot the SSMS in case things go wrong - if the Object Explorer is not visible, or if the T-SQL Debugger does not work....
|
-
In addition to the tools and utilities available within the SSMS, there are other peripheral tools & utilities that work in tandem with SQL Server to help you develop T-SQL code, manage & maintain the SQL Server instance. This tutorial explores how the SSMS integrates with the SQL Server Agent, SQL Server Profiler and the Database Tuning Advisor....
|
-
One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. Most novice DBAs are nervous when it comes to using T-SQL Scripts to modify the SQL Server instance configuration. This tutorial takes a look at the server & database properties window that help you in the configuration tasks. It also shows how to script out any changes made for future reference....
|
-
Moving on to more serious DBA business, the copy and script database wizard have proven useful in generating copies of a database for troubleshooting of other purposes. This tutorial explores how to use these wizards and tweak scripting and copy options to match your requirement. ...
|
-
The "Properties" window contains a range of detailed diagnostic information about queries that help both administrators and developers alike in knowing what query options were used as part of query execution, which operators were involved and how a particular operation executed. The Properties window provides the most basic set of information useful during performance tuning....
|
-
There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels and allow one to perform basic SQL Server development without writing a single line of T-SQL code. Some such designers are the table designer, Scripting engine, Query Designer and Template Explorer. This is a L100 tutorial....
|
-
The SSMS can also help you generate database relationship diagrams which are a repository of the relationships between the various database objects. Database object relationships are typically described using a graphical representation of the tables, columns, keys, indexes, relationships, and constraints. An object can appear in any number of diagrams. This tutorial walks you through the steps necessary to create your first database diagram using the Diagram designer....
|
-
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. This part unleashes the most powerful, yet underappreciated debugging feature of them all - the T-SQL Debugger, including some of the enhancements made in SSMS for SQL Server 2012 like conditional breakpoints, labels and data tips....
|
-
After learning about the basic anatomy of SSMS in Part 01 of this tutorial, we now take a deep dive into the Object Explorer and Object Explorer Details windows and how thy are useful for day-to-day activities like object search for impact analysis and inventory preparation, database properties summaries/dashboard and advanced scripting capabilities....
|
-
The SQL Server Management Studio (SSMS) is a very powerful IDE and one of the most used tools by any SQL Server professional. This part of the tutorial explains the anatomy of the available editors, associated colour coding, it's toolbars and menus. We also touch upon revolutionary features like Intellisense, Error List, multi-monitor support and query regions...
|