SQL Shack round – up – December 16th, 2014 – 5 new articles including Bulk loading Spreadsheets, untended installation, Buffer Pool extension, and more

In the latest SQL Shack articles, we wrote about: bulk loading multiple Excel spreadsheets, continuous data loading, the Buffer Pool extension, continuous data loading, and unattended SQL Server installation, and presented a technique to maximize usage of your data and report real estate

A nifty technique for bulk loading the data for multiple Excel spreadsheets into your production – Excel in loading multiple workbooks into SQL Server

Handle continuous data loading throughout the day with minimal strain on resources – Have your jobs really processed all the data

Maximize usage of your data and report real estate without making the report look cluttered – Now you see it, now you don’t

The Buffer Pool Extension came to build up a new layer of cache. Explore the aspects of this feature – Buffer Pool Extension (BPE) – Introduction to the Buffer Pool

Deploy SQL Server instances without going through the installation wizard with a simple command – Unattended installation of SQL Server

Related posts:

  1. SQL Shack round – up – December 31st, 2014 – 14 new articles including SSRS, auditing, transaction log, Buffer Pool extension, and more
  2. SQL Shack round – up – January 16th , 2015 – 4 new articles including data security, database deployment, DAX, and SMB fileshare
  3. Knowledgebase and troubleshooting articles round-up – December 16th , 2014
  4. SQL Shack round – up –February 3rd, 2015 – 7 new articles including data mining, Hekaton, and more
  5. SQL Shack round – up – November 19th, 2014 – Loading data from SharePoint, Slipstreaming SQL Server, and Reporting Services
December 16, 2014