One of the most important things you can do to improve your Google search index ranking is to improve the load time of your website. What this means […]
Memory for Servers – Hardware
Most database administrators are at least to some extent familiar with what memory does for SQL server. This is especially true for scenarios such as configuring minimum memory in maximum memory, checkpoint, lazy […]
Create an Azure SFTP Site
Microsoft Azure has become a cloud platform of choice for everyone at this point. One of its biggest advantages has been the ability to integrate seamlessly with existing enterprise […]
Installing GitHub on VS Code
When using VS Code you will find a need for a Source Control or Version Management Software. Git is by far the most popular and free software used […]
Managing inventory in SQL Server –Part 1
A fairly important aspect of retail software is inventory management. Often this requires some kind of counter that reduces the count of stock items based on the number […]
Configuring Office 365 on Outlook 2013- when using MFA (Modern Authentication)
I recently formatted my laptop and this resulted in all the software being removed from the operating system. Normally this wouldn’t be that big a deal except I […]
Securing SQL Server: – Data Classification and Vulnerability Assessment
A big challenge with implementing security is just being able to keep track of the different tables and columns where the data is located. This features in […]
Securing Azure AD using the free stuff
One of the first things I did in 2021 was to log into Azure portal and check my Active Directory. You can imagine how much of a shock […]
Masking Data prior to SQL 2016
I was recently asked by a friend of mine what would be the best way to mask data in SQL Server. Now you may be aware that dynamic […]
How to analyze a Presidential debate?
During the last US presidential election we extracted some important critical information from the presidential debate to help profile the candidates. This year we are performing the same […]