http://www.windowsitpro.com/authors/author/author/5777727/rss/5777727en-USSun, 27 May 2012 07:41:30 GMTSun, 27 May 2012 07:41:30 GMThttp://www.windowsitpro.com/article/sql-server-2005/accessing-web-services-in-sql-server-2005Microsoft’s Patrick Conlan explains a design philosophy in SQL Server 2005.]]>Microsoft's SQL Server Development TeamWed, 23 Aug 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/accessing-web-services-in-sql-server-2005http://www.windowsitpro.com/article/sql-server-2005/the-disappearance-of-sql-server-expressMicrosoft’s Richard Waymire helps a reader locate an instance of SQL Server 2005 Express.]]>Microsoft's SQL Server Development TeamWed, 23 Aug 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/the-disappearance-of-sql-server-expresshttp://www.windowsitpro.com/article/sql-server-2000/transferring-sql-server-registration-information-between-machinesMicrosoft’s Richard Waymire gives a method for moving server registration information between client machines.]]>Microsoft's SQL Server Development TeamWed, 23 Aug 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2000/transferring-sql-server-registration-information-between-machineshttp://www.windowsitpro.com/article/tsql3/easy-reading-see-backup-date-and-timeMicrosoft’s Gert Drapers provides a script that creates backup filenames that display the date and time of the backup, complete with leading zeros for easy reading.]]>Microsoft's SQL Server Development TeamThu, 20 Jul 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/easy-reading-see-backup-date-and-timehttp://www.windowsitpro.com/article/performance/optimizing-distributed-transactionsMicrosoft’s Patrick Conlan gives tips on how to maintain good performance when executing distributed queries between SQL Server instances.]]>Microsoft's SQL Server Development TeamThu, 20 Jul 2006 00:00:00 GMThttp://www.windowsitpro.com/article/performance/optimizing-distributed-transactionshttp://www.windowsitpro.com/article/tsql3/using-msdb-backup-tablesMicrosoft’s Gert Drapers explains techniques for getting valuable information from SQL Server’s msdb backup tables.]]>Microsoft's SQL Server Development TeamThu, 22 Jun 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/using-msdb-backup-tableshttp://www.windowsitpro.com/article/stored-procedures/transferring-identity-field-valuesMicrosoft’s Vaquar Pirzada explains how to use the sp_scriptdynamicupdproc stored procedure to include Identity field values in transactional replication.]]>Microsoft's SQL Server Development TeamTue, 23 May 2006 00:00:00 GMThttp://www.windowsitpro.com/article/stored-procedures/transferring-identity-field-valueshttp://www.windowsitpro.com/article/stored-procedures/performing-very-large-set-updatesMicrosoft’s Vaquar Pirzada gives you options for performing very large set updates in SQL Server 2000.]]>Microsoft's SQL Server Development TeamTue, 23 May 2006 00:00:00 GMThttp://www.windowsitpro.com/article/stored-procedures/performing-very-large-set-updateshttp://www.windowsitpro.com/article/tsql3/tip-executing-statements-in-a-user-databaseMicrosoft’s Gert Drapers explains how to execute statements in the context of a user database.]]>Microsoft's SQL Server Development TeamWed, 22 Mar 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/tip-executing-statements-in-a-user-databasehttp://www.windowsitpro.com/article/common-language-runtime-clr/using-the-clr-with-c-dllsMicrosoft’s Patrick Conlan explains how C# DLLs will work with the CLR in SQL Server 2005.]]>Microsoft's SQL Server Development TeamWed, 22 Feb 2006 00:00:00 GMThttp://www.windowsitpro.com/article/common-language-runtime-clr/using-the-clr-with-c-dllshttp://www.windowsitpro.com/article/sql-server-2005/what-s-a-snapshot-Microsoft’s Patrick Conlan gives a brief explanation of database snapshots.]]>Microsoft's SQL Server Development TeamWed, 22 Feb 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2005/what-s-a-snapshot-http://www.windowsitpro.com/article/tsql3/how-not-to-use-useMicrosoft’s Gert Drapers provides a script for retrieving table information. ]]>Microsoft's SQL Server Development TeamWed, 22 Feb 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/how-not-to-use-usehttp://www.windowsitpro.com/article/tsql3/automatic-truncation-of-long-parameter-valuesMicrosoft’s Richard Waymire explains a truncating feature in SQL Server 2000.]]>Microsoft's SQL Server Development TeamWed, 25 Jan 2006 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/automatic-truncation-of-long-parameter-valueshttp://www.windowsitpro.com/article/sql-server-2000/using-sql-dmo-to-check-code-syntaxMicrosoft’s Gert Drapers and Patrick Conlan provide a couple of ways you can use SQL-DMO to check code syntax.]]>Microsoft's SQL Server Development TeamWed, 25 Jan 2006 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-2000/using-sql-dmo-to-check-code-syntaxhttp://www.windowsitpro.com/article/log-files/finding-an-individual-log-fileMicrosoft’s Gert Drapers provides statements for finding an individual database log file.]]>Microsoft's SQL Server Development TeamWed, 25 Jan 2006 00:00:00 GMThttp://www.windowsitpro.com/article/log-files/finding-an-individual-log-filehttp://www.windowsitpro.com/article/events-and-monitoring/updating-an-oracle-trigger-for-sql-server-2000Microsoft’s Patrick Conlan explains how to make an Oracle trigger work in SQL Server 2000.]]>Microsoft's SQL Server Development TeamTue, 20 Dec 2005 00:00:00 GMThttp://www.windowsitpro.com/article/events-and-monitoring/updating-an-oracle-trigger-for-sql-server-2000http://www.windowsitpro.com/article/tips/rotating-a-sql-server-tableMicrosoft’s Patrick Conlan offers two ways to rotate a table in SQL Server.]]>Microsoft's SQL Server Development TeamWed, 02 Nov 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tips/rotating-a-sql-server-tablehttp://www.windowsitpro.com/article/tips/using-t-sql-to-check-database-memoryMicrosoft’s Gert Drapers shows how to use T-SQL to check a database’s memory usage.]]>Microsoft's SQL Server Development TeamWed, 02 Nov 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tips/using-t-sql-to-check-database-memoryhttp://www.windowsitpro.com/article/tsql3/simple-but-slow-performance-tuning-tips-for-an-ailing-queryMicrosoft’s Patrick Conlan comes up with a hatful of tricks to performance-tune a simple query that won’t perform.]]>Microsoft's SQL Server Development TeamTue, 20 Sep 2005 00:00:00 GMThttp://www.windowsitpro.com/article/tsql3/simple-but-slow-performance-tuning-tips-for-an-ailing-queryhttp://www.windowsitpro.com/article/sql-server-analysis-services/loading-text-into-analysis-servicesMicrosoft’s Thierry D’hers describes the steps for getting a string to show up in analysis cubes. ]]>Microsoft's SQL Server Development TeamWed, 22 Jun 2005 00:00:00 GMThttp://www.windowsitpro.com/article/sql-server-analysis-services/loading-text-into-analysis-services