Global Cursors

DB_Owner Querying for Database Options

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Naming Confusion

The naming of systems and other technological constructs is always a debate within groups. Steve Jones points out a few places where this might actually prevent mistakes.

Default Endpoint Encryption

Controlling Alerts

Being on call is not much fun for anyone, but it can certainly be hard on those that receive lots of calls for systemic issues. Are there better ways to manage this?

PostgreSQL v SQL Server

A site that’s a comparison of the platforms.
http://www.pg-versus-ms.com/
Certainly some good arguments being made, but (admittedly) biased towards specific workload items...

Columnstore efficiencies

Awareness

This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.

Testing Simple Calculations and UDFs with tSQLt

This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...