A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window
Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
A deep dive into batch mode scalability with column store index and SQL 2014.
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
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
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues
Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
The query optimizer is at the heart of SQL Server. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.
More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session will explore Hue's 2× different SAN in a box'es. Come and gain this much-needed exposure to Enterprise technologies.
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries and tries various techniques to make them faster.
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by 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.
I would like to present easy to follow principles of Kerberos configuration with handy tips and templates to get this right the first time for your particular environment.
SQL Sentry will present their revolutionary new software which provides enhanced visibility and manageability for advanced AlwaysOn topologies.
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.
Karen discusses five (plus a few more) database design blunders with tips on how to avoid them. Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
An in-depth dive into physical table structures
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
In this deep(!) dive session. I will walk you through the internal storage format of MDF files. I'll cover how SQL Server stores its own internal metadata, how it knows where to find your data, and how to read it once found.
The Column Store Index is an
exciting new technology in SQL Server 2012. Using column stores, you can
unlock new levels of performance for data warehouses – often gaining an order
of magnitude speedup on queries.
The addition of spatial data to SQL Server 2008 is one of the most important in terms of integration in line-of-business applications. This talk will discuss the new features and performance enhancements in SQL Server 2012.
This session will present you with a fascinating behind-the-scenes deep-dive view of the new column store index feature. How do column store indexes work? How are they built? And how can they yield such enormous performance boosts to some workloads?
The fill-factor index option has a huge impact on the performance of your DB. By using a different approach for specific use cases this session will give you the tools to find the most optimal fill-factor for your tables.
System Center Advisor assesses your servers’ configuration and helps you proactively avoid downtime, performance degradation, and data loss. It only takes 5 minutes to setup and is accessible wherever you have a web browser.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.
For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server.
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.
Based on my experience in creating OrcaMDF, an open source MDF file parser, I'll go through the primary storage structures, how to parse pages, headers, internal base tables, b-tree structures as well as the supporting IAM, GAM, SGAM and PFS pages.
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
With a myriad of options available, choosing the most appropriate storage solution for your company can be challenging. This session will give you a brief introduction to the technologies available, and what to focus on when making the decision.
So your customer's dot.net application is ready to ship and it is dog slow. This session focuses on the tools and methology that SQL consultants use to test and improve performance with dot.net applications.
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!
Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.
In this session we will take a deep dive into gaining an understanding of things that can affect transaction log performance and look into methods of prevention and troubleshooting of everyday gremlins.
This session will explore a handful of T-SQL practices - why they happen, why they're bad, and how we can work around them.
In this section we will show how to avoid performance problems caused by poor query design (functions in WHERE clause, data type conversions…) and explain how local variables and parameters affect the generation of execution plan.
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.
The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
Jon Reade examines the performance benefits of SSDs in a SQL Server environment.
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore
In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more.
After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.
DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer
attend this session to understand exactly how the optimiser decides on its plans
In this session with examples we will continue to cover how to identify inefficiencies in parallel query execution.
Part I was presented during SQLBits VI in London, if you missed it, view the Webcasts @ http://webcast.sqlworkshops.com.
See how the optimiser chooses the operators it does through real world examples.
A number of techniques have been discussed for scaling SQL Server on big-iron systems. Some apply to transaction processing, others to data warehouses. However there is very little available guidance on the impact of each for specific application characteristics. Learn which techniques are absolutely essential and which contribute a only few percent.
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
PANIC IN THE DATACENTER! Your databases are approaching - or surpassed - the Terrible Terabyte mark. You're pouring money into the SAN, but your data isn't pouring back out as fast as you want. You're terrified to DBCCs or index maintenance because everything takes forever, and you don't have big maintenance windows.
An overview of some everyday TSQL tuning techniques.
Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
This session will investigate using Stream Insight, SQL Server and Analysis Services to provide an example framework to monitor cube usage as well as suggest a mechanism for highlighting areas for performance and security enhancements.
Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net.
You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.
A challenge to traditional patterns of processing, storing and retrieving the precious data that we are responsible for
Understand the Query Optimiser from the man who knows!
Learn to tune Analysis Services 2008 query performance
In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms!
Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD.
I don’t have a quad core laptop yet, so I will do the best with my dual core!
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
Learn to love SCOM!
Out of the box the SCOM Management Pack for SQL Server is not popular with DBA's. This demo based session will take you through the process of how you can extend SCOM to properly monitor and analyse SQL performance. Ultimately providing performance management scorecards and dashboards for your CIO.
With examples we will discuss tips and tricks that will be useful for Developers, DBAs and Consultants.
This session covers the new scalability features of SQL Server Reporting Services 2008 and demonstrates how to build a high performance reporting platform to deal with your enterprise reporting needs.
MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships.
This session aims to enlighten the audience on improving Log file design, implementation and management for extracting maximum performance from SQL Server using real world examples and strategy. The session will focus on SQL Server 2005, SQL Server 2008 and SQL 2008 R2.
Learn how the Analysis Services cache works, and how you can pre-load it with data to ensure optimal query performance.
So you heard about the new spatial functionality in SQL Server 2008, rushed back to your database and added geography and geometry columns to all your tables, eager to create the next Google Earth-beating application. You then click the Execute button and wait.
And wait some more. (You get the idea).
Spatial data is a rather unique beast, and designing efficient spatial queries requires specific techniques when compared to other, more traditional types of data.
In this session, we look at how the SQL Server database engine satisfies spatial queries, the theory behind spatial indexes, demonstrate the effects of altering the bounding box, use the spatial system DMVs and stored procedures to your spatial database
In this session we will take a deeper look at how SQL Server uses I/O and how you can design the I/O system to meet the requirements of your applications.
In this presentation, I will introduce the Madison architecture and provide a roadmap with major milestones for this product
In this session we will analyze and resolve a real world SQL Server Performance issue. We will first identify a customer’s query performance issue and understand the reason for the non optimal performance of their application. After understanding the limitations it will of course be natural to invent and perform non TCO increasing magic to make SQL Server really fly. We will also provide few words of caution for those who might abuse the newly acquired magical powers.
This deep dive, no fancy power point show is equally designed for developers and administrators. If you are one of those who would rather perform the magic on your own laptop than just observe it being demonstrated, send me an email so I can send you the demo scripts to prepare yourself for the adventure.