Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...

How to Write a Better T-SQL Code

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...

Symmetric Except

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.

Some New Cool Features in SSMS

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...

Using Time Zones in SQL Server

The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...

RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...

RegEx in SQL Server for searching text

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding...

Microsoft Certified Trainer!

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...

Multiple usage of functions to ensure “value” is not null? – NO

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...