http://www.sqlmag.com/authors/author/author/5200402/rss/5200402en-USFri, 25 May 2012 10:52:58 GMTFri, 25 May 2012 10:52:58 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-How can I convert a SQL date/time to just date?]]>Neil PikeMon, 21 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/configuration/how-can-i-convert-a-sql-date-time-to-just-date-http://www.sqlmag.com/article/odbc/what-issues-are-there-with-sql-7-s-dts-function-and-oracle-What issues are there with SQL 7’s DTS function and Oracle.]]>Neil PikeWed, 09 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/odbc/what-issues-are-there-with-sql-7-s-dts-function-and-oracle-http://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-What is the Microsoft Loopback adapter and why do I need it for SQL Server?]]>Neil PikeWed, 09 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-is-the-microsoft-loopback-adapter-and-why-do-i-need-it-for-sql-server-http://www.sqlmag.com/article/odbc/where-can-i-get-an-ole-db-odbc-jdbc-driver-to-connect-sql-server-to-product-xyz-Where can I get an OLE-DB/ODBC/JDBC driver to connect SQL Server to product xyz?]]>Neil PikeWed, 09 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/odbc/where-can-i-get-an-ole-db-odbc-jdbc-driver-to-connect-sql-server-to-product-xyz-http://www.sqlmag.com/article/performance/i-have-a-sql-server-process-that-shows-as-being-in-spinloop-what-does-this-mean-I have a SQL Server process that shows as being in SPINLOOP. What does this mean?]]>Neil PikeWed, 09 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/performance/i-have-a-sql-server-process-that-shows-as-being-in-spinloop-what-does-this-mean-http://www.sqlmag.com/article/sql-server-70/now-that-sql-7-0-is-released-can-i-still-buy-sql-6-5-Now that SQL 7.0 is released can I still buy SQL 6.5?]]>Neil PikeWed, 09 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-70/now-that-sql-7-0-is-released-can-i-still-buy-sql-6-5-http://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-sp2-beta-for-sql-7-0-Where can I get SP2 beta for SQL 7.0?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-sp2-beta-for-sql-7-0-http://www.sqlmag.com/article/john-savills-windows-faqs/what-can-i-do-about-handling-blocking-and-deadlocks-in-sqlWhat can I do about handling blocking and deadlocks in SQL]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/what-can-i-do-about-handling-blocking-and-deadlocks-in-sqlhttp://www.sqlmag.com/article/john-savills-windows-faqs/why-am-i-being-blocked-by-spid-1-i-am-not-able-to-kill-it-and-have-to-restart-sql-server-to-get-around-it-Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it.]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/why-am-i-being-blocked-by-spid-1-i-am-not-able-to-kill-it-and-have-to-restart-sql-server-to-get-around-it-http://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-get-the-current-time-in-gmt-rather-than-local-time-How can I get the current time in GMT rather than local time?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-get-the-current-time-in-gmt-rather-than-local-time-http://www.sqlmag.com/article/performance/what-do-microsoft-mean-by-internal-vs-external-fragmentation-in-sql-server-What do Microsoft mean by Internal vs External fragmentation in SQL Server?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/performance/what-do-microsoft-mean-by-internal-vs-external-fragmentation-in-sql-server-http://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-available-sql-servers-in-my-application-How can I list all available SQL Servers in my application?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/how-can-i-list-all-available-sql-servers-in-my-application-http://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-get-on-a-beta-program-for-new-versions-of-sql-olap-mseq-etc-How can I get on a beta program for new versions of SQL/OLAP/MSEQ etc?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-get-on-a-beta-program-for-new-versions-of-sql-olap-mseq-etc-http://www.sqlmag.com/article/reporting2/why-won-t-my-log-shrink-in-sql-7-Why won’t my log shrink in SQL 7?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/reporting2/why-won-t-my-log-shrink-in-sql-7-http://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-How can I use Lotus Notes for SQL Mail?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/how-can-i-use-lotus-notes-for-sql-mail-http://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-more-info-on-the-spt_values-table-Where can I get more info on the spt_values table?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/where-can-i-get-more-info-on-the-spt_values-table-http://www.sqlmag.com/article/monitoring-and-analysis/where-can-i-get-a-diagram-of-the-sql-7-system-tables-Where can I get a diagram of the SQL 7 system tables?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/where-can-i-get-a-diagram-of-the-sql-7-system-tables-http://www.sqlmag.com/article/john-savills-windows-faqs/sql-server-hangs-and-becomes-unresponsive-what-can-i-do-SQL Server hangs and becomes unresponsive - what can I do?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/john-savills-windows-faqs/sql-server-hangs-and-becomes-unresponsive-what-can-i-do-http://www.sqlmag.com/article/encryption2/are-sql-server-userid-s-and-passwords-passed-in-clear-on-the-network-Are SQL Server userid’s and passwords passed in clear on the network?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/encryption2/are-sql-server-userid-s-and-passwords-passed-in-clear-on-the-network-http://www.sqlmag.com/article/encryption2/how-does-a-client-talk-to-sql-server-what-is-a-net-lib-what-network-protocols-are-used-what-net-libs-support-nt-authentication-encryption-How does a client talk to SQL Server? What is a net-lib? What network protocols are used? What net-libs support NT authentication/encryption?]]>Neil PikeSat, 05 Feb 2000 00:00:00 GMThttp://www.sqlmag.com/article/encryption2/how-does-a-client-talk-to-sql-server-what-is-a-net-lib-what-network-protocols-are-used-what-net-libs-support-nt-authentication-encryption-