Tags » SQL Server

Row Level Security in SQL Server 2016

This is the third post in a series of posts that highlight the new features of SQL Server 2016. You can find the first two post in SQL Server 2016 (JSON support in SQL Server 2016, temporal tables) series… 983 more words

Sql Server

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. It is one that I have had for eighteen years. 946 more words

Microsoft BI Platform

Actually you can use variables, CTEs and other fancy SQL with Tableau after all

A few months ago, I blogged about how you can use Tableau parameters when connecting to many database datasources in order to exert the same sort of flexibility that SQL coders can build into their queries using SQL variables. 1,110 more words

How To

Experimenting with SQL Server Memory

In my “career” as a muskie fisherman, I’ve caught or seen fish in some very unlikely places. I’ve caught fish over very deep water with seemingly no nearby structure as well as in water as shallow as just a few feet. 247 more words


Yes, foreign key can be null!

A few months back, I posted SQL Tip #1 – Indexing Foreign Key. Somebody asked me the question, can the foreign key be null? I read my post again, and realize I implied in my post that foreign key can be null. 217 more words


VMware vSphere 6.5 breaks your SQL Server vNUMA settings — Convergence of Data and Infrastructure

VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior.

28 more words

Consistency Check an Analysis Services Database

— By Lori Brown @SQLSupahStah

I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. 125 more words

SQL Server