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
410
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...
320
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...
780
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
270
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
1040
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
410