March 4 – Charleston PASS, Charleston, SC
What Admins Absolutely Must Know About SQL Server Security
There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this session we’ll break down what you absolutely must know about securing SQL Server. We’ll look at the things to look for within SQL Server, including some of the nooks and crannies an attacker might use but what are rarely audited. You’ll leave with a checklist of what to investigate and a set of scripts to run on your own systems.
March 12 – Webinar with MSSQLTips.com
SQL Server backup automation and best practices
Join us for this webcast to learn about best practices for backing up your SQL Server databases along with things you can automate to reduce your workload.
Having proper backups for your SQL Server databases is your last line of defense when things go wrong. Database backups are rarely used to restore a production database, but when they are needed, having a solid plan is paramount.
In this webcast we will cover:
- The types of backups to setup for your databases
- Proper database settings for backups
- Protecting database backups
- Backing up system databases
- Automating backups with SQL Agent and other scheduling tools
- Automating checks to ensure backups are successful
- Setting up alerts and notifications for backup failures
- and more
March 12 – Midlands PASS, Columbia, SC
What Developers Absolutely Must Know About SQL Server Security
There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice.What do you listen to? What do you focus on? In this session we’ll break down what you absolutely must know about building secure database using SQL Server. We’ll look at the SQL Server securables model, how you can simplify your security model using patterns and models you are already familiar with, how roles can be used to aggregate security cleanly, and how to put in triggers and other mechanisms to try and protect your databases from attack.