PASS East Midlands

Next Meeting

Thursday,

February

04

February PASS East Midlands Meetup

  • In-Person @ Trent House, Station Street, NG2 3HX Nottingham, Nottinghamshire, United Kingdom (map)
  • 18:00 - 20:30 (UTC+00:00) Dublin, Edinburgh, Lisbon, London
  • Language: English

Welcome to our first meeting in a new city and venue.

Our normal format :

• Doors and intros: 18:00-18:30 

• Session 1: 18:30 - 19:20

• Break for Food: 19:20-19:40

• Session 2: 19:40-20:30

And there's always the chance of a visit to a local hostelry afterwards

Featured Presentation:

Asking SQL Server about SQL Server

Stuart Moore, Senior Technical Support Analyst Nottingham Trent University

• Ever stumbled across a database with no Foreign Keys and want to find which columns might be the best bet? • Wanted to check that all columns for PhoneNumber data had the correct data type before a change goes in? • When was this database last backed up and just where is it in case you need it in a hurry? • How many indexes are there on this table, and are they all actually being used? • What new object has Microsoft shipped with this new version of SQL Server? SQL Server is also keen to know the answers to these questions, so it makes sure it has the data to answer them. With a bit of simple digging you can get the answers as well. This session will show you how to do that, and show you where you want be looking if you want to start hunting on your own. You'll be able to go back to work on the Friday knowing how to poke around in that 3rd part solution with no documentation and start piecing things together

About Stuart:
Stuart has been working with SQL Server since version 7 in 1999. His roles have included development and DBA, with a focus on consolidation, security and performance. He also has experience with many other data platforms, and is using this to link up infrastructures using Bash and PowerShell to ease management and deployments. He runs the UK PASS East Midlands chapter, and regularly speaks at UK SQL events,

AD 2016. 2AM A Disaster just Began.2AM

Tobias Koprowski, Independent Consultant, Trainer Shadowland Consulting

• We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: And what NOW? New version old my old well-known session updated for whole changes which happened in DBA World in last two-three years. • So, from the ground to the Sky and further - everything for surviving disaster. Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. • In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.

About Tobias:
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador. Traveler. Coffee Addicted.

PASSChapterLogo.jpg

sql_micro_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids