Designing Stored Procedure Solutions

Jen McCown With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: Asking the right[…]

Effortless Backups with Minion Backup

Jen McCown Let’s take the new, free backup tool out for a spin. We can hop through a quick installation, glance at the multi-install PowerShell script, and dance around the table-based schedules, for a start. Afterward we’ll have a long, leisurely walk through some of the best things you can do with MB: backup ordering,[…]

Locking and Blocking

Kalen Delaney Failing to design an application with concurrency in mind, and failure to test an application with the maximum number of expected simultaneous users is one of the main causes of poor application performance. Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look[…]

Leveraging Memory With The Database Engine

Chris Adkin “In memory” is a hot topic in the database world at present, but how do modern servers CPUs utilise memory, does the story end with main memory ?, what about NUMA and the memory hierarchy on the actual CPU. Do memory access patterns matter ? does the CPU socket certain workloads are executed[…]

Superscaling SQL Server Singleton Inserts

Chris Adkin This session covers tuning what is superficially the simple exercise of getting the maximum throughput out of a concurrent insert workload, from key construction, logging to tuning spinlocks. The session will look at two of the key spinlocks which influence of OLTP workload performance, namely XDESMGR, LOGCACHE_ACCESS and how they influence OLTP workload[…]

Top 10 Clustering Dos and Don’ts

Allan Hirt Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features – clustered instances (FCIs) and availability groups (AGs) – require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn[…]

What the Hekaton?!

Kalen Delaney SQL Server Hekaton, aka In-Memory OLTP, will completely change the way you think about data management. As a DBA, you’ll need to analyze your memory and storage needs completely differently. All Hekaton data is always stored in memory, and the data stored on disk is basically just a REDO log used to regenerate[…]