Additional Articles

Unified Approach to Generating Documentation for PowerShell Cmdlets

by Additional Articles

SimpleTalk

PowerShell

Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.

2016-05-24

2,675 reads

Database Hardware and Infrastructure Trends

by Additional Articles

SQLPerformance.com

Hardware

Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.

2016-05-23

3,214 reads

Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

by Additional Articles

Microsoft MSDN

Memory Optimized Tables

Denzil Ribeiro looks at the validation phase of transaction lifetime.

2016-05-20

2,662 reads

Comparing Networking Options in Azure

by Additional Articles

SimpleTalk

Azure

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure?

2016-05-19

3,041 reads

Differences between Delete and Truncate in SQL Server

by Additional Articles

MSSQLTips.com

delete

Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.

2016-05-18

4,518 reads

Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level

by Additional Articles

Database Journal

Row-Level Security (RLS)

In this article, Greg Larson reviews why a block predicate is important when you implement row level security using SQL Server 2016.

2016-05-17

4,426 reads

Implementing SQL Server In-Memory OLTP

by Additional Articles

SimpleTalk

in-memory oltp

How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .

2016-05-16

3,732 reads

The SQL Server 2016 Query Store: Analyzing Query Store Performance

by Additional Articles

SimpleTalk

Query Data Store (QDS)

There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect.

2016-05-13

3,339 reads