http://www.sqlmag.com/authors/author/author/5055823/rss/5055823en-USFri, 25 May 2012 10:35:53 GMTFri, 25 May 2012 10:35:53 GMThttp://www.sqlmag.com/article/project-plan-tsql-sql-server-2008-r2-78/database-development/simplifying-spatial-data
By Kurt Survance
Find out how SQL Server 2008’s spatial data types compare to traditional T-SQL functions when it comes to performing complex geospatial queries.]]>Kurt SurvanceTue, 15 Mar 2011 15:03:00 GMThttp://www.sqlmag.com/article/project-plan-tsql-sql-server-2008-r2-78/database-development/simplifying-spatial-datahttp://www.sqlmag.com/article/sql-server/common-language-runtime-from-the-dba-point-of-view
By Kurt Survance
The introduction of CLR may have blurred the line between DBA and developer, but this powerful coding tool offers real advantages over SQL for all roles in a deployment.]]>Kurt SurvanceMon, 07 Feb 2011 09:21:00 GMThttp://www.sqlmag.com/article/sql-server/common-language-runtime-from-the-dba-point-of-viewhttp://www.sqlmag.com/article/sql-server/programming-sql-in-a-set-based-way
By Kurt Survance
This article’s real-world example might help you start thinking in a set-based way about a common type of problem that has an intuitive procedural solution.]]>Kurt SurvanceWed, 23 Jun 2010 13:33:00 GMThttp://www.sqlmag.com/article/sql-server/programming-sql-in-a-set-based-wayhttp://www.sqlmag.com/article/sql-server-profiler/gathering-deadlock-information-with-deadlock-graph
By Kurt Survance
Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management Studio or review in XML for more detailed information.]]>Kurt SurvanceThu, 21 Jan 2010 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-profiler/gathering-deadlock-information-with-deadlock-graph