Find out what tools you need to follow along with the course. You will need SQL Server, and either SQL Server Management Studio or SQL Operations Studio. You will also need a sample database.
- [Instructor] To follow along with the demos in this course you're gonna need a few pieces of software installed on your machine. The first is SQL Server 2017. You can use the Developer Edition which is free. I'm running it on Windows 10, in this scenario. But if you're a Mac user, you can also run it in a Docker container. You'll experience the same behavior that you would if you were using it on Windows. The databases we're using in the demo are the Adventure Works 2016 databases, both regular and the data warehouse, so you'll need both of these to follow along because we'll have demos and tables in each of them.
There are two management tools you can use. The first is probably the most common one, is SQL Server Management Studio. This is a Windows only tool that's based on Visual Studio and provides full administrative functionality for SQL Server. The other tool you can use is SQL Operations Studio. If you're using a Mac or Linux, this will be your only option. This is a more to T-SQL based tool that is based on VS code. It doesn't quite have all the management features yet the that SQL Server Management Studio has, but you can still write code and run an execute code and use some management features and it.
- Designing row-level security
- Using views to implement row-level security in SQL Server pre-2016
- Data encryption
- Configuring Always Encrypted
- Dynamic data masking