What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions and […]
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Database in Suspect: – DBCC CHECKDB – It has been marked suspect by recovery
A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why […]
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 […]
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 […]
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 […]
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 […]