SQL DB Details Of Multiple Servers Using PowerShell

 
One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell...

Changing the sa Password with SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

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

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);

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

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