Visual Studio Magazine

Mastering SQL Server Indexing: What Every .NET Developer Needs to Know

At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...
Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
TechRepublic

Using Access to build a front end for SQL Server

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...