I attended and helped at the SQL Server Relay event in Reading. It is an event run by community members who have a passion for SQL Server. The day was full of great techincal sessions.
The Keynote SQL Server 2014 and the Data Platform was delivered by Anthony Saxby. SQL Server 2014 features were shared with technology that will help transform the data centre, unlock insight on data , enable people centric IT and increase mission critical performance. The In Memory feature can give performance gains, on average 10 times faster, without having to rewrite code. SQL Server 2014 is for the OLTP workload to compliment SQL Server 2012 and the BI workload enhancements. Many other features were discussed including the platform for hybrid cloud.
Hadoop, Big Data and SQL Server session delivered by Justin Langford discussed Hadoop, Horton Works and HD Insight and the paradigm shift of data being stored and then the structure being overlaid later. The session covered the characteristics of data and a comparison of the traditional database warehouse and map reduce.
Chris Webb shared the Microsoft BI strategy, What’s New for BI in Excel 2013. The tools that are now available in Excel 2013 covered PowerPivot (part of the UI now), Power View (for creating dashboards), GeoFlow (3D Maps) and Data Explorer at public CTP. You need the Professional Plus edition license for these functions.
SQL Server Troubleshooting and Diagnostics by Neil Hambley shared a troubleshooting methodology using the SQLCAT flowchart “Troubleshooting SQL Server 2005/2008 Query Performance/Scalability Issues.” http://sqlcat.com/files/folders/280/download.aspx. The flowchart provides a structure to work with for troubleshooting performance issues which can be customised to each environment.
The Era of the Cloud OS is all about transforming the Data Centre. The transformation trends of cloud computing, new social media, consumerization of IT and data explosion have brought the need for building blocks and multi tenanted architectures. Automation with PowerShell, commodity hardware and virtualization are all tools linking with the cloud. Most SQL Server workloads can now be supported on virtualization with only a 6% overhead.
A great session was shared on getting the most from your SAN – file and file group design patterns. Stephen Archibold gave some useful references on articles to read to gain further insight.
Fast Track Data Warehouse 3.0 Reference Guide
http://msdn.microsoft.com/en-us/library/gg605238.aspx
Diagnosing and Resolving Latch Contention on SQL Server
http://sqlcat.com/whitepapers/archive/2011/07/05/diagnosing-and-resolving-latch-contention-on-sql-server.aspx
Maximizing SQL Server 2008 R2 Table scan speed from DSI Solid State Storage
http://henkvandervalk.com/maximizing-sql-server-2008-r2-table-scan-speed-from-dsi-solid-state-storage
How to Specify SQL Storage Requirements to your SAN Dude
http://blogs.prodata.ie/post/How-to-Specify-SQL-Storage-Requirements-to-your-SAN-Dude.aspx
Videos
The Art of War-Fast Track Data Warehouse & Fragmentation
http://sqlbits.com/Sessions/Event9/The_Art_of_War-Fast_Track_Data_Warehouse_and_Fragmentation
Partial Database Availability & Online Piecemeal Restore
http://technet.microsoft.com/en-us/sqlserver/gg545009.aspx
The last session of the day was on Parallel Data Warehouse by Ryan Simpson which shared details about the massively parallel processing platform. The appliance is Data Warehousing best practices in a box. The disk layout and scale out designs were shared.
