Filip Holub
Jan 13, 20171 min read
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
39
0
Filip Holub
Jan 11, 20171 min read
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...
31
0
Filip Holub
Jan 8, 20171 min read
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...
75
0
Filip Holub
Jan 6, 20171 min read
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
26
0
Filip Holub
Jan 5, 20171 min read
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
103
0
Filip Holub
Jan 4, 20171 min read
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
38
0
Filip Holub
Jan 3, 20171 min read
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
36
0
Filip Holub
Jan 1, 20172 min read
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 "
75
0
