Invoke-SqlCmd and error results

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

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

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