Technical Articles on Microsoft SQL Server 2012

Importance of Theory
Importance of Theory
Interviewing for a Code Reviewer Position
Interviewing for a Code Reviewer Position
Reviewing the Use of Types
Reviewing the Use of Types
Reviewing the Use of Functions
Reviewing the Use of Functions
Filtering and Sorting Performance Recommendations
Filtering and Sorting Performance Recommendations
Tutoring a Junior Developer
Tutoring a Junior Developer
Code Review
Code Review
Explaining Set Operators
Explaining Set Operators
Improving Data Analysis Operations
Improving Data Analysis Operations
Interviewing for a Developer Position
Interviewing for a Developer Position
Using the Semantic Search
Using the Semantic Search
Enhancing the Searches
Enhancing the Searches
Reports from XML Data
Reports from XML Data
Dynamic Schema
Dynamic Schema
Working with Table Constraints
Working with Table Constraints
Working with Unique and Default Constraints
Working with Unique and Default Constraints
Comparing Views, Inline Functions, and Synonyms
Comparing Views, Inline Functions, and Synonyms
Converting Synonyms to Other Objects
Converting Synonyms to Other Objects
Using Modifications That Support Optimized Logging
Using Modifications That Support Optimized Logging
Improving a Process That Updates Data
Improving a Process That Updates Data
Providing an Improved Solution for Generating Keys
Providing an Improved Solution for Generating Keys
Improving Modifications
Improving Modifications
Implementing Error Handling
Implementing Error Handling
Implementing Transactions
Implementing Transactions
How to search stored procedures containing a particular text
List of all Stored Procedures having particular string or text or column name in SQL Server