My blog about SQL Server
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right click on a database Tasks -> Vulnerability Assessment -> Scan For Continue reading Some New Cool Features in SSMS
Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple
|
1 2 3 |
DBCC CLONEDATABASE (source_database_name, target_database_name) |
For example the next command
|
1 2 3 |
DBCC CLONEDATABASE (AdventureWorks2014, AdventureWorks2014_Clone) |
will create database AdventureWorks2014_Clone with Continue reading Database cloning – CLONEDATABASE
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log pages as well as the information for the transaction log. Detailed Continue reading Target Recovery Interval and Indirect Checkpoint
This post examines the compression of a database named Bankware (BW) at a client site. The database size was 300+ GB. The tests for BW were done on the sk-bankware server aimed for the ART (Accounting, Reporting and Treasury) applications in the Continue reading Data compression