Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...

The Good, the Bad and the Ugly SQL Cursor types

T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...

SQL Azure – simple description, part I.

I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...

T-SQL refactoring

Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...

Fastest row counting method

SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...

Partial name matching in SQL Server 2011 “Denali”

While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There...

Article: How to use temporary table in function

Steve Jones from voiceofthedba.com, editor on SQLServerCentral.com gave me an opportunity to publish humble article about workaround solution for using...

Custom folders SSMS Add-In slightly delayed

I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...

SQL Injection is still actual :)

Here are two samples showing that SQL Injection is still here and dangerous !!!

source:xkcd.com

This use case is especially insidious

Tracking table changes seamlessly with Change Data Capture (CDC)

I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...