Microsoft UK, SQL Server Product Manager
||Demoncratization of Data and Power BI: from ideas to decisions
Jen Stirrup, SQL Server MVP
"Don’t worry about people stealing an idea. If it’s original, you will have to ram it down their throats.” Howard Aiken, Founder of Harvard’s Computing Science Program
Data is moving so fast these days, and there is a shift whereby people are paying for value, not technology. This is where cloud computing comes in: it is very empowering, because anyone with an internet connection can access it. With Power BI in the cloud, small businesses are liberated with the ability to use the same tools and techniques to explore ideas as larger organisations.
In this session, we will look at understanding the Power BI components and tools available in the cloud, including the Power BI Admin Center, Power Query, Power Pivot, Power View and Power Map. We will look at how to use them will accelerate ideas and help to clarify decisions, and related to this, discuss the roles within IT and the business in relation to these tools. We will also look at business puzzles versus business mysteries, a definition evoked by Malcolm Gladwell (Blink, Outliers) in relation to Power BI.
“Out there in some garage is an entrepreneur who’s forging a bullet with your company’s name on it,” said Gary Hamel, a management guru. With Power BI, let’s see how you can translate your ideas in to a message that people can see, using cloud as an empowerment tool.
||Improving performance and scalability using Fusion ioMemory and Microsoft SQL Server
Justin Weeler, Fusion-IO
Seen as an increasingly cost effective alternative to disk, flash storage technologies have allowed for dramatic improvements in performance, workload and scalability; resulting in accelerated business intelligence on far less infrastructure than legacy disk-based solutions. As flash is more readily adopted into enterprise architectures, it is important to understand that not all flash should be considered equal. When striving for consistent, low latency performance, it is critical to recognise how to implement flash to best serve the needs of the database. Join Fusion-io to understand the benefits of accessing Flash natively, whilst physically placing the flash on the PCI bus, where it is closest to the CPU.
||Monitoring and maintaining SQL is easy with System Center!
Simon Skinner, MVP
With System Center Operations Manager we can in a proactive way get on top of the game. No matter where our SQL servers are, in or out of our domain our concerns have been become a thing of the past on what the SQL server is doing. But to further enhance the monitoring experience we can throw in Best Practices with System Center Advisor. Keeping on top of our patching is a breeze with Configuration Manager whilst backing up became just a routine maintenance with DPM. I have never found maintenance of SQL to be so easy……
||SQL Server 2014 In-Memory Tables (Hekaton) - Introduction
Tony Rogerson, SQL Server MVP
In this session Tony will provide a basic introduction to Hekaton, what it is, how you use it and why you'd use it.
Basics covered will include what differentiates Hekaton from the rest of the pack, overview archiecture, introduction to the two new index types - hash and range; how to create tables and an overview of the interop V native compiled stored procedures.
||Estimation and Statistics : The Basis of query optimization
At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken.
How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
||Effective Index Partitioning & Compression Strategies
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
||SQL Server 2014 In-Memory Tables (Hekaton) Deep Dive
Tony Rogerson, SQL Server MVP
Probably the most exciting feature in SQL Server 2014, In-Memory tables takes us away from a storage paradigm that has served us well for over 5 decades. It brings together research that gave rise to Bw-Tree's and Multi-Version Concurrency Control (MVCC) in a single feature.
This is an advanced session, however we will cover off some of the basics for folk not comfortable with the new technology.
MVCC is a critical part of the technology - understanding the affect multiple versions of data has on memory usage - how MVCC works, what it is, understand it in use.
Hash and Range Indexes: what they are, understanding how to calculate the BUCKET_COUNT, when to use Range and when to use Hash.
Introduction to Native Compiled stored procedures.
Design Best Practice will also be covered as well as the new DMV's to monitor the sub-system.
||10 Tips and Tricks for better SSIS Performance
David Peter Hansen, MCM
Your SSIS packages are taking longer than they should, but you are not sure what to do about it. Join this session to get 10 tips and tricks for gaining better performance.
You’ll learn not only 10 reasons to why your packages are running slow, but also 10 ways to do something about it. Find out when to use T-SQL instead of SSIS transformations, why you should care about data types, what a blocking transformation is, why buffers are important, and much more.
||Networking and ..... - we are thinking!