Blog - SQL Programmers

LINQ LINQ is an acronym for the Language Integrated Query which was released in 2007 as a part of framework 3.5. It helps to query data in .NET supported language. It defines a set of Standard Query Operators to get data from the different... read more

The command pattern is a design pattern that enables all of the information for a request to be contained within a single object. The command pattern is a behavioral pattern that controls the communication between classes or entities. The command ... read more

The singleton pattern is a popular solution to common problems in software design. The singleton design pattern implements the effective instance management and the class should have only one instance. The Singleton design pattern can be used ... read more

One type of index used within SQL Server databases is the Full Text Index. The Full Text Index differs from other indexes commonly used within a database (Ex. Clustered Indexes) in that it can be used to perform complex keyword searches against... read more

This article is a step by step instructional tutorial that will walk you through setting up Visual Studio 2010 to debug through a web site that has SSL installed.

... read more

Today’s topic focuses on a new user-defined object in SQL Server 2012 called Sequence. A Sequence object shares similar functionality as an identity column but with a couple big differences.

... read more

When developing or providing support for a data driven application, sometimes you need to know what stored procedures or other database objects reference a specific table column or table name.

... read more

I will be taking you through creating a very simple logon screen using LINQ to SQL.

Create the Data Layer

•    Create your tables in the database
•    Create the stored procedure you will use to get the logon count from SQL
 

... read more

 In order to reuse or simplify part of code, it’s common to break down your stored procedure into multiple smaller stored procedures and call them as nested stored procedures.  In most of the cases, your original stored procedure affects the content of the database. In order to make sure that the database is still consistent in case something unexpected occurs, the best solution is to use transactions and proper error handling.

... read more

With SQL Server 2012 currently available for download as a Release Candidate and an official launch coming early this year, now is a better time than ever to start learning about some of the new features it offers.

... read more