Category SQL Server

Allow or restrict access to database objects

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 this by setting permissions at different levels on the SQL Server (database, schema & object). I normally don’t have control over what analysis or visualisation apps are used to access […]

Set SQL Server Service Accounts

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. Tick Password Never Expires. For security, the account should be a regular user account, not an admin. If the server is part of a domain, you can create a domain user account […]

Determine SQL Server Features And Configurations

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 is available on SQL Server 2008 onwards. Navigate to the SQL Server Configuration Tools folder in the Windows Start menu and launch the Installation Centre. In Tools, click Installed SQL Server […]

SQL Server 2014 Features Part 2: Durable vs Non-Durable Memory Optimized Tables

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 procedures against disk-based tables & stored procedures. In this post, I will perform a similar test of durable & non-durable memory optimized tables. The previous post outlines the difference between durable […]

SQL Server 2014 Features Part 1: Memory Optimized Tables

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 Microsoft to demonstrate the performance benefits of Memory Optimized Tables: I roughly followed the first code example but I found the naming of the objects quite abstract so […]

Install SQL Server 2014 on Windows Azure VM

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 Azure virtual machine: Sign into Windows Azure at Click on the Portal button on the top right-hand side. Click on the Virtual Machines tab on the left-hand side & then […]

Kevin Kline

Career and Technical Advice for the IT Professional


Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert


A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!