Show 41 - IFI

In this show, we talk about:

• External deadlines
• The RS.EXE utility and what it is used for
• Why you shouldn't use Task Manager to check how much memory SQL Server consumes
• The Lock Pages in Memory option
• Stored procedure execution options under Transactional Replication
• Instant File Initialization checkbox in SQL Server 2016 setup
• SQL Server Agent job history
• Fixed server roles and how to correctly configure logins in SQL Server 

Items mentioned in the show:

• Scott Murray - SQL Server Reporting Services RS.EXE Utility
• Gail Shaw - Stop using Task Manager to check SQL’s memory usage!
• SQLSaturday Israel
• Guy's Big Data seminar at SQLBits