SQL Server Policy Based Management Alerts

SQL Server Policy Based Management Alerts

Problem

Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...

Running a document database on Sql Server

Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...

Unwanted dependency between different parts of the code

Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...

JSON and the NoSQL “advantage” over SQL Server

First what is JSON?

JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...

Don’t Pass Null

I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each...

A new neat feature in SQL Server 2012 is THROW

In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)

One of...

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)

When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?

One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.

When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...