Directory Help
Search only in FAQs, Help, and TutorialsSearch the Web  

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

Web Pages
Viewing in Google PageRank order               View in alphabetical order
  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.
  FileStream SQL 2008 - http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx
Tutorail on using the FileStream in SQL 2008 by R Doherty.
  SQLXML FAQ Site - http://sqlxml.org/
SQLXML.org is a developer resource that provides answers to frequently asked questions about SQL Server XML.
  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.
  SQLDTS.com - Data Transformation Services - http://www.sqldts.com
Articles, code samples, and tools help with development of robust and flexible Data Transformation Services (DTS) packages.
  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.
  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.
  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.
  How to Transfer the Logins and the Passwords between Instances of SQL Server 2005 - http://support.microsoft.com/kb/918992/
Microsoft knowledge-base article containing instructions and a script to run.
  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.
  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.
  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 Database Recovery - http://www.sql-recovery.com/
SQL Server database recovery information.
  Paging Records Using SQL Server ROW_NUMBER Function - http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx
SQL Server has a ROW_NUMBER Function that can help with paging records for you database applications by David Hayden.
  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.
  Troubleshooting Microsoft SQL Server FAQ - http://www15.brinkster.com/shakhov/
Various troubleshooting Microsoft SQL Server FAQ artricles in both English and Russian.
  SQL Server From Squirrel's View - http://www.lockergnome.com/sqlsquirrel/
Providing solutions and tips to everyday SQL Server problems.
  SQL Server 2008 Resource Governor in action - http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx
Short blogcast demo of the Resource Governor in action.
  MS SQL Guide - http://www.mssqlguide.com/
Series of articles on Microsoft SQL Server tasks.
  SQL 2008 Filestream Example - http://mtaulty.com/CommunityServer/blogs/mike_taultys_blog/archive/2007/10/23/9886.aspx
Example of FILESTREAM in SQL 2008 by Mike Taulty.
  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.
  2000 Trainers: SQL Server Tutorials - http://www.2000trainers.com/tutorials/sql-server/
Collection of tutorials covering a range of topics.
  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.
  Weblogs @ SQL Advice - http://sqladvice.com/blogs/
A collection of weblogs focusing on all aspects SQL Server.
  mssqlserver.com: SQL Server FAQ - http://www.mssqlserver.com/faq/
By Neil Pike and Michael Hotek.

Help build the largest human-edited directory on the web.
Submit a Site - Open Directory Project - Become an Editor

The content of the Google directory is based on the Open Directory and is enhanced using Google's own technology.
The following Open Directory editors contributed to this category:
donschli   

Modified by Google - ©2009 Google
Advertise with Us - Jobs, Press, Cool Stuff...