Latest SQL Server Articles

Sub Queries and Sub Tables in SQL and VB

By Hannes Du Preez - Published 08/24/2015

Learn more about sub queries and sub queries, and, more importantly, how to use them with Visual Basic.

Making Use of SQL Variables

By Hannes Du Preez - Published 08/10/2015

Learn about SQL Variables and how to use them from Visual Basic.

Solving Performance Issues in Data Migration to SQL Server

By Phani Krishna Kollapur Gandla - Published 12/07/2011

Learn how to solve reoccurring performance problems during data migration to SQL Server.

SQL CLR Integration in SQL Server 2008

By Paul Kimmel - Published 12/14/2010

Is some of your business logic in code and some in SQL Server? Then, just call the SQL from the .NET framework and the .NET framework from SQL with CLR integration. Here are all the steps you need to get started.

Working with Dundas Charts in SQL Server Reporting Service

By Tapas Pal - Published 08/23/2010

Learn to leverage the power of Dundas Charts in your next SQL Server project.

Basics of SQL Server 2008 Locking

By Jani Jarvinen - Published 05/13/2010

Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.