This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.
Come to this session to see how you can create a more efficient database development platform by integrating your VCS with SQL Server. In real-time, you’ll see how versioning, branching, merging, and the other manual tasks you hate can fade away with
Join Joseph for a fascinating look into SQL Server 2016 and its unmatched innovation across on-premises and the cloud to help you turn data into intelligent action
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.
If you use AlwaysOn Availability Groups, then come learn about the new enhancements shipped with SQL Server 2012 SP3 and above which allows you to troubleshoot failovers in your AG and understand reasons for latency.
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.
Analytics is all about having a good set of analytical tools. Last year at Sqlbits I outlined 4 such tools, this session will expand on that set. We’ll cover Dark Data, Probability calculations, RFI
This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.
Join me for an overview of how Azure SQL DB customers can simply secure their data using our most advanced features to-date including Always Encrypted, Transparent Data Encryption, Dynamic Data Masking and SQL Threat Detection.
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Join this session on moving a legacy enterprise organisation into the modern BI world using the power of positive disruption and the Attunity tool set. This real world case study will explore Zurich Insurance’s journey featuring both the challenges and successes they faced.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
There's base R, modern R, the Hadleyverse, R in SQL, and more - understanding where to begin can be an exercise in frustration and cost you valuable time. This session takes you through the R you need to be productive quickly.
In this session we will talk through the process of gathering user requirements to provide a good starting point for your data model. We will use the Sun Modelling technique to aid us in this.
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Lindsey Allen will peel back the curtain on SQL Server 2016 new feature Operational Analytics. We continue to invest heavily in in-memory technology and have now introduced one of the more important features we are releasing as part of SQL Server.
Learn from a real customer how they developed and deployed a series of BI Office solutions to support various business functions including: Finance, Web Analytics Supply, Pricing.
An introduction with worked examples of the new Data Lake storage platform in Azure.
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
We all know that correct indexing is king when it comes to achieving high levels of performance in SQL Server. When indexing combines with the enterprise features partitioning and compression, you can find substantial performance gains.
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
These two Microsoft analytic platforms share lots of technologies and users can import and model data in any one of the environments and use the results across both.
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
With R in SQL Server 2016, data engineers (DBAs, developers) are expanding their horizons and deriving more value for the business from their data. Come see how this is brining people in business together.
Sometimes bad execution plans happen to good queries. In this session you'll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans.
In this session, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
BI systems are increasingly mission critical, but they’re only as good as the quality of data they contain. Learn how you can use SQL Server MDS and Profisee’s Master Data Maestro to ensure data quality and improve BI value.
Come to this session to learn how to turn your existing applications into intelligent applications using the R integration into the SQL Server engine.
Azure SQL DB can automatically make apps run faster and more cost-effectively, based on workload telemetry from millions of customers. Come and see live demos about what the service can do
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
This presentation will give you an overview on U-SQL, why we decided to build a new language, what its core philosophical underpinnings are as well as show the language in its natural habitat, development tooling and language capabilities
Have you ever looked at an execution plan that performs a join between 2 tables, and wondered what a "Left Anti Semi Join" is? Joining 2 tables in SQL Server isn't the easiest part!
Learn how BI Office from Pyramid Analytics can turn your company into a data driven organisation heading for the stars, whilst combining the best of PowerBI on Premises.
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning. Using both free and paid tools from SQL Sentry, you’ll learn tips and tricks you can immediately apply to your SQL code, not to mention the free tools!
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
Enter the world of SQL Server concurrency to experience the age old problem of Locking, Blocking and Deadlocking. Let's investigate pessimistic isolation and whether optimistic concurrency could be the answer to all our problems or the last resort.
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
In this session, we are going to look at a typical machine learning process and how to apply it to real world data. We are going to use Azure Machine Learning to transform data and ideas into models that are production ready in minutes.
Running databases in SQL Servers in your office or data centre? Considering moving them to Azure? Want to know what options and benefits of Infrastructure as a Service and Platform as a Service?
In this talk, you will get an overview on what to think about when storing data in a document database.
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.
System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
What are the pros, cons and gotchas of being a permy vs contractor or freelance consultant? We’ll look at what you need to think about from a logistics, financial planning, tax, marketing, career and skills development perspective.
Maximise resolution time with some joined up thinking between developers and DBAs. We'll show how to identify poorly performing SQL, how to navigate and analyse its plan and how to increase performance, and cover some free tools to help connect you resolve issues faster.
Releasing new features every month, Power BI is moving faster than ever towards letting you experience any data, any way, anywhere. Join this session to learn how the current Power BI suite can be leveraged by all users and see the new updates
The quickest way to migrate your on-premises OLTP database to Azure is to "Lift & Shift". In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc.
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
This session covers practical applications of running total computations.
Come to hear about lessons learned from early customer deployments of SQL Server security features: Row level security, Always Encrypted, Data Masking, Auditing, etc.
The effectiveness of an AlwaysOn in SQL Server 2014 was in part limited by the throughput capabilities of the log transport function a review of Enhanced Availability Groups, log transport improvements, a comparison of SQL Server 2014 vs SQL Server 2016 using SanDisk Fusion ioMemory
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
This sessions covers the SQL Server 2016 Hero Features and you will see a real customer scenario demo showcasing the Full Lifecycle of Financial Data.
In this session we will cover the core database engine improvements that make SQL Server 2016 run faster than previous releases. We will also cover some new performance related features and how Windows Server 2016 will improve SQL Server performance.
SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing
Security is one of the top topics for the new release of SQL Server. A total of 3 completely new features are coming to us: Always Encrypted, Dynamic Data Masking and Row Level Security.
Windows failover clustering is the foundation for clustered instances and availability groups. A successful DBA needs to understand the underlying Windows portion of clustering. This session will show what you need to know
This session will explain how the Query Optimizer uses column statistics to determine which operators to use and the operator costs. We'll also look at the changes to the Cardinality Estimator in SQL Server 2014.
Join us in this session to learn about recent improvements and the ongoing work made to SSDT. This session gives you a chance to directly connect with the product team and get their insights.
Join us in this session for a ‘behind the scenes’ look at the new foundation for SSMS, how we built what you see today and learn about how we will accelerate innovation for SQL client tools going forward.
Everyone tests their code, but most people use ad hoc, non-repeatable testing with simple queries. This session will show you how to begin implementing testing into your development process, giving you a growing library that improves code quality.
Exposing the lighter side of Business Intelligence. If you've never been to a Power Hour session before then you definitely shouldn't miss this one.
The Internet of Things starts with your things. It's a great time to take a look at game changing technologies you can use today to make your IoT ideas stand out from the rest using Microsoft Azure.
Learn about keys and how to get them right.
This session will examine how to successfully design a modern data architecture on the Microsoft Azure cloud platform. Focusing on design tenants for efficient, scalable and resilient data processing
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
This session explains how to unit test your SQL source code, why you would do this and what tools you can use.
This session looks at building time series analysis with AzureML in R
Have you managed to implement, or are you struggling to implement, automated deployments for your databases, but keep hitting problems? Database deployments are complex - we look at the common problems.
In this session, you will learn about various anti-patterns and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits.
T-SQL user-defined functions may appear to be a good tool for code encapsulation and reuse, but they can have a dramatic impact on performance. In this session, you'll see why they slow down your queries, and how you can avoid this performance hit.
Tired of Bar Charts? We'll build out a custom PowerBI Visual and show the power of PowerBI whilst going into a deep dive on how this is achieved.
Understand the principle behind Microsoft’s Fast Track program, how architectures are produced and certified, and a review of the two new SQL Server 2014 Data Warehouse Fast Track Certifications, the 5TB and 7TB single socket configurations from Lenovo
Learn in just a bit over an hour how to use CISL (open source Columnstore Indexes Library) for getting deep insights on the Columnstore Indexes and how to use its maintenance solution for keeping Columnstore Indexes performing at their maximum speed.
R extends statistical and mathematical capabilities of SQL Server 2016.
Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
In this session, we will look at Predictive Analytics using SQL Server 2016 and R, using our boozy day at the Guinness factory as a backdrop to understanding why statistical learning is important for analytics today. Drinking Guinness is optional!
Nowadays many companies don't have dedicated developer positions. Therefore the most of the SQL code has been written by application developers. In this session we will cover the most important things they need to know about SQL Server.
You have probably heard about DevOps, continuous integration and delivery? This session introduces the concepts and benefits of adopting these processes.
This session will take you on an end-to-end journey of IoT, the Internet-of-things, from data generation to data movement, discussing topics such as "big data" and looking at all the services and technologies that help you understand your data
Learn about Excel and PowerBI from the Excel team.
In an easy introduction to machine learning and predictive analytics, we'll use AzureML to analyse the Titanic dataset and predict whether different audience members would have survived the disaster.
Enterprise Edition is crazy expensive but the features are crazy cool. How can you achieve the same effect without having to buy Expensive Edition? Come and find out.
Learn about 7 SQL and NoSQL databases: how they work, when to use them, and how they form a modern data architecture
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?
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.
This session will show you what is possible in the Power BI Offering of Microsoft in relation to Data Governance
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
Indexes are the best instrument for query optimization. But what kind of indexes and on what columns? The key to answering those questions is understanding how indexes are stored and used by SQL Server. And that is exactly what this session is about.
  1 to 100 of 854 first 1 2 3 4 5 6 7 8 9 last  Show 10 25 50 100 sessions per page