Chapter 11. Working with the SQL Server
In this chapter, we will cover the following seven recipes:
Creating a basic SQL query
Understanding SIFT
Using the SQL profiler
Displaying data from a SQL view in NAV
Identifying Blocked and Blocking sessions from SQL
Setting up a backup plan
Maintaining the transaction logfiles