Archive for September 4, 2015

SQL Server Geeks Annual Conference sessions – SSGAS 2015

September 4, 2015 Leave a comment

This year I got an opportunity to attend the SSGAS 2015 i.e. SQL Server Geeks – Annual Summit, the first time ever, large scale professional SQL Conference in India, Bangalore (KA), India, on Aug 27-29, 2015.


This was a 3 day conference organized by the SQLServerGeeks team, headed by Amit Bansal, covering sessions on Database Development, Administration, BI & Analytics, Big Data and Cloud & Azure Platform, delivered by expert speakers from Microsoft, MVP & MCM Community and Industry leaders.


I would like to share the sessions/topics I attended, their details and links to external references with my readers.

Following are the sessions I attended in the 3 day conference:

SSGAS 2015 | Day – 1

Topic Speaker Session Details & external links
SQL Server 2016, new innovations Sanjay Mishra (MSFT) Introduced various new features in SQL 2016, link.
Azure SQL Database, now & future Lara Rubbelke (MSFT) Detailed deep dive on Azure SQL database, link.
Tabular vs Multidimensional in SSAS Alberto Ferrari Details and differences between the two, link.
Business Prediction using Microsoft Azure ML Deepthi Anantharam (MSFT) Demoed a scenario on predicting income by reading different metrics, link.
Column Store Index: SQL Server 2014 & beyond Sunil Agarwal (MSFT) Detailed deep dive on ColumnStore tech, link.
Advanced SQL 2014 Reporting Tech Dr Subramani Paramasivam Detailed deep dive on Reporting Services (SSRS), and demoed how to configure Reports, connections and properties.


SSGAS 2015 | Day – 2

Topic Speaker Session Details & external links
In Memory OLTP: SQL Server 2014 and beyond Sunil Agarwal (MSFT) Detailed deep dive on In-Memory tech, link.
SQL Server Performance Tuning Amit Bansal/ Manohar Punna (SSGAS) Demoed performance tuning by using Query Store tool, a new feature of SQL 2016, link.
Analytics with Column Store Index Praveen Srivastava Discussed and demoed ColumnStore indexes, link.
Troubleshooting SQL Server Tips & Tech Amit Khandelwal/ Sumit Sarabhai (MSFT) Customer centric perf issues, creating dump by using SSDIAG & PSDIAG tools, and their dump analysis by SQL Nexus.
Query Processing in In-Memory OLTP Benjamen Nevarez (MVP) Discussed about In-Memory features in SQL 2014/2016, link.
Big Data for the SQL Ninja Scott Klein (MSFT) Demo on spinning up a new Hadoop cluster and Blob Storage on Azure.


SSGAS 2015 | Day – 3

Topic Speaker Session Details & external links
Dive into the Query Optimizer Benjamen Nevarez (MVP) Discussed QO internal and Trace flags, link.
SQL Server under attack via SQL injection Anderas Wolter (MCM) Preventing SQL Injection, link.
Operational Analytics in SQL Server Sunil Agarwal (MSFT) Real time analytics with ColumnStore, link.
Understanding Parameter Sniffing Benjamen Nevarez (MVP) Checking and resolving incorrect plans created by SQL DB engine, link.
SQL Server 2016 Stretch Database Stuart Padley (MSFT) Stretch Database demo to stretch on-prem SQL table to Azure DB, link.
Dealing with Bad Roommates – Resource Governor Joey D’Antoni (MVP) Discussed about how to manage SQL workload and system resource consumption, link.
Evangelizing SQL Server Dev paradise Mahendraprasad Dubey/ Narendra Angane (MSFT) Customer centric perf issues due to Blocks, Waits and Latches, resolving them by refactoring their SQL Code.
Social Media Sentiment Analysis using Hadoop on Windows Debcharan Skarkar (MSFT) Intro, demo.
Bursting Through the power of Datazen Slevakumar Rajakumar (MSFT) Datazen Intro, Server & Client details, vs Power BI & SSRS


Some social-networking, met with some tech-gurus:


With Scott Klien, [twitter], the Microsoft Channel9 host.


With Benjamin Nevarez, [twitter], [blog], the SQL Server Performance guru and author of Microsoft SQL Server 2014 Query Tuning & Optimization book.

And Alberto Ferrari, [twitter], [blog], founder at SQLBI and author of Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model book.


The wall!


at NIMHANS Convention Center, Bangalore (KA), India


SQL Server 2016 CTP 2.3 update available | download now

September 4, 2015 Leave a comment

Microsoft announced the next update of the recently released Community Technology Preview (CTP) 2.2 version of SQL Server 2016, the CTP 2.3, link.

[Register and Download the CTP 2.3 Evaluation version (180 days) here]

Direct download link for ISO: SQLServer2016CTP2.3-x64-ENU.iso ~ 2.6 GB

Check version and SQL build: select @@version
Microsoft SQL Server 2016 (CTP2.3) – 13.0.500.53 (X64) Aug 24 2015 03:51:16 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 10240: )
–> Enhancements and Issues fixed in this release:

1. Row Level Security support for In-memory OLTP tables, with Natively Compiled UDF support, demo video.

2. In-memory DW (Data Warehouse) ColumnStore performance optimizations. NCCI can now be created on tables with triggers, enabled with CDC/Change Tracking, demo video.

3. Performance improvements to SSAS, including DAX query performance, DirectQuery enhancements, support for variables in DAX.

4. Enhancements to SSRS, including an updated Report Builder with a modern theme and report rendering for modern browsers built on HTML5 standards.

5. Enhancements to SSIS, by releasing oData v4 protocol support, SSIS Error Column support, and advanced logging levels.

6. Improvements to MDS, Many to many derived hierarchy, Excel Add-in Business rule management, and Merge conflicts.

7. Core engine scalability improvement, dynamically partitioning thread safe memory objects by NUMA or CPU, which enables higher scalability of high concurrency workloads running on NUMA hardware.

8. Improvements to the Query Execution with improved diagnostics for memory grant usage.

9. DBCC CHECKDB includes Performance improvement with Persisted computed columns & filtered indexes validation, and Validating a table with thousands of partitions.

For all other new features released in SQL Server 2016, please check my blog posts here.

So, download the Preview today and start playing with the new features and plan your DB migration/upgrade.

Check the [SQL Server blog] for all these updates in detail.


Check & Like my FB Page.