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

Securing SQL Server: – Transparent Data Encryption -TDE

https://youtu.be/iDfH7dKEFto In this video we cover TDE or transparent data encryption. It is a feature that allows the DBA to protect files in the disk such as MDF, LDF and NDF. It doesn’t prevent the DBA from viewing the data. But it does protect the database from being restored on an unauthorized server where other…

Azure Data Sync Issues

  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…

Securing SQL Server – Principal of least Privileges

In this second video of the series we cover “Principle of least privileges”. It means we grant only the minimum required permission to any account. We explore how to grant these permissions and also how once granted, bad coding practices and carelessness can undo all the hard work in one swoop. This is one of…

Securing SQL Server – Dynamic Data Masking

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…

Microsoft SQL Server Security: – Defense in Depth Series

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 Defense in DepthThe series covers the following concepts Principle of least privilegesDynamic Data MaskingRow Level SecurityAlways EncryptedTransparent…

FREE PowerBI session – Batch 2

It’s time for the next batch of PowerBI Sessions. This is a 3 hour free PowerBI Session for those whose careers have been affected by #Covid or those who feel their careers have slowed down in recent years and would like a relevant in demand skill. In this session we will be creating the below…

Introduction to PowerBI

The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities are hampered by the lack of a particular skill I would like to help by providing a 3 hour introductory course to PowerBI. Why PowerBI? It’s almost…

Introduction to PowerBI

The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities are hampered by the lack of a particular skill I would like to help by providing a 3 hour introductory course to PowerBI. Why PowerBI? It’s almost…

When does SQL Server Cache an execution plan?

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…

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

  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…

29 DAX Functions you must know

PowerBI has been the preferred BI tool for a large number of companies in recent times. As the tools get adopted we have seen a number of reporting scenarios from Basic excel porting to complex Machine Learning models. Regardless of how you plan to utilize PowerBI it is important to learn and understand the DAX…

PowerBI DAX – VAR

A very useful way to work with DAX functions is to use VAR. VAR is a form of variable in which results can be stored temporarily without having to create measures and then using them in others. For example you use Var to store the result of a particular group and then use the var…

PowerBI DAX- USERNAME

This is a function that may not be used as frequently as it used to be but it is likely you will encounter it in older PowerBI Reports where RLS or row level security was implemented. The function returns the username of the user currently viewing the report. Using this information and mapping it against…