Articles having tag: SQL

What do you use for Database Source Control?

By Red Gate Software

Article about Red Gate's SQL Source Control

Building an N-Tier Application in VB.NET, in 8 Steps

By Vuyiswa Maseko

This Article will show you how to Build an N-Tier Application in VB.NET

Get Top X rows from a table

By Mahmud Hasan

How to use variable in SELECT TOP sql command

Get Client IP Address in SQL Server

By Sarvesh Kumar Gupta

How to get the client IP address in SQL Server.

Configuring SQL Server Accent-Insensitivity

By Daniel Miller

This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

Database Object Model

By databaseobjectmodel

A Sample ORM project

Read contents of a file to variable – SSIS

Sometimes you will find the need to import a file to a variable using SSIS. In this post, I'll use Script Task to read contents of a flat file into a variable.

OPENROWSET (T-SQL) – Sometimes You Have to Stop and Smell the Roses

Ever been in the situation where you're so fixated on debugging an error that you fail to see the solution which has been staring you in the face the whole time? Me too. The other day I was trying to import data from an Excel spreadsheet into a SQL Server...

SSIS Tutorial - Getting started with SSIS - Part 6: Import Export Wizard Part 1 - Sudeep Raj

As I mentioned in the last chapter, we will look into our very first SSIS package. There are multiple ways to build an SSIS package. The simplest way to do so is Import export wizard. You can start the SQL Server Import & Export wizard by various ways....