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
390
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...
310
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...
750
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
260
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
1030
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
380
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
360
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 "
750
