SQL Server and Business Intelligence
Articles
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