From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Analyze logs from Azure SQL Database - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Analyze logs from Azure SQL Database
- [Narrator] In the previous movie, we set up auditing on an Azure SQL Database. Now let's issue a few commands to create a table and populate a few records into that database. You'll notice that I'm still inside of my Azure SQL Database here, I'm not logged into my local database. We'll go ahead and make sure I'm using the Azure SQL Database that I created. And then we'll create a few audit events. We'll create a schema called Warehouse. I'll create a table called New Products on the Warehouse schema. We'll go ahead and insert a few values. And then we'll select the data out of that table. I'll select everything from the new products table. And then we'll select just where the product ID is equal to 2. Those actions should've triggered entries into the audit log. So let's now take a look at viewing the contents of the audit. To do that, we'll go back into our Azure portal. From the main portal dashboard, we'll click on SQL databases, and then go into the database that we're working…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.