2017-12 Sessions

The Junior SQL Developer’s Kick-Start

Target Audience: Entry-level and junior SQL Server developers seeking “Now what?” guidance beyond introductory T-SQL. Abstract: Congratulations on your recent move into the world of SQL Server development! You’ve got a handle on the basics — SELECT, INSERT, UPDATE, and DELETE — but now what? How do you know what’s important to learn next, and…
Read More

Uptight Database Security

Target Audience: DBAs and managers that must protect sensitive business data. Abstract: Do you work for an institution that fears its DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you have concerns that…
Read More

Effective Unit Testing for SQL Server

Target Audience: Developers and Development DBAs interested in unit testing Transact-SQL code. Abstract: There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline. This session isn’t about any of those tools,…
Read More

The Smart Way to Troubleshoot SQL Server Cluster and Availability Group Outages

Target Audience: DBAs and systems administrators – oh, and even developers who were “volun-told” – responsible for managing SQL Server FCIs and AGs. Abstract: SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But when mission-critical databases go offline, bringing them back online could be…
Read More