SQL Server 2017

This book is an exploration on how to program the Microsoft SQL Server 2017. The author begins by guiding you on how to get with SQL Server 2017 by setting up the environment. For users to enjoy the user of a database management system (DBMS), it must provide them with a good performance. The process of tuning the performance of SQL Server 2017 has been discussed. You will know how to tune it using both manual and automated techniques for a better performance. You may need to encrypt your data stored in SQL Server. This is possible by use of encryption keys and passwords. The author guides you on how to encrypt your data such that no one will be able to view it, even the DBAs. Databases should be audited in order to know what has been happening. The author guides you on how to create a server audit and database audit specification in SQL Server 2017. The SQL Server Integration Service (SSIS) has been discussed in detail. The process of granting permissions to users and revoking them has also been discussed. SQL Server reporting services have been explored in depth.The following topics have been discussed in this book: - Getting Started with Microsoft SQL Server 2017- Performance Tuning- Encryption- Creating a Server Audit and Database Audit Specification- SQL Server Integration Services- Permissions- Reporting Service