Category Archives: Databases

Everything related to databases. We love data and yes we love our databases too. Anything we do that relates to databases can be found here.

Masking Data prior to SQL 2016

By | November 1, 2020

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 data masking was introduced in Microsoft SQL server version 2016. However for older versions of SQL server there are primarily just a few variations of same approach… Read More »

How to analyze a Presidential debate?

By | October 18, 2020

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 kind of activity using a different approach which will be detailed below. The intention of this post is not to support or negate any candidate. It is… Read More »

Azure Data Sync Issues

By | October 2, 2020

  Azure data sync is a great tool for those people looking for a quick and easy way to move data from on premise systems to the cloud. It works great when you have a fairly simple table structure and no transformations before the data is ready to load to the destination. Recently we came… Read More »

Securing SQL Server – Dynamic Data Masking

By | September 22, 2020

In this video we cover the feature Dynamic Data Masking. While technically a security feature DDM can be easily bypassed and therefore is often used in conjunction with other features like encryption. It adds a layer of masking on the final output and as such can be bypassed easily by rewriting the query as demonstrated… Read More »

Microsoft SQL Server Security: – Defense in Depth Series

By | September 8, 2020

In this series we cover all the different ways you can protect your Microsoft SQL Server database from attacks. We cover the methodology being used to secure databases. When and how to use them and certain pitfalls. https://www.youtube.com/watch?v=aITXHwWHXJw&feature=youtu.be The series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent Data EncryptionBackup… Read More »

Microsoft SQL Server Security: – Defense in Depth Series

By | September 8, 2020

In this series we cover all the different ways you can protect your Microsoft SQL Server database from attacks. We cover the methodology being used to secure databases. When and how to use them and certain pitfalls. https://www.youtube.com/watch?v=aITXHwWHXJw&feature=youtu.be The series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent Data EncryptionBackup… Read More »

When does SQL Server Cache an execution plan?

By | August 4, 2020

Ever wondered under what circumstances SQL Server cache an execution plan. What is the difference between simple and forced parametrization. What are the disadvantages of plans being cached? Should I recompile a procedure or are there other options. How does plan caching differ between Adhoc queries vs stored procedure. How does single use plans eat… Read More »

Visual Studio – The process cannot access the file because it is being used by another process

By | July 20, 2020

  Severity  Code  Description  Project  File  Line  Suppression State  Error    Cannot delete the file “C:\……t\LoadExcelFiles.ispac”: The process cannot access the file ‘C:\…..LoadExcelFiles.ispac’ because it is being used by another process..     0      The above error common message that we encounter when working on SSIS packages in Visual Studio. The message itself… Read More »