SQL Server 2005
SQL Server 2005 Training Information
Microsoft has redesigned SQL server 2005 to deliver unprecedented value and functionality to the Database Administrator and the Developer. The four editions of the SQL server are Express, workgroup, Standard and Enterprise. Each of these editions offers a range of features. High scalability, availability with advanced business intelligence tools empowers business users with a more secure, reliable and productive database management system. A reduced downtime and tight security controls make for a...
*** 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, Rebuilding Large Indexes, Setting Index Options, Page Splits and Performance Considerations, Max Degree of Parallelism, Online Index Operations, Partition Index Operations, Statistical Information, Asynchronous Statistics Updates, Disabling Automatic...
SQL Server 2005 - Database Backup In this tutorial you will learn how to take database backup in SQL Server 2005. The database created above can be backed up at periodic intervals using the Backup Database dialog box in SQL Server Management Studio. The file gets stored in the .abf format. To display the Backup database dialog box right click a database in the Object Explorer and select Tasks > backup. The following dialog box appears The Database is the name of the currently selected Analysis Services...
SQL Server 2005 - Populating the Database In this tutorial you will learn how to populate the database in SQL Server 2005. One method of populating the tables in a database is to right click on a table and select ‘Open Table’ and entering the data in the visual mode that is displayed. Another method is to use the INSERT statement to add rows to a table. The syntax would be as under: INSERT [INTO] table_or_view [(column_list)] data_values The SELECT subquery in the INSERT statement can also be used...
SQL Server 2005 - Database Creation In this tutorial you will learn about Database Creation in SQL Server 2005, The process of Database design and administration, Understanding Database Design concepts, Creating the Personnel Database, Table Designer, Keys, Indexes, Triggers, Constraints, Query and View Designer, View Designer and Query Designer. Databases are defined to meet business needs of the organization. Optimal performance of the database will depend on the DBA’s understanding of the components...
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, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an...
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. The interactive execution of T-SQL statements and scripts is enabled by the Win32 Command prompt utility called sqlcmd utility. This utility can be used to build scripts to be run by sqlcmd users or to interactively enter T-SQL statements into the utility in...
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 Management objects (SMO) exposes the functionality of SQL Server database and replication management. SMO can be used to automate repetitive tasks or commonly performed administrative tasks. The SQL SMO is...
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 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...
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. 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 user interface called...
Full SQL Server 2005 Archive