MongoDB – Local and Remote Connections in Mongo Shell
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
516 reads
PowerSQL By Prashanth Jayaram
MongoDB -Calculating Collection Size
Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...
2016-04-05
618 reads
MongoDB – Calculating Document Size
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
526 reads
Simple Methods to Recover master.mdf File Password
Overview
MS SQL Server is the relational database management system used to store information in form of tables, views, indexes, triggers,...
2016-03-18 (first published: 2016-03-15)
4,666 reads
Different ways to find Data, log and DB Size
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,097 reads
Get the Total Item Size for an Exchange database
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
743 reads
Find failed SQL Job in last 24 Hours using Powershell
This post is based on the request to get failed SQL jobs in last 24 hours and output should be...
2016-03-02
657 reads
PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file
Problem Statement
The requirement is to backup individual database and after successful backup the script should retain the most recent file...
2016-03-09 (first published: 2016-02-29)
2,123 reads
SQL – List Server and DB Permsission
Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...
2016-02-24
624 reads
PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
604 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...
EXTENDED EVENTS Track What's Logging In
Simple one looking for a script that can track what's logging in from where...
Proc cache slowly decreasing in size until restart is required
In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The...