SearchSQLServer.com's tutorials provide the in-depth information SQL Server database administrators and developers are seeking on Microsoft's flagship database enterprise server, SQL Server and its latest release SQL Server 2008. Our SQL Server tutorials address areas you need to know about, including performance, migration strategies and business intelligence.
As SQL Server continues to evolve, newbies and sometimes even the most knowledgeable DBAs could use a little help. Whether you want to learn SQL Server basics or simply get a refresher, we've got what you're looking for. We've compiled a tutorial for SQL Server beginners on topics from security to performance. This reference provides the SQL Server basic help you need in areas such as how to configure tempdb, use SQL Profiler, grant permissions, understand temporary tables vs. table variables and much more.
SQL Server Consolidation Fast
This short guide features resources for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, strategies, best practices and more.
Tutorial: Performance tuning SQL Server via
queries, indexes and more
If you are looking to tune your SQL Server in the hopes of improving performance, this tutorial has the expert advice you need. Learn how to optimize queries, employ the best indexing practices, utilize the best storage or memory configurations and troubleshoot any other errors or problems that might be limiting SQL Server performance.
SQL Server Service Broker Tutorial and Reference
Discover the basics of the SQL Server Service Broker, including a general overview on how this addition to SQL Server works. Also, learn about the Service Broker's major objects, including message types, contracts, queues, services and commands such as SEND and RECEIVE. Finally, get tips on how to improve the Service Broker's performance and how to monitor any possible backlogging the Broker might encounter.
All-in-One Guide: SQL Server backup and
Find out how to successfully back up and recover SQL Server data with this collection of tips and expert advice. Our three categories include Basics, Restore Procedures, and Maintenance and Troubleshooting, with tips on selecting a SQL Server backup model, steps to faster backups, and optimizing backup performance.
Checklist: Getting ready for SQL Server
Edgewood Solutions' Greg Robidoux helps you get up to speed on SQL Server 2005 features and upgrade planning essentials.
Checklist: How to archive SQL Server
Be able to recover quickly from an archived backup. Edgewood Solutions' Greg Robidoux explains why and how to archive and recover SQL Server database backups.
Choose SQL Server installation
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and experience a glitch-free installation.
Fast Guide: Avoiding data integrity
You may perform a number of tasks for data integrity's sake, assuring that data can only be accessed or modified by those authorized to do so. Yet improperly performing such tasks can harm your data. This fast guide offers tips and tricks to ensure and maintain data integrity, with a particular focus on avoiding the "gotchas" that can compromise your data.
Fast Guide: Clustering in SQL
Clustering can increase reliability and uptime in a client/server environment. As a DBA, you have many options to choose from when it comes to clustering. When a server fails, should you totally rely on a complete fail-over design? What's the best way to approach load balancing? Let this fast guide help you find the best fit for your environment.
Fast Guide: Controlling access to SQL
Controlling access to SQL Server is essential to protecting your business-critical data from unwanted external -- or internal -- eyes. Get help limiting or preventing SQL Server access in this fast guide.
Fast Guide: Free SQL Server tools
This list of free SQL Server tools will help reduce your workload, streamline maintenance and improve the performance of your databases.
Fast Guide: Solving SQL Server
Stumped by a SQL Server error? Troubleshoot the problem right away with this ever-growing list of expert responses and best practices to help you address various error messages.
Fast Guide: Stored procedures
Stored procedures can be executed quickly inside your database server, saving you the time it would take to do the same work on a client. In the second part of our stored procedure series of fast guides, we offer stored procedures to help you with SQL Server data migration, performance and querying.
Fast Guide: Undocumented stored
Stored procedures can help you control access, preserve data integrity and improve productivity, yet you may not be tapping into all the routines that ship with SQL Server. Here we highlight some particularly useful undocumented stored procedures, as well as some other tips and tricks not to miss.
Learning Guide: SQL Server performance tuning A to
From testing and monitoring to tuning and troubleshooting, you're sure to find a tip or tool to help you resolve your SQL Server performance dilemmas in this guide.
Learning Guide: SQL Server
SQL Server is known for its ease-of-use and that characteristic is one reason why more and more businesses are choosing Microsoft's DBMS for large-scale implementations. But the default settings that make SQL Server so easy to set up can leave the doors open, making it an easy target. This learning guide can help you identify those problem areas and secure your SQL Server systems.
Microsoft SQL Server Tools Guide
Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find the tool or utility you need in this guide. Check out some of the best native and third-party tools for Microsoft's database management systems.
SQL Server 2000 to 2005 upgrade
Upgrading from SQL Server 2000 to 2005 involves key planning considerations. Before you upgrade to SQL Server 2005, review this checklist.
SQL Server 2005 Learning Guide
Are you ready for SQL Server 2005? Here you will find news and expert technical advice to answer your SQL Server 2005 questions and put you on track for a successful upgrade.
SQL Server 2005 performance tuning tools
Make sure your SQL Server 2005 databases and applications are at optimal performance levels. Once you identify problems, you'll need to know the tools to fix them. This collection of tips from our SQL Server experts will guide you toward optimizing new tools and features.
SQL Server Backup and Recovery Learning
Be prepared to handle all those "minor" SQL Server dilemmas that can lead to temporary system meltdowns. This guide will help you successfully back up and recover SQL Server data.
SQL Server business intelligence
Deploying optimal Business Intelligence applications in SQL Server 2005 is becoming key to database administrators as the area of BI grows in importance. In this toolbox, we've compiled a handful of tools and expert advice to assist you in areas from boosting data warehouse performance to using snapshots in Reporting Services.
SQL Server data encryption fast
SQL Server encryption provides that extra protection to secure your database. Yet, it can be cumbersome to implement, and at times frustrating to troubleshoot errors. In this fast guide, get specifics on encrypting your backup files, stored procedures, column data and more.
SQL Server Reporting Services Fast
Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.
SQL Server Security Learning
SQL Server is a popular target to Internet hackers. Make sure SQL Server is locked down from the get-go and continually hardened to prevent attacks.
Step-by-Step Guide: Migrating to SQL Server 2005
with Copy Database Wizard
The Copy Database Wizard offers a point-and-click interface to easily migrate a single SQL Server database and its objects from SQL Server 2000 to 2005. Edgewood Solutions' Jeremy Kadlec explains how in this step-by-step guide.
Step-by-Step Guide: Planning your migration to
SQL Server 2005
Before upgrading to SQL Server 2005, you must determine which components you need to upgrade and what steps to take to get there. Edgewood Solutions' Jeremy Kadlec reviews your migration options.
Step-by-Step Guide: Test for a Trojan horse on
your SQL Server
SQL Sever sluggishness and other database and operating system woes can mean there's a Trojan horse in your midst. Before you spend countless hours troubleshooting, run these tests to rule out a malware infection.
Tutorial: SQL Server 2005 Analysis
These tips outline helpful features and give examples of Analysis Services in SQL Server 2005 functionality. Get the scoop on how to use SQL Profiler for Analysis Services, how to work with cubes for improved performance, what makes MDX in Analysis Services powerful and more.
Tutorial: SQL Server indexing tips to improve
Significantly improve your SQL Server performance through this tutorial on proper indexing choices. Find out how to design the best SQL Server indexes, along with fine tuning them with respect to index columns, clustered indexes and and index configurations. Also, learn how to weed out valueless indexes, design high performing indexes and query your existing SQL Server indexes.
Tutorial: SQL Server Integration Services (SSIS)
Whether you plan to migrate SQL Server Data Transformation Services (DTS) packages to SQL Server Integration Services or run DTS packages in SQL Server 2005, this tutorial has it all. Learn the best practices for SQL Server Integration Services (SSIS), from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server.
This was first published in February 2011