Database Fundamentals #20: Using the JOIN Operator, Inner Join

It is entirely possible to try to JOIN two tables on almost any field, as long as the two data...

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

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

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

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

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