Filip Holub
Feb 19, 20171 min read
How to Get Owner of Job in SQL Server?
There are two ways how to find out owner of job. First way is open every job and look at owner, if you have 250 jobs it may take a long time
1220
Filip Holub
Feb 16, 20171 min read
How to take Differential Backup for all user database?
This scritp you can use if you need to take differential backup for all user databases of instance. Script below exclude system...
1760
Filip Holub
Feb 14, 20171 min read
List All permissions in the database!
This query will show you all permissions for whole database!
850
Filip Holub
Feb 12, 20171 min read
How to disable Data Compression on tables in whole database in SQL Server 2008R2?
If you restore database from enterprise edition to Standard edition and you have enabled "Data compression" on table, restoration
3,9760
Filip Holub
Feb 9, 20171 min read
Data Migration Assistant
Data Migration Assistant (DMA) is tool for detects compatibility issue that can impact database functionality on your new version of SQL. Da
870
Filip Holub
Feb 7, 20171 min read
How to identify Index Fragmentation?
If you want to find out fragmentation of index your database you have several options. In my case is the best Dynamic Management View "
430
Filip Holub
Feb 6, 20171 min read
DBCC CLONEDATABASE in SQL 2016 SP1
Service Pack 1 in SQL Server 2016 introduces new management command "DBCC CLONEDATABASE". This command will generate a schema and
670
Filip Holub
Feb 3, 20171 min read
How to Backup and Restore File Group?
Today, I would like to show you how to backup and restore File Group. For this action I prefer using T-SQL, because for me it's faster a
400
