SQL Server in Enterprise
↑↑↓↓←→←→BA
Check the Available Memory of Default Pool
One capacity planning best practice of using SQL In-Memory OLTP engine is to bind the database with...
Author: Shiyang Qiu Date: 03/30/2017
SQL16: Database in Delete-Only Mode
What will happen when the disk of In-memory OLTP checkpoint file pair is full in SQL Server 2016?...
Author: Shiyang Qiu Date: 03/23/2017
DBCC CLONEDATABASE can not Copy Encrypted Objects
There is a new command DBCC CLONEDATABASE from latest SQL Server 2014 SP2, SQL Server 2016 SP1...
Author: Shiyang Qiu Date: 11/18/2016
SQL16 Full Backup Size Difference on Primary Replica and Secondary Replica
Database full backup could be taken from Always On Availability Groups Active Secondary with...
Author: Shiyang Qiu Date: 10/16/2016
Reporting Service Execution Log Retention
The default logging retention value is 60 days in SSRS. If you want to modify the retention period,...
Author: Shiyang Qiu Date: 09/12/2016
SQL16 Reporting Service Execution Log for Mobile Report
Update: SQL 2016 SP1 makes the change! One area of feedback we rec’d was around the inability to see...
Author: Shiyang Qiu Date: 08/31/2016
Data Warehouse, Clustered Columnstore Indexes and SAS
Clustered Columnstore Indexes (CCI) is a game changer for data warehouse workload, which is...
Author: Shiyang Qiu Date: 08/12/2016
%ErrorLevel% and $LASTEXITCODE
This is the follow-up post of the previous PowerShell and Control-M. There is one scenario I haven't...
Author: Shiyang Qiu Date: 08/10/2016
Extract all the connection strings from SSIS packages
One important task in SSIS upgrade/migration project is the assessment of data provider types,...
Author: Shiyang Qiu Date: 08/03/2016
PowerShell and Control-M
PowerShell is the best scripting tool for various tasks of Microsoft products, Control-M is one...
Author: Shiyang Qiu Date: 08/02/2016
Consideration of Hardware Resource Sharing
After the change of SQL Server license scheme, many of my customers are asking help to consolidate...
Author: Shiyang Qiu Date: 07/18/2016
SQL Performance Tuning – 3 Using MDW to T-shoot Performance Degradation
Management Data Warehouse is a great tool to create SQL Server performance baseline. Below are the...
Author: Shiyang Qiu Date: 07/17/2016
SQL Performance Tuning – 2 Accessing Data
One approach to speed up application response time is to take advantage of cache. Cache in computing...
Author: Shiyang Qiu Date: 07/11/2016
SQL Performance Tuning – 1 Overview
SQL performance tuning is a huge topic, and you need to know many detailed info of behavior with...
Author: Shiyang Qiu Date: 07/09/2016