http://www.sqlmag.com/authors/author/author/5082386/rss/5082386en-USFri, 25 May 2012 10:45:58 GMTFri, 25 May 2012 10:45:58 GMThttp://www.sqlmag.com/article/sql-server/debugging-stored-procedures-142054
By William Sheldon
Using Visual Studio 2010 to debug SQL Server stored procedures is a feature well worth exploring if you need to have more insight about how a stored procedure is behaving in the context of an application.]]>William SheldonWed, 21 Mar 2012 15:00:00 GMThttp://www.sqlmag.com/article/sql-server/debugging-stored-procedures-142054http://www.sqlmag.com/article/visualstudiolightswitch/product-review-visual-studio-lightswitch-141711
By William Sheldon
Although Visual Studio LightSwitch uses the same development environment as other Microsoft .NET development tools, it takes a very different approach to application development.]]>William SheldonFri, 24 Feb 2012 21:02:00 GMThttp://www.sqlmag.com/article/visualstudiolightswitch/product-review-visual-studio-lightswitch-141711http://www.sqlmag.com/article/development/review-telerik-radcontrols-aspnet-140588
By William Sheldon
If you’re looking for ASP.NET rapid application development (RAD) controls, Telerik’s RadControls suite is an excellent choice.]]>William SheldonThu, 15 Dec 2011 16:43:00 GMThttp://www.sqlmag.com/article/development/review-telerik-radcontrols-aspnet-140588http://www.sqlmag.com/article/development/review-componentone-olap-winforms-139757
By Sheldon, William
Although this package has the term OLAP in its name, it doesn’t work with multidimensional data.]]>Sheldon, WilliamFri, 23 Sep 2011 15:48:00 GMThttp://www.sqlmag.com/article/development/review-componentone-olap-winforms-139757http://www.sqlmag.com/article/sql-server/new-features-in-linq
By William Sheldon
LINQ is still a powerful tool for working with SQL Server data and includes new features such as Parallel LINQ (PLINQ) and SharePoint integration.]]>William SheldonMon, 25 Oct 2010 12:09:00 GMThttp://www.sqlmag.com/article/sql-server/new-features-in-linqhttp://www.sqlmag.com/article/troubleshooting/using-performance-profiler-to-troubleshoot-ado-net-applications
By William Sheldon
If you’re a developer but not a DBA, you might find many performance monitoring tools hard to use. Visual Studio 2010’s Performance Profiler can get you the information you need without making you learn to be a DBA.]]>William SheldonMon, 27 Sep 2010 15:54:00 GMThttp://www.sqlmag.com/article/troubleshooting/using-performance-profiler-to-troubleshoot-ado-net-applicationshttp://www.sqlmag.com/article/developer/sidebar-creating-a-sample-application-for-performance-profiler
By William Sheldon
If you’re a developer but not a DBA, you might find many performance monitoring tools hard to use. Visual Studio 2010’s Performance Profiler can get you the information you need without making you learn to be a DBA.]]>William SheldonWed, 22 Sep 2010 15:59:00 GMThttp://www.sqlmag.com/article/developer/sidebar-creating-a-sample-application-for-performance-profilerhttp://www.sqlmag.com/article/aspnet/review-devexpress-asp-net-controls
By William Sheldon
This suite of add-ons for Visual Studio will help you quickly populate a grid, chart, or similar ASP.NET web page with data.]]>William SheldonTue, 20 Jul 2010 10:31:00 GMThttp://www.sqlmag.com/article/aspnet/review-devexpress-asp-net-controlshttp://www.sqlmag.com/article/security/securing-your-sql-server-environment
By William Sheldon
Locking down your database environment can be a difficult task, but it doesn’t have to be. Learn how to protect your databases by using service accounts and encryption to secure your database files and network.]]>William SheldonWed, 14 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/security/securing-your-sql-server-environmenthttp://www.sqlmag.com/article/tsql3/sql-scripter-2-0-
By William Sheldon
Create T-SQL scripts to run on target systems for exporting table data to remote clients.]]>William SheldonTue, 23 Dec 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/sql-scripter-2-0-http://www.sqlmag.com/article/testing5/rowgen-2-0
By William Sheldon
Use RowGen 2.0 to create referentially valid but random sample data that you can use in your test environment.]]>William SheldonThu, 30 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/testing5/rowgen-2-0http://www.sqlmag.com/article/net-framework2/building-a-custom-application-with-adomd-net
By William Sheldon
Draw upon your ADO.NET skills to start using ADOMD.NET]]>William SheldonMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/net-framework2/building-a-custom-application-with-adomd-nethttp://www.sqlmag.com/article/tsql3/mdx-queries
By William Sheldon
Take advantage of your T-SQL skills to learn MDX query basics.]]>William SheldonMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/mdx-querieshttp://www.sqlmag.com/article/database-development/using-sql-server-management-studio-2005-to-build-mdx-queries
By William Sheldon
See how to build an MDX query against a cube.]]>William SheldonMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/database-development/using-sql-server-management-studio-2005-to-build-mdx-querieshttp://www.sqlmag.com/article/c3/linq-to-your-sql-server-data
By William Sheldon
Build efficient queries using LINQ, which is included in Visual Studio 2008.]]>William SheldonFri, 28 Mar 2008 00:00:00 GMThttp://www.sqlmag.com/article/c3/linq-to-your-sql-server-datahttp://www.sqlmag.com/article/net-framework2/an-ado-data-binding-primer
By William Sheldon
There are commonalities between the different forms of data binding. This article’s focus on simple Windows Forms and ASP.NET examples provides a great introduction to data binding while running through some best practices.]]>William SheldonThu, 25 Oct 2007 00:00:00 GMThttp://www.sqlmag.com/article/net-framework2/an-ado-data-binding-primerhttp://www.sqlmag.com/article/xml/must-have-xml-tools
By William Sheldon
XML tool suites from Altova and DataDirect Technologies are both excellent for XML editing and XML Web services support.]]>William SheldonThu, 21 Jun 2007 00:00:00 GMThttp://www.sqlmag.com/article/xml/must-have-xml-toolshttp://www.sqlmag.com/article/visual-studio-20052/filling-a-green-field
By William Sheldon
Today’s green field is tomorrow’s green swamp. Although rewriting code from scratch might seem easier, learn why you should do it in only rare cases.]]>William SheldonFri, 06 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/visual-studio-20052/filling-a-green-fieldhttp://www.sqlmag.com/article/com-and-com/-net-now-positioned-to-replace-com
By William Sheldon
When Microsoft introduced its .NET technology, there were many discussions about whether this was a sign of the end of COM. At the time, most people concluded that it wasn’t the end for COM. However, the mind-set is changing.]]>William SheldonThu, 05 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/com-and-com/-net-now-positioned-to-replace-comhttp://www.sqlmag.com/article/visual-studio-20052/two-sides-of-the-same-coin
By William Sheldon
People have had both good and bad experiences with merging changes in Team Foundation Server (TFS). If your experiences have been bad, here’s how you can prevent problems. ]]>William SheldonThu, 05 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/visual-studio-20052/two-sides-of-the-same-coin