Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to...

FIND OBJECTS BEING REFERRED BY SSRS REPORT

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...

MDF File Password Confusion

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post...

MongoDB -Get Size, RowCount, CollectionSize

There are two different ways of getting the desired result
The first method is iterating through each collection using for loop...

Pulling Security Info

A frequent request I receive is to pull a list of logins/users with certain accesses, role memberships, etc.
I had a...

SSC Editorial: Would You Move for a Job?

I won’t say never, but it’s unlikely I’d move for a job – my roots are here in Orlando and I...

Use PowerShell to script existing Availability Group creation scripts!

Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...

Ben Miller Speaking to oPASS & MagicPASS on April 19, 2016

Register to attend this joint chapter meeting at https://www.eventbrite.com/e/opassmagicpass-joint-april-meeting-w-ben-miller-tickets-24457339561.
OPASS and MagicPASS are proud to present a special joint meeting with Ben...

Goodness-of-Fit Testing with SQL Server Part 7.1: The Kolmogorov-Smirnov and Kuiper’s Tests

By Steve Bolton
…………“The names statisticians use for non-parametric analyses are misnomers too, in my opinion: Kruskal-Wallis tests and Kolmogorov-Smirnov statistics,...

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