Weekly Roundup–SQL Server and Related News

Happy Tuesday . Here's the latest technology based blogs and articles I have been reading this week. Mainly SQL Server themed...

File Growths

I hinted at file growths in my previous posts about shrinking data and log files.  Then I talked about growing...

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

Get each table space and their rows count

Sometime we need to know how much table space are used to store the data and also wish to know...

MongoDB -Get Total datasize of all DB’s

var sum = 0; db.getMongo().getDBs()[“databases”].forEach(function(x) { sum += db.getMongo().getDB(x.name).stats().dataSize }); print(sum );

OR
db = db.getSiblingDB(“admin”);
dbs = db.runCommand({ “listDatabases”: 1 }).databases;
var sum1=0;dbs.forEach(function(database) { sum1+=db.getMongo().getDB(database.name).stats().dataSize }); print(sum1);

Query Store and Optimize For Ad Hoc

I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...

SQL Server 2005 is Now Out of Support (12 April 2016)

SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the...

Unix Basic Commands

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

VS Live 2016 – Las Vegas Follow Up

I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...

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