Microsoft SQL Server 2005 provides the database developer the opportunity to locate programming code in native formats or create server-driven complex systems. The .NET framework, in combination with the SQL Server 2005, delivers the functionality of the powerful class library in combination with modern programming languages. Common Language Runtime (CLR) is used to code procedures, triggers and functions within the chosen language in the .NET framework. Using object-oriented constructs such as structured exception handling, namespaces, classes and arrays assist the programmer in effectively handling procedural issues when programming with SQL Server 2005.

Getting started with SQL Server 2005 Getting started and Installing SQL Server 2005 part 1 Microsoft has redesigned SQL server 2005 to deliver unprecedented value and functionality to the Database Administrator and the Developer.

Overview of SQL Server 2005 for the Database Developer
SQL Server 2005 Developer tools The driving force behind Micorsoft SQL Server 2005 is the process of integration. With MSSQL 2005 the database developer experiences a paradigm shift. He can now locate his code with reference to its functionality, he can access data in its native formats or build…

SQL Server 2005 Management Studio
SQL Server Management Studio SQL Server Architecture and Components What strikes the developer is the absence of the SQL Enterprise Manager in the interface. The SQL Server Management Studio offers functionality enhancements and a new look and feel to the application. It has been implemented using…

SQL Server Architecture and Components
Business Intelligence Development Studio This solution oriented interface is intended for creating Business intelligence services, integrating projects involving Analysis Services, Reporting services and Data Transformation Services. It is similar to SQL Server Management Studio and provides…

Security Features in SQL Server 2005 for the Developer
Overview of SQL Server 2005 for the Developer-Security In this tutorial you will learn about Security Features in SQL Server 2005 - Authentication, Password Complexity, Password Expiration, Lockout Behavior, Endpoint-based Authentication, Authorization, Native Data Encryption, Code and Module…

T-SQL Enhancements in SQL Server 2005
T-SQL Enhancements in SQL Server 2005 In this tutorial you will learn about T-SQL Enhancements in SQL Server 2005 - Data Definition Language Statements, .NET framework integration, Full Text Search, Index transact SQL Statements, Security Transact SQL Enhancements, Service Broker T-SQL statements,…

Data Manipulation Language (DML) in SQL Server 2005
Data Manipulation Language (DML) in SQL Server 2005 In this tutorial you will learn about Data Manipulation Language (DML) - New Data Types, New Operators, The APPLY Operator, Ranking Functions, The OUTPUT Statement, Common Table Expressions(CTE), OTHER DML and T-SQL functions, TABLESAMPLE, Except…

SQL Server 2005 - Service Broker
SQL Server 2005 - Service Broker Introduction The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker. The Transact SQL Data Manipulation Language is used to the send messages to a queue in the database of the sender…

Using Notification Services in SQL Server 2005
Using Notification Services in SQL Server 2005 In this tutorial you will learn about using notification services in SQL Server 2005, Notification Services Architecture, Building Notification Services Solutions, Using Notification Services, Subscription Management, Syntax for adding subscribers…

Using XML in SQL Server 2005
Using XML in SQL Server 2005 In this tutorial you will learn about using XML in SQL Server 2005 - XML enhancements in SQL Server 2005, the FOR Clause, Using XSINIL with ELEMENTS, Using elementsxinil in EXPLICIT mode and Enhancements to OpenXML function…

XML Data Types in SQL Server 2005
XML Data Types in SQL Server 2005 In this tutorial you will learn about XML Data Types, Query and Inexes in SQL Server 2005 - XML Data type, XML Typing, Advantages of storing XML in databases, Untyped XML data, Using Typed XML, Managing XML indexes, XQuery and XQuery syntax.

Native HTTP Support in SQL Server 2005
Using Native HTTP Support in SQL Server 2005 In this tutorial you will learn about Using Native HTTP Support, Native HTTP Support in SQL Server 2005 and Configuring Native HTTP Support .

NET CLR in SQL Server 2005
Using .NET CLR in SQL Server 2005 In this tutorial we will introduce the concepts relating to CLR integration with SQL Server 2005 including how to implement managed code.

SQL Server Management Objects
SQL Server Management Objects In this tutorial we shall learn about SQL Server Management Objects, briefly examine the different objects available for the process, Connecting to the Server, Database objects and Collections and Scripting.

Developing Client applications in SQL Server 2005
Developing Client applications in SQL Server 2005 In this tutorial you will learn about developing client applications in SQL Server 2005, The context connection, Restrictions for the context connection, ADO.NET in different SQLCLR objects, Avoiding SQL CLR +ADO.NET, System.Transactions, ADO.NET…

SQL Server 2005 Administrative Tools
SQL Server 2005 Administrative Tools Using SQL Sever Management Studio A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical use…

SQL Server 2005 - Registered Servers
SQL Server 2005 - Registered Servers Registered servers can be viewed in the Registered servers window. Servers can be created and registered, renamed or removed in the SQL Server Management Studio. Information on frequently accessed servers will be stored in the Management Studio on Registration….

SQL Server 2005 - Server Groups
SQL Server 2005 - Server Groups In this tutorial you will learn about Server Groups. As stated earlier, servers can be grouped together. Each group can be assigned a name. The name of the server group can also be changed by right clicking on the group name, pointing to edit and selecting Server…

SQL Server 2005 - Management studio interface Summary Page
SQL Server 2005 - Management studio interface Summary Page The summary page appears as the largest window on the Management studio interface. This window presents information about the item selected in the object window. The summary page can be configured to start as soon as SQL Server Management …

SQL Server 2005 Architecture Overview
Overview of SQL Server 2005 Architecture In this tutorial you will learn about SQL Server 2005 Architecture, What’s New in SQL Server 2005—Enhancements for Data Base Administrators. indexing capabilities, peer to peer model of replication, Table and index partitioning, snapshot isolation…

SQL Server 2005 Editions
SQL server 2005 Editions The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise. Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering…

SQL Server 2005 Installation
SQL Server 2005 Installation An interactive set up program helps the setup of SQL Server 2005. The steps have been designed to help the Administrator select the requisite options along the way. The setup screen automatically starts up as soon as the CD/DVD is inserted into the drive.

Planning to Install SQL Server 2005
Planning to Install SQL Server 2005 Different organizations have different application needs and hence installation requirements also vary. The different editions of Microsoft SQL Server cater to the varied needs and accommodate the performance, runtime and price requirements of organizations and …

Installing a Second Copy of SQL Server 2005
Installing a Second Copy of SQL Server 2005 Multiple instances of SQL Server are supported by SQL Server 2005. Previous versions of SQL Servers can also be upgraded to SQL Server 2005. In this section we shall see how to install a second copy of SQL Server 2005.

SQL Server 2005 Installation - Maintenance Plan Using Wizard
SQL Server 2005 Installation - Maintenance Plan Using Wizard Maintenance plans can be created using the Maintenance Plan Wizard or using the design surface. The Wizard is useful if the DBA wants to create a basic maintenance plan. If he intends to create enhanced work flow then…

SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
SQL Server 2005 Installation - Maintenance Plan Without Using Wizard Earlier you learnt about Maintenance Plan Using Wizard, In this tutorial you will learn about Maintenance Plan Without Using Wizard. You will also learn how to change the tasks in the Maintenance Plan Wizard.

SQL Server 2005 - Unattended Installations
SQL Server 2005 - Unattended Installations In this tutorial you will learn about SQL Server 2005 - Unattended Installations, How to perform a silent installation of SQL Server, To Create .iss file, Basic Header Information for Our Script Files, Checking for the Parameters within the Script, Sample…

SQL Server 2005 - Upgrading from earlier versions of SQL Server
SQL Server 2005 - Upgrading from earlier versions of SQL Server In this tutorial you will learn about SQL Server 2005 - Upgrading from earlier versions of SQL Server. SQL Server 2005 permits the upgrading from version 7.0, 2000 (with service pack 3) and 2003. SQL Server 6.5 will have to be upgrade…

SQL Server 2005 - Testing Troubleshooting
SQL Server 2005 - Testing Troubleshooting In this tutorial you will learn about Testing and Troubleshooting, SQL server services: Distributed Transaction Coordinator, Registry settings, SQL server settings, Configuring SQL server internal settings, Configuring Network Protocols.

SQL Server Monitoring Tools - Server Profiler
SQL Server Monitoring Tools - Server Profiler In this tutorial you will learn about SQL Server Profiler, To start SQL Server Profiler in SQL Server Management Studio, To start SQL Server Profiler in Database Engine Tuning Advisor, Security, Space Requirements, To change the TEMP environment variable…

SQL Server 2005 - Using DDL Triggers
SQL Server 2005 - Using DDL Triggers In this tutorial you will learn about DDL Triggers vs DML Triggers, Syntax for creating a DDL Trigger, Designing a DDL Trigger, The EVENTDATA() Function, Implementing a Database-Scoped DDL Trigger, Implementing a Server-Scoped DDL Trigger, Event Notifications

SQL Server 2005 - Using Event Notifications
SQL Server 2005 - Using Event Notifications In this tutorial you will learn about SQL Server 2005 - Using Event Notifications, Creating Event Notifications, Creating an Event Notification, Creating the Target Service, Creating /Dropping / modifying the Event Notification and Using Metadata Views.

Using SQL Sever Management Studio - Part 1
Using SQL Sever Management Studio - Part 1 In the tutorial you will learn about Using SQL Sever Management Studio, The features of the Management Studio, Starting SQL Server Management Studio, The Object Explorer and also Default. Optional connection settings.

Using SQL Sever Management Studio - Part 2
Using SQL Sever Management Studio - Part 2 In this tutorial you will learn further more about Using SQL Sever Management Studio, Registered Servers, To Register a server, Server Groups, The Summary Page, The Database Engine Administration, The tasks of a Database Administrator…

Using the SQL Management Objects
Using the SQL Management Objects In this tutorial you will learn about Using the SQL Management Objects, Unsupported namespaces, Programming SQL Server Management objects, Setting Default Initialization Fields, Definitions, Capture mode, Linked servers and SMO methods and properties.

SQL Server 2005 - Using the Sqlcmd Utility
SQL Server 2005 - Using the Sqlcmd Utility In this tutorial you will learn about SQL Server 2005 - Using the Sqlcmd Utility, Running the sqlcmd utility, Sqlcmd rules - Quoted Strings, Code Page Conversion Rules and Interactive sqlcmd Example.

SQL Server 2005 Configuration Manager
SQL Server Configuration Manager In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server…

SQL Server 2005 - Populating the Database
SQL Server 2005 - Populating the Database In this tutorial you will learn how to populate the database in SQL Server 2005.

SQL Server 2005 - Database Backup
SQL Server 2005 - Database Backup In this tutorial you will learn how to take database backup in SQL Server 2005.

Maintain indexes in a SQL Server 2005 database
Maintain indexes in a SQL Server 2005 database In this tutorial you will learn about maintaining Indexes in a SQL Server 2005 database - Dealing with Fragmented indexes, Reorganizing an Index, Rebuilding an Index, Disabling Non-clustered Indexes to Reduce Disk Space During Rebuild Operations…

SQL Server 2005 - Defining Indexes
SQL Server 2005 - Defining Indexes In this tutorial you will learn about Defining Indexes in SQL Server 2005 - clustered and non clustered indexex, The Query Optimizer, to create an index, To create a unique index, To create a clustered index, To create full-text indexes, To change index properties…

SQL Server 2005 - Tuning a Database
SQL Server 2005 - Tuning a Database In this tutorial you will learn about Database Tuning Advisor overview, Database Engine Tuning Advisor Features, Improved Workload Parsing, Enhanced Scalability, Integrated Tuning, Multiple Database Tuning, Offload of Tuning Overhead to Test Server, Drop-Only…

SQL Server 2005 - Using the Database Tuning Advisor
SQL Server 2005 - Using the Database Tuning Advisor In this tutorial you will learn about Using the Database Tuning Advisor in SQL Server 2005, Using the DTA, Open the Database Engine Tuning Advisor GUI, Set the tool options, Hide and unhide the Session Monitor, Tune a workload Transact-SQL script…

Managing SQL Server 2005 Security
Managing SQL Server 2005 Security In this tutorial you will learn about Managing SQL Server 2005 Security. Microsoft has consciously invested in the creation of a precise and flexible security model of the database platform with security features that include surface area reduction, data encryption…

SQL Server 2005 - Managing Permissions
SQL Server 2005 - Managing Permissions In this tutorial you will learn about Managing Permissions in SQL Server 2005. Authorization features determine the level of access rights once the user’s logon process is successfully completed. A significant aspect of SQL Server 2005 authorization mode

SQL Server 2005 - Managing Certificates
SQL Server 2005 - Managing Certificates In this tutorial you will learn about Managing Certificates in SQL Server 2005, SQL Server 2005 makes significant improvements in two areas—Native encryption and certificates. Encryption is a mechanism that is intended to protect data using a specially…

SQL Server 2005 - Disaster Recovery
SQL Server 2005 - Disaster Recovery In this tutorial you will learn about Disaster Recovery in SQL Server 2005, Recovery Models, Managing Backup Media, Running a Base-Functionality Script and Ensuring Disaster Readiness.

SQL Server 2005 - Using Database Snapshots
SQL Server 2005 - Using Database Snapshots In this tutorial you will learn about Using Database Snapshots in SQL Server 2005, Effect of the Update Pattern on Database Snapshot Growth, Metadata About Database Snapshots, Limitations on the Source Database, Limitations on Database Snapshots, Database…

SQL Server 2005 - Backing up a Database
SQL Server 2005 - Backing up a Database In this tutorial you will learn about Backing up a Database in SQL Server 2005 - Backup and Restore operations, Restoring System Databases, Media Reliability, Using Checksums during backup and Restore and Backup Media mirroring.

SQL Server 2005 - Introduction to Data Availability
SQL Server 2005 - Introduction to Data Availability In this tutorial you will learn about Data Availability in SQL Server 2005 - Failover clustering, Database mirroring, Log shipping, Replication, Introduction to Database Mirroring and advantages of mirroring.

SQL Server 2005 - Mirror Server
SQL Server 2005 - Mirror Server In this tutorial you will learn about Mirror Server in SQL Server 2005 - Preparing the Principal and Mirror Server, Establishing a Mirroring Session, Establishing a Witness Server, Executing Transactions, Simulating Principal Server Failure, Restarting the Failed…

SQL Server 2005 Replication Enhancements
SQL Server 2005 Replication Enhancements In this tutorial you will learn about Overview of Replication Enhancements, User Interface Enhancements, Merge replication concurrency Enhancements, Programming changes, The Replication Monitor, Performance and Scalability Features, Pre-computed partitions…

SQL Server 2005 - Configuring Replication
SQL Server 2005 - Configuring Replication In this tutorial you will learn about SQL Server 2005 - Configuring Replication - New Types of Replication, Peer to Peer Transactional Replication, HTTP Replication, Configuring Replication Configuring Replication Using RMO, Referencing the RMO and SMO…

SQL Server Integration Services
SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy.

SQL Server Interview Questions

SQL Server FAQ’s

Database Interview Questions
Btrieve
Clipper
Database Admin
Firebird
Informix
Microsoft Access
MYSQL
PostgreSQL		 Progress
SAP DB
SQL
SQL Server
Stored Procedures
Sybase
Teradata
Unify