Chapters



SQL Server 2012 – Ch.03:B – Understanding SQL Server System Databases

Aug
29
2013
  Posted by  
  Previous part introduced you to Data, Database, a Database Management System and the various objects in a SQL Server Database. Every instance of SQL Server installation comes pre-installed with a set of databases known as System Databases. In this chapter I will cover these system databases.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.03:A – Introducing SQL Server Database

Aug
27
2013
  Posted by  
  Now that you have installed SQL Server and also have the knowledge of tools that you will be using, it’s time to get into to the actual work that is of designing the databases. However, it’s better to know what you mean by data, what is a database, and a database management system (DBMS) is before even getting into designing them.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.02:F – Introducing Query Designer (SSMS 2012)

Aug
23
2013
  Posted by  
  In the previous part of this chapter, you were introduced to Query Editor, where you saw how easy it was to write queries. However, if you want to write queries, you need to have some knowledge of SQL language. For those users who do not know anything about the SQL language, but still would like to create some simple queries, SQL Server Management Studio provides the Query Designer. In this part, I will introduce you to Query Designer.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.02:E – Query Editor (SSMS 2012)

Aug
20
2013
  Posted by  
  In SQL Server Management Studio, creating objects, manipulating the data, executing code and other such activities can performed either by using the graphical interface and options that Object Explorer provides, or by writing & executing T-SQL code. To write code, SSMS provides us the Query Editor, which is specifically designed for writing Transact-SQL code. This part covers the Query Editor which is a tabbed entry window occupying the document window area of SQL Server Management studio, where we can write the code, execute, and also debug it.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.02:D – Registered Servers and Central Management Servers (SSMS 2012)

Aug
12
2013
  Posted by  
  Like the Object Explorer, Registered Servers Explorer is an important tool that needs some mention here. In this chapter, I will be covering Registered Servers Explorer and will also show you how you can use it.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTips & Tricks categoryTutorial



SQL Server 2012 – Ch.02:C – Understanding Object Explorer in SSMS 2012

Aug
12
2013
  Posted by  
  In the previous part, we covered the process of connecting to a SQL Server instance using SSMS. Now that we have successfully logged in are in SSMS, let us Explore it further. In this part, I will cover the Object Explorer & Object Explorer Details page.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.02:B – Connecting to SQL Server 2012

Aug
07
2013
  Posted by  
 

In the previous part of this chapter, I introduced you to SQL Server Management Studio 2012 and its various windows and panes. For the rest of this chapter, I will show you how these various panes and windows work together to present a design surface to make your work easier in using SSMS 2012. This part covers connecting to SQL Server 2012 using SSMS 2012.


[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.02:A – Introducing SQL Server Management Studio 2012 (SSMS)

Aug
06
2013
  Posted by  
  Now that SQL Server 2012 is successfully installed on your machine, I will introduce you to various SQL Server 2012 Tools that make this an easy and effective product to use. With SQL Server, all the administration interfaces reside in studios, such as SQL Server Management Studio, which features tools for working with developing database solutions. In this part, I will introduce you to SQL Server Management Studio (SSMS), which is what we will be using to develop and maintain the databases and everything related to it.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



SQL Server 2012 – Ch.01:B – Installing SQL Server 2012

Aug
04
2013
  Posted by  
  For you to follow the rest of this tutorial, you need to have access to SQL Server 2012. For those who do not have one, check out the previous part of this chapter on downloading an express / evaluation edition. In this chapter, I am going to take you through the steps in installing SQL Server 2012.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryInstallation Step By Step categoryTutorial



SQL Server 2012 – Ch.01:A – Introducing SQL Server 2012

Aug
03
2013
  Posted by  
  SQL Server as we all know is Microsoft's flagship database product. It delivers an unparalleled, highly scalable data platform capable of handling the most demanding tasks & workloads. SQL Server has matured over all the years since its first release. As with every release, SQL Server 2012 adds many new features and enhancements for developers, administrators and for end users alike. This chapter introduces to SQL Server 2012.
[Read More...]


Categories: categoryMicrosoft SQL Server categoryMicrosoft SQL Server 2012 categoryTutorial



1 2 3 4 5 6 7 8 9 10 ... 14

Leave Your Comments