SQL Server Articles RSS Feed http://www.dotnetfun.com/Articles.aspxSQL Server Articles from C# .Net Fun (dotnetfun.com).en-usWhat's New in ADO.NET 2.0 - New DataTable Featureshttp://www.dotnetfun.com/articles/ado.net/2.0/WhatsNew20ADODataTableFeatures.aspxLearn about the new DataTable features in .Net 2.0 such as the new CreateDataReader method and more!3/19/2006 4:44:14 PMDon't Use CommandBehavior.CloseConnection when Using a using Statementhttp://www.dotnetfun.com/articles/ado.net/DoNotUseCommandBehaviorCloseConnectionWithUsing.aspxYour application's performance will suffer if you automatically close a connection via the CommandBehavior.CloseConnection enumerated value and a using statement in the same scope.3/17/2006 1:31:47 PMWhat's New in ADO.NET 2.0 - New Data Provider Factory Modelhttp://www.dotnetfun.com/articles/ado.net/2.0/WhatsNew20ADODbProviderFactories.aspxLearn how to leverage the new data provider factory. Whether a database belongs to SQL Server, Oracle, Access or something else, you can employ one solution that enables you to connect to them all: a data provider factory.3/16/2006 7:41:29 PMVisual Studio 2005 and SQL Server 2005 to Launch November 7, 2005http://www.dotnetfun.comhttp://www.ftponline.com/weblogger/forum.aspx?ID=1&DATE=06/07/2005&blog=#385Visual Studio 2005 and SQL Server 2005 to Launch November 7, 2005.6/8/2005 12:00:00 AMMS SQL Server 2000 Service Pack 4http://www.dotnetfun.com/articles/sql/MSSQL2000SP4.aspxMS SQL Server 2000 Service Pack 4 is here. Download and install it!5/13/2005 4:37:02 PMError Locating Server/Instance Specified Error During Microsoft SQL Server 2005 Beta 2 April CTP Setuphttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005Beta2SetupxFFFFFFFFError.aspxLearn how to resolve a setup bug in the Microsoft SQL Server 2005 Beta 2 April CTP that results in a Error Locating Server/Instance Specified error message.5/3/2005 11:32:57 AM10 Things You Shouldn't Do with SQL Server (Data Access Developer "Don'ts")http://www.dotnetfun.com/articles/sql/10ThingsYouShouldNotDowithSQLServer.aspxA very nice and common sense article regarding SQL Server best practices that some DBAs and developers unfortunately don't follow. Good job Doug!4/22/2005 11:21:15 AMCreating Asynchronous Triggers with Service Brokerhttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005CreatingTSQLAsynchronousTriggers.aspxLearn how to create asynchronous triggers using T-SQL and Service Broker with SQL Server 2005.1/12/2005 8:17:01 PMCreate SQL Server 2005 CLR Stored Procedures with VS.NET 2005http://www.dotnetfun.com/articles/vs.net/vs.net2005/VSNet2005SQL2005CLRSProc.aspxLearn how to create CLR Stored Procedures with ease with Visual Studio.NET 2005.12/27/2004 10:35:53 PMProblems Sending Messages with Service Brokerhttp://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerProblems.aspxIf you're having problems with not being able to send and receive Service Broker messages, there are a few things you can check and do to resolve the problem(s).12/26/2004 3:52:07 PMService Broker - Basic Architecturehttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerBasicArchitecture.aspxAn overview of how SQL Server 2005 Service Broker works.12/17/2004 4:07:00 PMService Broker - Conversation Architecturehttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerConversationArchitecture.aspxAn explanation of how Service Broker communicates.12/17/2004 4:06:00 PMService Broker - Message Typeshttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerMessageTypes.aspxAn explanation on types of messages allowed by Service Broker.12/17/2004 4:05:00 PMService Broker - Contractshttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerContracts.aspxAn explanation on how contracts regulate communication flows in Service Broker.12/17/2004 4:04:00 PMService Broker - Queueshttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerQueues.aspxAn explanation on how messages integrate with queues in Service Broker.12/17/2004 4:03:00 PMService Broker - Serviceshttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerServices.aspxAn explanation on how services interfaces work in Service Broker.12/17/2004 4:02:00 PMService Broker - Service Programshttp://www.dotnetfun.com/articles/sql/sql2005/SQL2005ServiceBrokerServicePrograms.aspxAn explanation on how service programs handle queued messages in Service Broker.12/17/2004 4:01:00 PMService Broker - Linkshttp://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerLinks.aspxA list of useful Service Broker related links.12/16/2004 12:29:20 PMLearn How to Create CLR Stored Procedures for SQL Server 2005http://www.dotnetfun.com/articles/sql/sql2005/SQL2005CLRSProc.aspxA beginners guide to creating .Net 2.0 CLR Stored Procedures for SQL Server 2005.12/13/2004 10:25:00 PMAdding Microsoft SQL Server 2000 (and later) XML Support via IIS 5 (and later)http://www.dotnetfun.com/Articles/sql/MSSQLIISXMLSupport.aspxLearn how to setup an IIS 5 and later virtual directory that serves as an MS SQL Server XML data extraction source for delivering XML content through the Web.7/12/2004 9:07:31 AMMSDE 2000 for Developers using Visual Studio .NEThttp://www.dotnetfun.com/articles/winforms/MSDEVisualStudioNet.aspxDownload MSDE 2000 for Developers using Visual Studio .NET2/15/2004 12:00:00 AMBuild Data-centric Windows Forms Apps. without MS SQL Server or MS Access Databaseshttp://www.dotnetfun.com/articles/winforms/MSDEWinFormApplication.aspxLearn how to build Windows Forms Apps. with a MSDE Data Tier and Visual Studio .NET.2/15/2004 12:00:00 AM