Now that SQL Server 2014 is out – wondering how you can leverage the power of In-Memory OLTP for your applications

Take a look at this great whitepaper recently published that discusses common patterns for implementing and leveraging the new In-memory OLTP capabilities of SQL Server 2014. Download the whitepaper from: http://msdn.microsoft.com/en-us/library/dn673538.aspx In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads,…

2

SQL Server 2014 sets world record breaking performance according to TPC benchmarks

On April 16, the industry standard organization for performance benchmarking, TPC (Transaction Processing Performance Council), verified that Microsoft SQL Server 2014 broke the world record for the On-Line Transaction Processing (OLTP) workload with the TPC-E and broke multiple world records for Data warehousing (DW) with the TPC-H.  Highlights: Microsoft and HP breaks the 10TB TPC-H…

16

SQL Server 2014 Database as a Service Whitepaper

Database as a Service Reference Architecture Guide: SQL Server 2014 http://www.microsoft.com/en-us/download/confirmation.aspx?id=42321 This guide to building the infrastructure for hosting Microsoft® SQL Server® Database as a Service (DBaaS) is not limited to a particular type of hardware. By using the features of SQL Server 2014 and Hyper-V® virtual machines with Microsoft System Center 2012, a hosting…

15

SQL Server 2014 Essentials for Oracle DBAs

With the availability of SQL Server 2014 just around the corner as per my previous blog  post, it would be a good time to start training. Those of you that may have been using other flavours of SQL can now look to leverage the performance boosting in-memory capabilities of SQL Server 2014. Below is a…

11

SQL Server 2014 RTM today – Available 1st April 2014 (USA date)

SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1st 2014 (US date). SQL Server 2014 provides organisations with a data platform: Delivering breakthrough performance with In-Memory OLTP Enabling greater availability and data protection with new hybrid scenarios More customer value for mission…

1

Power BI Training

I have been getting lot of requests on what are some resources available to learn more about Power BI, as such below are some links and Microsoft partners that offer training: Online Training: Faster insights to data with Power BI – http://www.microsoftvirtualacademy.com/training-courses/faster-insights-to-data-with-power-bi-jump-start#?fbid=q8o9rTZbm6j Note: Microsoft Virtual Academy also has training available for other products its a…

4

Quickest way to deploy a Microsoft BI environment based on SharePoint – in the Windows Azure cloud

I have recently been talking to a lot of customers and partners about what is the fastest way to deploy a Microsoft BI environment leveraging SharePoint and i usually point them to the following articles on msdn which have Power Shell scripts to deploy the environment. Use PowerShell to Create a Windows Azure VM With…

11

System Center Management Packs for SQL Server 2008 & 2012 Analysis Services

The management packs for SQL Server Analysis Services 2008/2012 are now available to download from below links  System Center Management Pack for SQL Server 2012 Analysis Services  System Center Management Pack for SQL Server 2008 Analysis Services     The management packs deliver proactive and reactive monitoring capabilities for SQL Server Analysis Services (2008/2012) via…

5