SQL Server Data Table as CRM Data Source on VBA Form

Using SQL SERVER Database as Data Source
FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.

Performance Comparison Between SQL Server 2014 and 2016

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.

Restrictions to use DBCC CLONEDATABASE

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.

SQL Server 2014 Service Pack 2 is Available

SP2 for SQL Server 2014 is now out. Check out the build list.

CU#6 for SQL Server 2014 SP1 Updated

Please re-apply CU#6 for SQL Server 2014 SP1 as it has been updated.

A Review of rsNeatPublish

rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects

Data Files on Azure

In-Memory OLTP Table Checkpoint Processes Performance Comparison

The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.