Automate the Pain Away with SQL Server 2019

The way you tune your SQL Server workloads is changing.  In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events.  In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator changed. With SQL Server 2016 we were given query store…
Read More

Marketing for SQL Consultants and Business Owners

Target Audience: This session is for technical freelancers looking to grow their business and fill their pipeline. It’s also for small business owners who want to better understand how to start investing in marketing. Abstract: Pouring your heart and soul into traveling and writing, but the leads aren’t coming back to you? Finding success in…
Read More

Would you run production SQL Server on Docker?

Target Audience: For admins who have heard about Docker but aren’t sure what it’s for. Abstract: With the advent of Windows containers and SQL Server on Linux, the options for running SQL Server are growing. Should you run SQL Server on physical machines, virtualised, in the cloud or do you get with the cool kids…
Read More

SQL Server Developer Tricks

Target Audience: SQL Developers. Minimum 2 years of working experience with SQL Server. Abstract: If you are programming with SQL Server, you ought to know how your query is being treated inside the engine. Join this session to learn some real-world developer tricks that will improve performance of your SQL workload. Understand the DO’s and…
Read More

Getting Data Into Power BI

1 Comment
Target Audience: Business Analyst, Developers & DBAs using Power BI. Abstract: Power BI is such a powerful tool to develop visualizations. In order to display visuals, the developers of Power BI reports need to understand how data is organized in a data model. The sources vary. So examples of spreadsheets, flat tables or files and…
Read More

Getting Started with Azure Data Factory

No Comments
Target Audience: Data integration (SSIS, DataStage, Informatica, etc.) developers, DBAs, cloud enthusiasts. Abstract: I begin by creating a Data Factory in Azure, exploring two options: using the interface provided at the Azure portal (cleverly registered as portal.azure.com) and PowerShell scripts known as Azure Resource Manager (ARM) templates generated from the Azure portal. I lead you…
Read More

Think Like A Certification Exam

Target Audience: Any IT Abstract: Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination to aid you when taking the exams? We’ll go through the process of item creation, what rules writers must follow, and review some sample questions together. You’ll…
Read More