Aim: To capture SQL Agent job history to a table. Following on from the previous blog post about adjusting the size of the SQL Agent…
Category: SQL Server
Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
As part of a data warehouse project that I’m working on, I need to be able to grant or deny access to users. I do…
Aim: Set service accounts for SQL Server after installation. In Server Manager, create a new user with a strong password for the SQL Server instance service.…
Aim: Determine which SQL Server Features are installed and configuration settings. To determine which features are installed on a server, run the Discovery Report which…
Aim: Test speed of durable memory optimized tables against non-durable. In the previous post, I tested the speed of memory optimized tables & natively-compiled stored…
Aim: Test speed of memory optimized tables & natively-compiled stored procedures against disk-based tables & stored procedures. There are a couple of examples available from…
Aim: Set up a Windows Azure virtual machine to serve as a testing environment for the new features available in SQL Server 2014. Set up a Windows…