Generate list of all Month name

DECLARE @year INT
SET @year = 2016

;WITH months AS(
    SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01')  AS monthname
    UNION ALL
 ...

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of...

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of code quality and having a statement covered by a...

Unix Basic Commands

In similar context to my previous blog I'm providing a list of UNIX basic commands which you may find handy...

Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...

XP_CmdShell isn’t Evil

Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...