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, […]
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 […]
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 […]
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 […]
Script for Backup Encryption
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. […]
Opportunity =Money! = Worth
We have always had to measure the worth of things. Everybody has things they want and in order to get them they need to trade. With trade came […]
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? […]
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 […]
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 […]