SQL Smarts

  • Blog
  •  About Niall
  • Talks & Events
  • LinkedIn
  • Twitter

SQL Server

SQL Server

Associative Grouping using tSQL (Part 2)

In part one of this series we looked at how we could use recursive CTE’s toto find overlapping groups in two columns in a table, in order to put them into a new super group of associated groups. Since I wrote that post, SQL Server 2019 CTP 3.1 has been Read more…

By Niall, 2 years2 years ago
SQL Server

Associative Grouping using tSQL (Part 1)

Recently I was asked by a friend to have a look at an interesting query problem he had been looking at. He was trying to find overlapping groups in two columns, in order to put them into a new super group of associated groups. The simplest way to describe the Read more…

By Niall, 2 years2 years ago
Security SQL Server

Signing Stored Procedures for Server Level Permissions

What’s the Problem Stored procedures are often used to allow users to access data in tables that they do not have explicit permissions to use. The mechanism that makes this possible is ownership chaining, whereby in the context of the stored procedure, the permissions of its owner are used (often Read more…

By Niall, 3 years3 years ago
Recent Posts
  • Associative Grouping using tSQL (Part 2)
  • Associative Grouping using tSQL (Part 1)
  • Azure Data Factory Lookup: First Row Only & Empty Result Sets
  • Signing Stored Procedures for Server Level Permissions
Tags
ADFv2 (1) Azure (1) Certificates (1) CTE (1) Data Cleansing (2) Data Factory (1) Design Patterns (1) Graph DB (1) Security (1) Signing (1) tSQL (3) vNext (1)
  • Blog
  • About Niall
  • Talks & Events
  • LinkedIn
  • Twitter
Hestia | Developed by ThemeIsle