Articles having tag: SQL

MBColorPicker User Control Using VB.NET 2008

By Manoj K Bhoir

A graphical interface to select a color from a set of various colors.

How to continue a for each loop container even if its inner tasks fails (Propogate)

By Smitha_Prabith

How can we configure our foreach loop container, even when the task inside it failed

Snippet and Surround features in SQL Server 2012

By Tigya

Snippet and Surround features in SQL Server 2012.

Getting started with Web 2.0 using Wakanda

By saadmos

You aren't familiar with Web 2.0 development ? Wakanda is free, Open Source, and easy to learn, so after reading this article you'll be able to develop a Web 2.0 app whitout coding HTML5 ,CSS3, or SQL. ;)

Applying Running Total to a Result set

By Mika Wendelius

This is an alternative for "Applying Running Total to a Result set"

Populating a business logical layer from stored procedures

By andrewbb

A brief look at a technique mapping tables to a basic business layer.

SQL - Now you see me, now you don't

By Programm3r

ISNULL - COALESCE

Transform column values in to a rows

By Chamila Ranasinghe

Following article describes how to transform column values in to rows

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats « SQL Server Journey with SQL Authority

As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about \xa0SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you have yet not caught up on that subject. After the blog...

SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services « SQL Server Journey with SQL Authority

Data modeling is the most important task for any BI professional. Matter of the fact, the biggest challenge is to\xa0organizing disparate data into an analytic model that effectively and efficiently supports the reporting and analysis.\xa0SQL Server 2012 introduces...