SELECT *

SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...

The login is from an untrusted domain and cannot be used with Windows authentication

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been...

SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server

 Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...

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