Location Data Privacy

• by Steve Jones

• SQLServerCentral

• Data Privacy and Protection
• Database Weekly

Is anonymous location data a privacy violation?

Losing All Traces of Data

• by Steve Jones

• SQLServerCentral.com

• Editorial

Could someone remove data from all systems and backups?

TOP vs Max/Min: Is there a difference?

• by Mike Byrd

• SQLServerCentral.com

• T-SQL

Is there a difference between using TOP and MAX/MIN to return and end value to a table?

How to Get Started with SQL Server Management Studio

• by Additional Articles

• Brent Ozar Unlimited Blog

• Management Studio (SSMS)

Learn How to Get Started with SQL Server Management Studio with Brent Ozar.

The Basics of PowerShell Day By Day

• by FrankDolan77

• SQLServerCentral

• PowerShell

A basic introduction to PowerShell for those DBAs familiar with T-SQL.

The Hidden Trigger

• by Steve Jones

• SQLServerCentral.com

• Editorial

Steve Jones looks at the impact of triggers on our databases.

Using Simple Linear Regression to Make Predictions

• by Additional Articles

• MSSQLTips.com

• SQL Server

The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.

Desktop or Laptop for Remote Work

• by Steve Jones

• SQLServerCentral

• Hardware
• Work environment

This week Steve discusses the desktops versus laptops.

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

• by Bill Pearson

• SQLServerCentral

• DAX
• Stairway Series

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.

Free eBook: SQL Server Internals: In-Memory OLTP

• by Press Release

• Redgate

• ebook

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.