Microsoft SQL Server includes a complete set of graphical tools and command line utilities that allow users, programmers, and administrators to increase their productivity. The step-by-step tutorials listed below, help you learn to get the most out of SQL Server tools so you can work efficiently, right from the start. The following table describes the topics in this section. Click a link to start a tutorial.
This tutorial is for users who are new to SQL Server. The tutorial reviews the basic tools, shows you how to start the Database Engine, and describes how to connect to the Database Engine on the same computer and also from another computer.
Take this tutorial to review how SQL Server Management Studio provides a rich and flexible work surface. Learn to configure the SQL Server Management Studio to support the way you work. Learn how to get more space on the desktop, how to use the great new features of the SQL Editor, manage script projects, and more. This tutorial is suitable for anyone who has not worked extensively in the Microsoft Visual Studio environment.
Shows you how to use the hierarchyid data type to expresses a hierarchy. This tutorial creates a new hierarchy from start to finish, and also shows how to convert from a table that used a self-join to maintain a hierarchy.
Take this tutorial to learn how you can use ownership chains and context switching to manage the security context of stored procedures. Then users without direct access to database objects, such as tables or views, can access those objects through applications that use these stored procedures.
This tutorial illustrates signing stored procedures using a certificate generated by SQL Server. This is is useful when you want to require permissions on the stored procedure but you do not want to explicitly grant a user those rights. It is particularly useful when auditing Data Definition Language (DDL) operations.