Sessions & Content

Tags
Content Type
Search
Conference
7 Databases in 70 Minutes
Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture
AD 2015. 2AM A Disaster just Began
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?
Agnostic, Hybrid Big Data Integration using PDW and PolyBase
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
Alarm for Data Governance! Self-Service BI is coming
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
All about Indexes
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
An End-to-End Troubleshooting Checklist for SQL Server
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
An Introduction To Column Store Indexes and Batch Mode
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
Analysing Text with SQL Server 2014
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Analytics Master Class-exploiting exotic patterns in data
There are some little-known but very useful ways of extracting information from data. This session will cover: • Monte Carlo simulations • Nyquist’s Theorem • Simpson’s paradox • Benford’s Law These will rock your world (they certainly rocked mine).
Analyze data streams with Azure stream analytics
Azure stream analytics is a new Azure service for analyzing streaming data.
Automating Your Database Deployments
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practise your deployments using continuous integration before you ever get near production
Azure Machine Learning from the ground up
Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Azure Networks and VMs for the DB Guy
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
Best Practices for multi-environment database development
A journey from dev to production. This talk covers best practices for developing and deploying Visual Studio Database Projects targeting multiple environments. We will cover using composite projects, pre and post deployment scripts and other optionst
BI DBA Performance Tuning
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
Boost your T-SQL with the APPLY Operator
The session starts with a brief overview of the operator and it
Build your own Monitoring Environment with Powershell
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
Building a meta-driven near realtime ETL solution with BIML
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
Building A Reporting Solution Using Power Query
See how to use Power Query to build a detail-level reporting solution
Building Big - In The Cloud
The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.
Bulk load and minimal logged inserts
When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?
Challenge Me! Capturing SQL Server Data with PowerShell
Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
Cloud Migration: The anatomy of a whole datacentre migration
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
Clustering SQL Server: What Does It Mean In 2015?
Clustering no longer means just installing a clustered instance of SQL Server (FCI). Availability groups also are clustered. This session will demystify clustering as it relates to SQL Server.
Coeo Managed Support-More interesting support cases!
Come and hear about some of our most interesting SQL Server support cases from the last 12 months
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit
This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites
Common Pitfalls When Analyzing Execution Plans
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…
Common TSQL Mistakes
A review of many TSQL mistakes I see over and over at clients! This is a 100%-demo session, with the bad AND good code presented. I GUARANTEE that you will find things here that help you be MUCH better at interacting with SQL Server!!
Continuous Integration for Reporting Services
Continuous Integration for Reporting Services
Create SQL FCIs with AGs cross site with no SAN rep???
Multi Site Tier 1 HA solution: 5 parts (1 Windows Cluster, 2 lots of cluster storage, 3 SQL FCI’s & 4 AG’s)
Daily problems with indexing and its-possible-solution
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Data Culture
Being able to reason over your data and accelerate your insights is essential in this cloud first mobile first world. This session visits key technologies, PowerBI, AzureML and IoT to help you start driving your data culture.
Database Design: Size DOES Matter
Great database performance starts with great database design.
Daves SQL Fun Time Hour (Plus a bit)
In this session we'll take a look at a wide variety of topics, from useful and little known TSQL coding constructs to best case indexing advice and a whole lot more.
Deadlocking for Mere Mortals
This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Deep dive into Delayed Durability
In this session you will see what is delayed durability, how it is achieved and how to make the best use case out of it. You will understand how to use it and a demo which explains the effects of using delayed durability with SSDs.
Deep Dive into Power Query Formula Language
Join us to go beneath the UI, to learn how to unlock the full power of the underlying query engine and the formula language, and to truly conquer your data and data-shaping needs.
Deep into Isolation Levels
Isolation levels are one of the most complex subjects inside SQL Server and at the same time - one of the most important one. In this session we will take a look at all of them and see how they work behind the scenes.
Delivering Agile Analytics with Azure Machine Learning
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
Deploying SQL Server with Microsoft Azure Virtual Machine
Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how
Designing a database to best support multidimensional OLAP
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
Designing Stored Procedure Solutions
In this session, you’ll learn about SQL Server stored procedures: what they are, when and why you'd use them, and how you would develop a solution with one. We’ll walk through examples to explore the process of solution building in SQL Server.
Developing For PowerBI
The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story
DR with the Worlds largest data center
This session will look at providing cost effective DR capability with Azure.
Drive BI Value through Master Data Management
Today’s BI systems are often perceived as mission critical, but their value depends on the quality of data they contain. Learn to use SQL Server Master Data Services and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
Easy Performance Tuning: an Intro to Wait Statistics
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
Estimation and Statistics : The Basis of query optimization
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.
EventStore-a streaming database for CQRS and event sourcin
EventStore is an event streaming database specialising in delivering CQRS, but capable of being a general repository for notifications. Get the skinny on how it works, the architecture and where you might use it.
Excel Services 2013-the BI frontend of the future
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective. (1) Overview of the publish options (2) How to control the layout (3) Tips & Trick from real world examples
Eye Vegetables and Eye Candy: How to Visualise your Data
What's your data visualization vegetables, and what's your candy? This session will look at data visualization theory and practice.
Five Ways to Write More Effective Triggers
Many triggers are inefficient and violate best practices, but it doesn't have to be this way. Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
Five Ways You Can Become the Enterprise Data Hero
According to The New York Times, data scientists may spend as much as 80% of their time on “data janitor work.” Attend this session and discover five ways you can become the data hero in your organisation.
From Here to Azure
Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.
Get started with troubleshooting SQL Server
This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.
Get Testing with tSQLt
tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.
Getting Started with Azure Search
Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure
Getting Started: Azure SQL DB Audit & Dynamic Data Masking
Learn how Auditing provides Configurable Auditing policy and Azure storage to log database activity. Also learn how to leverage Dynamic Data Masking reduce the exposure of sensitive data in application and DevOps scenarios.
Getting Your Data into NodeXL
If you work with an amazing visualisation plugin NodeXL you might have asked yourself the question - how do I get my custom data for getting those great visualisation for analysis. This session will show you a couple of ways of how to get it done.
Going Asynchronous with Service Broker
This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.
Hadoop Primer for SQL Server DBA
Big Data is here to stay, no doubt about that. And Hadoop is THE framework for Big Data. But what is Hadoop? Is it a friend or foe for SQL Server DBA? Let’s explore what Hadoop is and how to make it work together with SQL Server.
Hadoop: From Hive with Stinger to Tez
For long Hadoop and MapReduce were linked together. With the release of YARN, Hortonworks, Microsofts Hadoop partner, launched the Stinger initiative to speedup Hive a 100x. But wat is it? In this session I will show you.
Headache guaranteed: Deadlocking in SQL Server!
SQL Server needs its locking mechanism to provide the isolation aspect of transactions. As a side-affect your workload can run into deadlock situations - headache for you as a DBA is guaranteed!
How to decide if your database is a good candidate for Virtu
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no h
In Database Automation We Trust
Why can't DBAs seem to trust automation for the Database? Here's how to overcome that mistrust and conquer database automation.
Increase your SSIS productivity with Biml
Discover the power of Business Intelligence Markup Language (Biml) and increase your Integration Services development productivity.
Increasing Business and IT Collaboration with SQL Server
SQL Server provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case.
Indexing Internals
In this session we'll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes.
In-Memory OLTP, how to use it
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.
Inside the Query Optimizer
In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way
Introducing the Reimagined Power BI Platform
Microsoft has totally reimagined the Power BI platform and user experience for BI professionals, developers and business users. Please join me to further explore all these great changes and enjoy a fun demo-intensive session.
Introduction to Powershell cmdlets for DBAs
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Life saver-Resource Governor for applications & reporting
There are still environments which serve one single SQL Server database for both critical applications & reporting. Budgeting issues and infrastructure bottlenecks kill the application to be better managed and maintained. What could be the solution?
Load Testing With SQL Server Tools
Understanding how SQL Server performs under various Load scenarios, requires controlled testing of a SQL Server instance whilst capturing key metrics using tools like Distributed Replay Controller can make this challenging task easier
Metadata Driven Automation: A Primer
Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved.
Microsoft SQL Server Engine team unplugged (Q&A)
This session is your opportunity to ask the people who know, the questions you want to ask. This is an opportunity you cannot afford to miss.
Microsoft SQL Server: Hybrid Computing Evolution
One of the crawl, walk then run onramps to the cloud would be to exploit Hybrid computing. Microsoft SQL Server gives you this on ramp as it continues to extend the value to your on premise environment with features that let you extend to the cloud
My top 5 new features in SQL Server 2014
SQL server 2014 is one of their measure releases. Where Microsoft has done a superb job. There are so many enhancement we have in SQL Server 2014. In my session I will show you my top 5 features.
One BI Platform to Rule Them All
BI Office can help you achieve your quest for insights and timely business information. By demonstrating how to build a BI Solution, this session will show you how BI Office can make you a BI Superhero in your organisation
Optimizing your SSDT Deployments faster than The Flash
Ever wondered if you can optimize your sql projects so you don't have to do unnecessary work? Take a look at how I've optimized SSDT Deployments by use case.
ORM Tuning From A Database Perspective
Most ORM's tend to be very chatty and generate complex queries. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why.
Parameter Sniffing Problem with Stored Procedures
Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Power BI as your Business Intelligence Proof of Concept Tool
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Power BI Dashboarding
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
Power BI on SAP HANA
SAP HANA is ubiquitous nowadays and its market share is growing steadily. But being foremost a backend technology opens the trail for other frontend tools like Office 365 &Power BI. How to combine these two technologies will be shown in the session.
Practical T-SQL Tips & Tricks to coding problems
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.
Prevention is better than cure!
Come to learn how to implement solutions to prevent undesirable settings creeping in your SQL Server environment. To accomplish this, we will look Policy Based Management with Central Management Servers, SQL Server Audits and DDL Triggers.
Python and R for SQL and Business Intelligence Professionals
When it comes to analyzing data, the R statistical language come readily to mind. Python is yet another one of your secret power tool for SQL Server, data analysis and business intelligence. In this session, we will look at both Python and R.
Query Store: New Query Tuning Feature For SQL Server & Azure
Query Store is a new feature that is coming to SQL Azure and SQLServer. It aims to greatly simplify the process of getting insight intothe performance of your application. Come learn how the SQL team is going to make your life awhole lot easier!
Query Tuning Mastery: Clash of the Row Goals
Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries.
Reading the SQL Server Execution Plan
In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output.
Real Life Master Data Management with SQL Server and MDS
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
RMan and ReportingGirl-joined forces for clean reporting
RMan and Reporting Girl join forces to fight the crimes in data visualization. By building a common ground (based on the IBCS standards) they improve their weapons (R and SSRS) that help them in their fight.
Scaling the DVD Store from 100 to a million TPM
Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
SharePoint as Business Intelligence platform
Setting up SharePoint BI applications and services to work in an enterprise environment
Shiny: dashboards in R
Need a snazzy dashboarding tool, and want it free or cheap? With a modicum of R and Linux knowledge, you can make interactive realtime dashboards for free that can be used in any web browser. Learn how in this session.
SQL Server 2014 In-Memory OLTP Deep Dive
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to improve query performance up to 100 times. In this session we will look under the cover of Hekaton and the Multi Version Concurrency Control (MVCC) principles.
SQL Server Fast Track Data Warehouse: Understand the program
This presentation discusses the process undertaken to achieve the certification of a 90TB SanDisk solution (HP DL580 Gen8 and Fusion ioMemory) whilst achieving an efficient out-of-box balance between SQL Server data processing capability and hardware
SQL Server on Flash: Re-Thinking Best Practices
Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.
SQL Server, HDInsight, & Machine Learning-data and big data
Working on full abstract...i'll update this week.
SQL2014 : The all new cardinality estimator
In SQL Server 2014, there have been many changes aimed at giving a more accurate number of rows, and therefore better plans. This session will be a look at these changes, comparing and contrasting with SQL2012/2008 to see how they help.
  1 to 100 of 640 first 1 2 3 4 5 6 7 last  Show 10 25 50 100 sessions per page