Recommended Articles for a Developer – 018

SQL Server and BI

SQL Server + C#: SELECT, INSERT, DELETE and UPDATE queries and stored procedures – CodeProject
Data Mining Introduction Part 2 – SQLServerCentral
Questions about T-SQL Expressions You Were Too Shy to Ask
Stairway to T-SQL DML Level 12: Using the MERGE Statement – SQLServerCentral
Differences Between Various Joins in MS SQL Server – CodeProject
The Best Database Administrators Automate Everything – SQLServerCentral
SQL Server – What Exactly is COALESCE Function? – CodeProject
SQL Server SQLCMD Basics
SQL Server SEQUENCE Basics
Learn Microsoft Business intelligence step by step – Day 1 – CodeProject
Learn Microsoft Business intelligence step by step – Day 2 – CodeProject
SQL Server Query Tuning
SQL Server Covering Index
SQL Server's FORMAT() function – CodeProject
Are You Using SQL PIVOT Yet? You Should! | Javalobby
Column Store Indexes in SQL Server 2012 – CodeProject
Practical Uses for Synonyms in SQL Server – SQLServerCentral
Splitting Strings Based on Patterns – SQLServerCentral
Awesome SQL Trick: Constraints on Views | Java Code Geeks
Basic SQL Queries for Beginners – CodeProject
TRUNCATE or DELETE a Table? – CodeProject
Comparing SQL Server Datatypes, Size and Performance for Storing Numbers
All About SSIS Variables Part 3 Variable Assignment – CodeProject
Template to Handle Error in SQL Server – CodeProject