Directory of FAQs, Help, and Tutorials Resources

Home > Computers > Software > Databases > Microsoft SQL Server > FAQs, Help, and Tutorials

Resources in This Category

• Creating a Simple ETL Package for SQL Server

  http://msdn.microsoft.com/en-us/library/ms169917.aspx
  This tutorial walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging.

• Distributed Partitioned Views

  http://www.databasejournal.com/features/mssql/article.php/3319481
  Speeding up large web server databases by using Distributed Partitioned Views on Federated Databases by Don Schlichting.

• Distributed Partitioned Views - Federated Databases: Lessons Learned

  http://blogs.msdn.com/sqlcat/archive/2007/06/20/distributed-partitioned-views-federated-databases-lessons-learned.aspx
  This article contains information about the things we have learned while working with Federated Databases by Kevin Cox.

• How to Transfer SQL Logins between SQL Server 2005 Instances

  http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx
  Articles presents a custom script as well as standard options for moving SQL logins between servers by Tara Kizer.

• MS SQL Guide

  http://www.mssqlguide.com/
  Series of articles on Microsoft SQL Server tasks.

• PIVOT in SQL Server 2005

  http://www.devx.com/dbzone/Article/28165
  Learn to combine SQL Server's PIVOT and UNPIVOT commands with Common Table Expressions by Michael Jones.

• Pivoting, Un-pivoting and Aggregating

  http://www.simple-talk.com/sql/t-sql-programming/pivoting,-un-pivoting-and-aggregating-a-quick-spin-around-the-block/
  Techniques in pivoting and un-pivoting data, and showing how the use of the CUBE or ROLLUP operator can be a more efficient way of generating reports by Phil Factor.

• Replication with SQL Server 2000

  http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/
  Explanation of Replication with SQL Server 2000 by Mahesh Kodli.

• Spatial Data with SQL Server 2008

  http://jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx
  Introduction to Spatial Data concepts as well as detailed SQL Server instructions on use by Jason Follas.

• SQL Optimizations School

  http://www.sqloptimizationsschool.com/
  Contains tutorials and tests for those wanting to learn to write better code. They also have a troubleshooting tool to help people narrow down slowness issues.

• SQL Server 2005 Paging

  http://www.sqlservercentral.com/articles/T-SQL/66030/
  Article explores four approaches for coding SQL when results will be returned to an application that supports paging by Robert Cary.

• SQL Server DBA

  http://sqlserver-dba.co.uk/
  Various DBA related blog articles.

• SQL Server Replication FAQ

  http://vyaskn.tripod.com/repl_ques.htm
  FAQs on SQL Server replication and solutions to common problems. By Narayana Vyas Kondreddi.

• SQL Server Service Broker Introduction

  http://msdn.microsoft.com/en-us/library/ms345108.aspx
  Introduction and definition of SQL Server Service Broker by Roger Wolter.

• SQL2Developers

  http://www.sql2developers.com/
  Various how to SQL Server blog articles.

• SQLDTS.com

  http://www.sqldts.com/
  Articles, code samples, and tools help with development of robust and flexible Data Transformation Services (DTS) packages.

• The Future of SQL Data Services with Nigel Ellis

  http://channel9.msdn.com/posts/ZachSkylesOwens/The-Future-of-SQL-Data-Services-with-Nigel-Ellis/
  Interview discussing the future direction of SQL Data Services.

• Unstructured Data SQL 2008

  http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_unstructured.mspx
  Tutorial on Managing Unstructured Data with SQL Server 2008 by Graeme Malcolm.

• User Defined Functions

  http://www.sqlteam.com/article/user-defined-functions
  This article covers all the basics of User Defined Functions. It discusses how (and why) to create them and when to use them by Doug Carpenter,

• Using SQL Server 2008 Upgrade Advisor

  http://databases.about.com/od/sqlserver/ht/sqlupgrade.htm
  Article provides a step by step listing of using the SQL Server 2008 Upgrade Advisor by Mike Chapple.

Related Categories

• Home > Computers > Software > Databases > FAQs, Help, and Tutorials

 

Home > Computers > Software > Databases > Microsoft SQL Server > FAQs, Help, and Tutorials

 

---

 

Thanks to DMOZ, which built a great web directory for nearly two decades and freely shared it with the web. About us