File Maintenance – Cleaning Up Old Files

We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or...

Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday

Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before Christmas (Today!) in the United Kingdom.It is the most...

Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday

Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before...

MongoDB – DBs and Configurations

Continue to our last discussion , today we will be discussing on MongoDB default databases and more… When you install mongoDB...

Select-AzureRmProfile : The term ‘Select-AzureRmProfile’ is not recognized as the name of a cmdlet, function, script file, or operable program

I got a chance to work with PowerShell automation script to automate the login process. In the script, the profile...

SQL Server 2008 end of support

2018 is about to end. In the case you didn't know or haven't heard, the extended support for SQL Server 2008 (and R2) reaches to an end in 2019.

This...

SQL Server 2008 end of support

2018 is about to end. In the case you didn't know or haven't heard, the extended support for SQL Server...

Encrypting a Database Never Finishes

There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a...

Encrypting a Database Never Finishes

There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database.  In SQL Server, we have the ability to...

Information Measurement with SQL Server Part 4.3: Euclidean Distance and the Minkowski Family

By Steve Bolton
…………“The shortest distance between two points is a straight line.”
…………In this famous remark, Archimedes[1] (287-212 B.C.) managed to...