T-SQL BEST Practices
In this article, we will discover some best practices of T-SQL queries. Badly written queries can...
50 Shades of Oracle Database Certification Exam
In this article, I would like to talk about one of the basic certifications from Oracle – Oracle Database SQL Certified Expert....
Tricky Questions about C#
Some questions may seem too basic, but they still contain tiny tricks. Sometimes even a simple question may nail to the wall. These...
Preparing for Exam 70-483: Programming in C#
During preparation for exam 70-483, I found lots of websites containing links to various manuals...
Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL
Read Uncommitted If data is being changed in one transaction, selection of this data (in other transaction or without a transaction) will...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
XML performance tips
Parsing data from XML using XQuery is a routine practice. In order to do this most effectively,...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
