Stairway to Row-Level Security
This series looks at row based access control in SQL Server 2016+ as implemented in the Row-Level Security feature.
2017-10-27
2,688 reads
This series looks at row based access control in SQL Server 2016+ as implemented in the Row-Level Security feature.
2017-10-27
2,688 reads
Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.
2017-09-20
1,028 reads
In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.
2020-12-23 (first published: 2017-09-13)
2,150 reads
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
871 reads
This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.
2020-07-22 (first published: 2017-06-07)
4,528 reads
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,091 reads
The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?
2021-10-27 (first published: 2017-05-24)
3,832 reads
In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.
2020-03-18 (first published: 2017-02-22)
3,413 reads
Learn how to get started working with SMO and PowerShell.
2020-12-30 (first published: 2017-02-01)
5,621 reads
Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.
2019-03-26 (first published: 2017-01-04)
2,239 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers