Below are a list of sessions and locations they were presented at:
Introduction to SQL Server and the Structure Query Language
In this session we will discover and learn the fundamentals of relational database management systems. Primary topics include: how to communicate with databases using the Structure Query Language; an introduction to tables and views; and a deep dive into the anatomy of the SELECT statement. The bulk of the course will be spent implementing SQL statements including SELECT, FROM, JOIN, WHERE, and GROUP BY statements. We will also cover comparison and logical operators as well as a few handy functions, such as UPPER, LOWER, CONCAT, AVG, SUM, and COUNT. This class is designed for people who have had little to no experience with SQL Server and Relational Database Management systems.
Introduction to SQL Server and the Structure Query Language Slide Deck
Introduction to SQL Server and the Structure Query Language Demo Scripts
Intermediate Query Structure and Development
In this session we will discover and learn the fundamentals of relational database management systems. Primary topics include: how to communicate with databases using the Structure Query Language; an introduction to tables and views; and a deep dive into the anatomy of the SELECT statement. The bulk of the course will be spent implementing SQL statements including SELECT, FROM, JOIN, WHERE, and GROUP BY statements. We will also cover comparison and logical operators as well as a few handy functions, such as UPPER, LOWER, CONCAT, AVG, SUM, and COUNT.
Intermediate Query Structure and Development Slide Deck
Intermediate Query Structure and Development Demo Scripts
Advanced Database Topics
In this session we will discuss advanced database administrator functionality, including troubleshooting and performance tuning. Primary topics include: commonly used SQL Server database objects; using Extended Events in place of SQL Profiler; an introduction to Dynamic Management Views; index maintenance and utilization; reasons to use and implement database partitioning; and a review of lessons learned while storing data in the cloud with AWS and Azure.
Advanced Database Topics Slide Deck
Advanced Database Topics Slide Deck (AZURE)
Advanced Database Topics Slide Deck (AWS)
Advanced Database Topics Demo Scripts
T-SQL: Simple Changes That Go a Long Way
Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance and functionality of your queries. We will dive into a few TSQL tricks with features that include Common Table Expressions, Table-Valued Parameters, OUTPUT INTO, Window Functions and COALESCE.
TSQL SimpleChanges Slide Deck
TSQL SimpleChanges Demo Scripts
Just Enough SSIS Scripting To Be Dangerous
SQL Server Integration Services has a number of tasks and components built into the standard toolbox, however there are times the functionality you are looking for just doesn’t exist. This session will introduce you to scripting in SSIS including script tasks and the three script components types; source, destination, and transformation. We will also discuss when to consider using custom and third party components over scripting. This session is not meant to teach you how to develop software with C# or Visual Basic, however coding examples will be demonstrated. Prior knowledge of programming is a benefit but not required.
Just To Be Dangerous Slide Deck
Just To Be Dangerous Demo Scripts
Indexing: Simple Changes That Go a Long Way
Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance of your queries. Learn about indexing techniques and reading execution plans to see if the optimizer is using the index. Performance isn’t everything though. There are small things you can do to make your TSQL more maintainable too. We will dive into a few TSQL tricks with Common Table Expressions, Table-Valued Parameters, and COALESCE.
SimpleChanges Slide Deck
SimpleChanges Demo Scripts
- SQL Saturday #191 Kansas City
- SQL Saturday #238 Minnesota
- SQL Saturday #256 Kalamazoo
- SQL Saturday #332 Minnesota
Rules of Engagement: NoSQL is SQL Servers Ally
When should you favor a NoSQL store over SQL Server, or consider polyglot persistence? In military and police operations, the rules of engagement determine when, where, and how force shall be used. As the “data police”, we are responsible for determining when, where, and how data is stored. As SQL Server professionals, it tends to be our first choice, even when there are other data storage options that are a ‘more natural’ fit. In this session, Rick and Dave will start with the NoSQL basics, and then dive into the different categories of NoSQL stores while explaining what each type is well suited for
Rules of Engagement Slide Deck
Freaky Fast Database Development Tips
Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre)
Freaky Fast Development Tips Slide Deck
- Twin Cities Code Camp
- SQL Saturday #149 Minnesota
- SQL Saturday #161 East Iowa
- SQL Saturday #159 Kansas City
Reporting on Reports
Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more…
Reporting On Reports Slide Deck
Reporting Solution