Measuring the Overhead of the Query Store

Target Audience: Database administrators or developers interested in query performance, running SQL Server 2016 in production, and/or considering upgrading in the next 6-12 months. Abstract: The Query Store, introduced in SQL Server 2016, provides DBA’s with an extremely powerful tool to assist them in diagnosing and tuning query performance problems. While the capabilities provided by…
Read More

So You Want to Be a Data Scientist?

1 Comment
Target Audience: Database pros or anyone working with a data scientist, or wants to become a data scientist Abstract: Does R seem like an alien language to you? Does data science terminology seem overly confusing? Would you like to learn more about data science but are scared of the math? Fact is, you’re probably doing…
Read More

SQL R Services: Start Working WITH Your Data Scientists

Target Audience: Database devs and DBAs that want to work with their data scientists. Abstract: As a DBA or a SQL developer are you confident working with your data scientists? Many of us can’t spell “R” and are scared by the math. That’s OK since many data scientists can’t write SQL. This impedance mismatch hinders…
Read More

Save Time and Improve SSIS Quality with Biml

No Comments
Target Audience: “Save Time and Improve SSIS Quality with Biml” is completely introductory. The primary target audience for “Save Time and Improve SSIS Quality with Biml” is SSIS developers. DBAs are sometimes asked to build SSIS solutions, as are sysadmins and – rarely – managers. Why do I include DBAs, sysadmins, and managers in my…
Read More

Alleviating database consolidation pains

Target Audience: Most everyone I know have been in some kind of consolidation discussion, but as technical professionals many of us are not used to thinking about the business side of things. This session is aimed at the technical people involved in both deciding on consolidation and those tasked with it and can hopefully provide…
Read More

Linux OS Fundamentals for the SQL Admin

Target Audience: The target audience for this session is the Windows sysadmin or DBA. This session is for those that have little experience with Linux. Basically, you’ve installed Linux and logged in and now you want to know what to do next. Abstract: PowerShell and SQL Server are now available on Linux and management wants…
Read More