August SQL Server user group meeting.
- One License of SQL Data Generator from Redgate
- Two, one month, Pluralsight passes
- One, £20 Amazon voucher from SpectrumIT
18:00 - Doors Open
18:30 - Introductions
18:45 - Dave Morrison (@TSQLNinja)
Myth Busters! Busting Common TSQL Myths
In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have.
David is a senior BI consultant at itelligence. Having worked in some for of database development or another for around 14 years his areas of specialisation are sql server engine internals, tsql and query performance tuning. David has spoken at numerous conferences including several SQLBits and SQL Saturday events as well as user group meetings. He is a a confident speaker who uses humor and a down to earth approach to make even the most technical subject matters easily attainable and engaging.
19:45 - Pizza, drinks & chat.
20:00 - Stuart Moore @napalmgram )
Automating Database Restores and Verification with PowerShell
SQL Server makes it simple to automate backups with jobs and maintenance, but doesn't provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database
Stuart has been working with SQL Server since 1998 and version 7. Splitting the years between roles as a DBA and a Developer.
21:00 - End