Filip Holub
- Dec 29, 2016
- 1 min
Daily use in Management Studio - #1 Registered Servers
In the Management Studio exists "Registered Servers" - For someone it can be very helpful thing. I use it at work every day! It ca
460
Filip Holub
- Dec 23, 2016
- 1 min
Grant User Access to All Databases
This article can help those who need to grant permissions for existing user to any database (except systems databases). You can use my...
2,6220
Filip Holub
- Dec 23, 2016
- 2 min
How to Create Database?
Every Database administrator ever created database. It is very simple task, but you have to know what you set up, because it can affect data
370
Filip Holub
- Dec 20, 2016
- 1 min
How to Change Recovery Model to Simple or Full for All Users databases?
If you have ten or more databases in recovery model "Simple" and you want to change to "Full" because of backuping Logs
3940
Filip Holub
- Dec 20, 2016
- 1 min
Backup All Users databases via Select and Cursor!
In this post I will write about: How to back up all user databases? One day at work I dealt with Sharepoint, I needed to install new updates
2100
Filip Holub
- Dec 20, 2016
- 1 min
How to change the default backup location in MS SQL 2016?
It's very easy task for us! After default installation of new SQL Server 2016 is directory for BackUp files here: "C:\Program Files
9790