This session will examine ways to write better code by using CTEs to simplify queries, implement error handling to deal with problematic data, and show a few tips and tricks for writing code quicker and generating enough test data to properly evaluate your queries.
This one-day online training course will introduce you to a number of intermediate-level concepts that will improve the T-SQL code you write. You will learn about windowing functions, error handling, aggregates, pivoting data, and CTEs along with a few tips and tricks for coding faster.
PowerShell is the definitive command line interface and scripting solution for Windows, Hyper-V, System Center, Microsoft solutions and beyond. In this Master Class, we will start from the ground up, walking you through the basics of PowerShell, how to create basic scripts and building towards creating custom modules to achieve amazing results in your environment, in non-Microsoft environments, and in Azure.