SQL Hammer

Fast, light-weight, row counts

Often we need to know the number of records in a table. If you are looking for something very specific, such as the number of non-NULL values in a particular column, learn how to use COUNT() correctly with this post…

Synchronizing Server Objects for Availability Groups

After we create a strategy for synchronizing our data for disaster recovery, we then need to consider keeping our server objects synchronized. Depending upon which objects you are working with there are various solutions available to you. xp_help_revlogin (2005 and…

It is who you know, or is it?

I have spent a lot of time learning about how to effectively network and the benefits that it can bring to my life and career. What I find interesting, however, is that there is a negative connotation revolving around the good ol’…

Writing Repeatable T-SQL

Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not mean that the languages, such as T-SQL, are more difficult or that applications are any less…

SQL Server SCHEMABINDING

SCHEMABINDING is an option that is available for objects in T-SQL which contain user defined code. Examples include, stored procedures, indexes, and functions. Straight from MSDN, SCHEMABINDING… Specifies that the schema is bound to the database objects that it references….

Row Level Security in SQL Server 2016 CTP2

Earlier this year Microsoft Azure implemented Row-Level Security (Brent’s announcement). In following Microsoft’s cloud-first release concept, this great feature is now part of SQL Server 2016 CTP2, and expected to be included in the RTM version. When I first saw…