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...

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?...

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...

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...

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,...

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...

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...

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...

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,...

Date: 08/03/2016

PowerShell and Control-M

PowerShell is the best scripting tool for various tasks of Microsoft products, Control-M is one...

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...

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...

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...

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...

Date: 07/09/2016