Filip Holub
Dec 29, 20161 min read
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
440
Filip Holub
Dec 23, 20161 min read
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,8950
Filip Holub
Dec 23, 20162 min read
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
350
Filip Holub
Dec 20, 20161 min read
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
4110
Filip Holub
Dec 20, 20161 min read
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
2180
Filip Holub
Dec 20, 20161 min read
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
1,1190
Filip Holub
Dec 13, 20161 min read
Kill all connections on DB by Cursor
This will be very short post, but for somebody can be very instructive and inspirational. If you want to kill all connections of one databas
1,0940
Filip Holub
Dec 12, 20161 min read
Restore databases in MS SQL 2016
In this post I will show you restore database in SQL Server 2016. As a test database I chose AdventureWorks2016CTP3 database, you can downlo
1040