By William Sheldon, 03/21/2012
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 ...
By William Sheldon, 02/24/2012
Although Visual Studio LightSwitch uses the same development environment as other Microsoft .NET development tools, it takes a very different approach to application development.
By William Sheldon, 12/15/2011
If you're looking for ASP.NET rapid application development (RAD) controls, Telerik's RadControls suite is an excellent choice.
By Sheldon, William, 09/23/2011
Although this package has the term OLAP in its name, it doesn’t work with multidimensional data.
By William Sheldon, 10/25/2010
LINQ is still a powerful tool for working with SQL Server data and includes new features such as Parallel LINQ (PLINQ) and SharePoint integration.
By William Sheldon, 09/27/2010
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 ...
By William Sheldon, 09/22/2010
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 ...
By William Sheldon, 07/20/2010
This suite of add-ons for Visual Studio will help you quickly populate a grid, chart, or similar ASP.NET web page with data.
By William Sheldon, 10/14/2009
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 ...
By William Sheldon, 12/23/2008
Create T-SQL scripts to run on target systems for exporting table data to remote clients.
By William Sheldon, 10/30/2008
Use RowGen 2.0 to create referentially valid but random sample data that you can use in your test environment.
By William Sheldon, 09/29/2008
Draw upon your ADO.NET skills to start using ADOMD.NET
By William Sheldon, 09/29/2008
Take advantage of your T-SQL skills to learn MDX query basics.
By William Sheldon, 09/29/2008
See how to build an MDX query against a cube.
By William Sheldon, 03/28/2008
Build efficient queries using LINQ, which is included in Visual Studio 2008.
By William Sheldon, 10/25/2007
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 ...
By William Sheldon, 06/21/2007
XML tool suites from Altova and DataDirect Technologies are both excellent for XML editing and XML Web services support.
By William Sheldon, 10/06/2006
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.
By William Sheldon, 10/05/2006
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 ...
By William Sheldon, 10/05/2006
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.