Tag: tips and tricks

T-SQL BEST Practices

Languages & Coding, T-SQL • 3 Comments

In this article, we will discover some best practices of T-SQL queries. Badly written queries can...
Read More

50 Shades of Oracle Database Certification Exam

Database development

In this article, I would like to talk about one of the basic certifications from Oracle – Oracle Database SQL Certified Expert....
Read More

Tricky Questions about C#

Basics of C#, Languages & Coding • 3 Comments

Some questions may seem too basic, but they still contain tiny tricks. Sometimes even a simple question may nail to the wall. These...
Read More

Preparing for Exam 70-483: Programming in C#

Basics of C#, Languages & Coding

During preparation for exam 70-483, I found lots of websites containing links to various manuals...
Read More

Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

Database administation, Security

Read Uncommitted If data is being changed in one transaction, selection of this data (in other transaction or without a transaction) will...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Read More

XML performance tips

Database administation, Perfomance Tuning

Parsing data from XML using XQuery is a routine practice. In order to do this most effectively,...
Read More

Retrieving SQL Server Metadata with Help of T-SQL

Languages & Coding, T-SQL • 2 Comments

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
Read More