Filip Holub
- Jan 13, 2017
- 1 min
How to change SQL Server Authentication Mode?
SQL Server use two Authentication mode: • Windows Authentication mode - For connect to Server is used currently logged user in Operation Sys
390
Filip Holub
- Jan 11, 2017
- 1 min
Add New FileGroups and Files in Database
This post will be about FileGroups. FileGroups contain few database (.ndf) which is very good. For example for performance, separate...
310
Filip Holub
- Jan 8, 2017
- 1 min
Migrate Logins to another Server
Hello guys, Today I want to show you one way how to migrate logins to another server. I built new testing environment at work and I...
750
Filip Holub
- Jan 6, 2017
- 1 min
How to Find duplicate Records?
If someone want to find out duplicate rows can use this SELECT statement! When SELECT displays same records, you can use this DELETE stateme
260
Filip Holub
- Jan 5, 2017
- 1 min
How to Drop All Databases of instance?
I needed delete all databases on Instance, therefore I wrote my favorite Cursor, in this case is very easy cursor, because for delete databa
1030
Filip Holub
- Jan 4, 2017
- 1 min
The Process of Backup
In previous post I wrote about Backuping and his performance. When start process of Backup, you can find out few things, for example Start t
380
Filip Holub
- Jan 3, 2017
- 1 min
Daily use in Management Studio - #2 Template Browser
Another useful thing you use every day is Template Browser. In Template Browser are saved templates of Create table, Createlogin, Create dat
360
Filip Holub
- Jan 1, 2017
- 2 min
How to improve the performance of database backup?
Today I will show you some examples backuping databases. You will see four examples with different parameters. I chose sample database "
750
