Stuart Moore
Data Wrangler
Nottingham, United Kingdom
Stuart has been working with data since 1998 across a wide range of platforms Currently buildimg and designing hybrid solutions tying on premise and cloud systems together
Stuart is a major contributor to the dbatools project and other open source projects, he also runs 2 usergoups (East Midlands SQL Server group and Nottingham PowerShell Usergroup) and is a member of the team that runs the annual SQL Relay series of 5 one day conferences around the UK. Was given the Data Platform MVP award by Microsoft in 2018
Links
Topics
Slacking for the DBA
No, not that sort of slacking. The Slack.com type of slacking. We'll be ignoring the gifs and looking at how using Slack, PoshBot, dbatools and a little bit of PowerShell glue you can build a simple solution that enables you to quickly respond to and fix problems from anywhere without having to carry anything more specialised than your smart phone. And we'll see how you can then extend that to allow you to hand off tasks to other users and teams in a safe secure manner.
SQL Server Secure Development Patterns
The database is at the heart of your organisation's applications. If you can embed secure practices here, then it will flow throw the rest of your application stack. We'll look at how permissions can be used, implementing per role filtering on returned data, and the where data masking can be used.
No more worrying if the web developer is properly screening fields , can the support analyst can see personal details than needed
Data messaging between cloud apps and platforms with Azure Service Bus and Logic Apps
Connecting disparate systems together across multiple cloud or providers can be a headache. By implementing a Message Bus solution using Azure Service Bus and Logic apps you can build a simple, scalable, and robust communications system quickly and easily.
In this session we'll look at the issue of cross platform communication, how Message Buses fix this and how Azure has brought them up to date. We'll step through building a simple solution that can easily be extended to cope with much more complex needs.
Embedding SQL security practices in your pipelines
With our development pipelines we automate our SQL Server deployments and testing, but rarely do we automate checking our database security.
Are all object owned by the right principal? Are permissions only granted to roles or groups? Have any accounts moved between roles during testing? How can you check?
dbaSecurityScan is an Open Source Powershell module that lets you extract and source control your database's security, then test against it to ensure nothing has changed. It can even apply corrective measures to bring your database back in line with your policies.
In this session we'll look at why and what you'd want to be checking during your deployments or database's life. How dbaSecurityScan lets you create a security baseline to check against, how to update that baseline to meet new criteria, how to monitor when your database moves away from that baseline and how it can be used to bring it back into compliance.
Feedback link: https://sqlb.it/?6980
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top