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.
Error handling in T-SQL stored procedures
This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them
What are the techniques to implement linked reports, subscriptions, report history, snapshot options, editing report using browser based Report Builder? Find out in this session.
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.
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.
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.
R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
PowerBi is hot. This session starts with an empty Excel workbook and walks you via Power Pivot and Power Query to Power View and Power Map.