Recommended Articles for a Developer – 023

SQL Server and Business Intelligence


SQL Server

Handling NULL in T-SQL – CodeProject
Compare SQL Server Performance of In-Memory vs Disk Tables
Exploring Your SQL Server Databases with T-SQL
Stairway to SQL Server Security Level 4: Permissions – SQLServerCentral
How to Get SQL Column Values as Comma Separated String using XML Path Method – CodeProject
Memory Corruptions, or Why You Need DBCC CHECKDB – SQLServerCentral
Get Ready to Learn SQL Server: What is a Database NULL Value? – CodeProject
Get Ready to Learn SQL: 5. Query Results Using Pattern Matching – CodeProject

Indexes and Tuning

Sargable query in SQL server. – CodeProject
Drop and Re-Create All Foreign Key Constraints in SQL Server

Stored Procedures, Triggers, Functions

Using SqlParameter Direction in C#.Net with with Stored Procedure – CodeProject

Database Administration

Business Intelligence

Starting as a SQL Server Business Intelligence Developer

SQL Server Integration Services

Use SSIS to send emails – SQLServerCentral