One of the new feature that’s being developed with SQL Server 2016. If you are a DBA then you will like this feature very much. In the real world when you move the data from production to development or uat server we are supposed to obfuscate the data so that the developer wont see the actual live data. Till SQL Server 2016 we are achieving this with dynamic DML scripts which will mask the data. Based on the volume of records in the database we will end up long wait hours to obfuscate it. Continue reading “SQL Server 2016 – Dynamic Data Masking”
I was working on a SSIS package in SQL 2014 which was working there without any issues. Due to few factors we need to downgrade to work in SQL Server 2008 R2 for few months. I developed the packages in SQL 2008 BIDS and deployed. No changes done to any of the database objects as I thought I’m going to use the same in my package as well. Continue reading “SSIS Error Code 0xC02092B4”
I was working on one the project and they were looking for a backup report which should specify whether it’s physical or logical and few more details. Whatever data I fetched looks good and I felt the same can be helpful for you guys to pull it as a report. If you need any more additions to it please let me know. Continue reading “Backup Report”
After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release. Continue reading “SQL Server 2016 – Tempdb Configuration During Installation”
There are lot of scripts available in the internet to find orphan users across the database.
This will be my version fo script to find out orphan users in all the databases excluding system databases. Continue reading “Identify Orphan Users in All the databases”