Sessions & Content

Tags
Content Type
Search
Conference
Data loading at warp speeds
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…
Estimation, Statistics and “Oh My!”
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.
Geospatial Data Types in SQL Server 2012
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
Modern Data Warehousing Strategy
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
Searching Binary Data in SQL Server 2012
A look at binary data in SQL Server and full-text searching of the content of binary files.
SSIS 2012 logging and monitoring
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
The Posh DBA: Troubleshooting SQL Server with PowerShell
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
Transact SQL Performance Tips
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.
T-SQL : Bad Habits & Best Practices
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.
Why APPLY?
Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But do you know the other ways APPLY can be used? Come learn five additional use cases and leave with a few new tricks up your T-SQL sleeves.
Windows Azure SQL Database Troubleshooting
While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.
<<1>>