In this post we are going to see how to schedule a database backup operation in SQL Server. Follow the next steps to begin. Start SQL Server Management Studio. In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list. Click Connect. In Object …
As the General Data Protection Regulation (GDPR) is in effect tomorrow, I am getting rid of all personal data from our development databases. However for some databases just deleting users in not an option, so I am replacing all the data with dummy values. I wrote a little script which …
There are those times that you need to backup all you MS SQL databases quickly. If you need to do it all at once here is a script that will help you accomplish that. Step 1: Create the path specified in the path variable or choose your own Step 2: …
The General Data Protection Regulation (GDPR) will be in effect on May 25 2018 and it will change fundamentally the way we manage data. Microsoft SQL-based technologies offer many built-in security capabilities that will help us address the GDPR requirements and improve the way we manage and secure data. Download and …
