Don’t trust Invoke-SqlCmd and error results

Don’t trust Invoke-SqlCmd and error results
I love to call Invoke-sqlcmd from powershell but one must beware of the risk of...

Terminate a SSIS package after specific time interval.

Terminate a SSIS package after specific time interval.
 
There are several ways you can execute scheduled SSIS package/job they are: 

A)     SQL...

Run DBCC CHECKDB on a regular basis

Problem One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption...

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...