|
|
-
|
|
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....
|
|
-
|
|
This article will guide you through web services in PHP...
|
|
-
|
|
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....
|
|
-
|
|
This article will cover the working of XML with PHP...
|
|
-
|
|
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. ...
|
|
-
|
|
This section will guide you through the concept of array in PHP....
|
|
-
|
|
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....
|
|
-
|
|
This section will explain how to interact with the File Systems....
|
|
-
|
|
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....
|
|
-
|
|
This section will explain the HTML forms and the predefined variables of PHP...
|
|