SQLBits 2012

Enter the Dragon: SQL 2012 on Server Core

In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.

In 1982 the Dragon 32 entered the home computer market but unfortunately there was one small problem ...lower-case letters were almost impossible to access. Two years later, Dragon was no more.

In 2008 Microsoft released Server Core which provides a fast and streamlined (but reduced functionality) edition of Windows with minimal GUI support. As of SQL Server 2012, installation to Windows 2008R2 Core is now a supported option and will mean the biggest administrative change to a DBA since the release of SQL 2005 ...or will it?

In this session we will discuss and demonstrate:-
Configuration of the OS through Command line utilities and PowerShell
Installation of SQL Server on Server Core
Remote Administration of SQL Server and Server Core
Clustering on Server Core

Will the lack of GUI support send Server Core in the same direction as the Dragon 32 or does it spell a bright new beginning for Windows Server based computing and SQL Server?

Attend this session and this time, listen to the Dragon roar!

Mark Broadbent's previous sessions

2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition)

Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.

Introduction to continuous integration and delivery with Azure DevOps (20 min edition)

Learn how to use Azure DevOps for your development and CICD processes

SQL Server Always On for Dummies

In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.

Persistence is Futile-Implementing Delayed Durability

In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput.

Ye Olde Cluster Curiosity Shoppe-Clustering Tips & Tricks

Welcome to the strange and mysterious world of SQL Server Failover Clustering and enter Ye Olde Cluster Curiosity Shoppe where we will reveal a miscellany of top tips, tricks and advice gained from nearly two decades of installing and troubleshooting

Moves Like Jagger: Upgrading to SQL Server 2012

Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to SQL Server 2012.

Enter the Dragon: SQL 2012 on Server Core

In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.

SQL Server Clustering for Dummies

Are you uncomfortable with the idea of SQL Server Clustering? Do you currently use it and are scared to go near your Clustered Instances and their physical hosts? Stop worrying and learn the "Dark Art" of SQL Server Cluster administration.

READPAST & Furious: Transactions, Locking and Isolation

In this session we will investigate SQL Server concurrency and reveal some very surprising and thought provoking behaviors.

Thinking outside the Box. Learning a little about a lot

Generalize your skills so you can specialize on SQL Server.