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

Azure Portal Enhancements – Switching Accounts

More and more I am impressed on the Azure Portal.  Microsoft continues to make enhancements to the user interface (UI)...

What is the Max Degree of Parallelism setting for SQL Server?

Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server.  What exactly does...

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

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

File Maintenance – Cleaning Up Old Files

Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...

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

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