SQL Smarts

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

tSQL

Azure Azure DevOps SQL Server

Azure DevOps: SqlPackage Deployment Timeouts

I recently looked at an Azure DevOps pipeline for a client that was timing out whenever an index change or other long running task was deployed using a DacPac. All deployments that ran within a few minutes successfully completed, but those taking longer than 10 minutes were failing. A quick Read more…

By Niall, 2 yearsAugust 29, 2021 ago
SQL Server

Associative Grouping using tSQL (Part 2)

This is part of series of posts about associative grouping: Part 1 – Associative Grouping using tSQL Recursive CTE’s Part 3 – Associative Grouping using Spark In part one of this series we looked at how we could use recursive CTE’s to find overlapping groups in two columns in a Read more…

By Niall, 4 yearsJuly 5, 2019 ago
SQL Server

Associative Grouping using tSQL (Part 1)

This is part of series of posts about associative grouping: Part 2 – Associative Grouping using tSQL Graph Part 3 – Associative Grouping using Spark 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 Read more…

By Niall, 4 yearsJune 21, 2019 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, 5 yearsOctober 23, 2017 ago
Recent Posts
  • Associative Grouping using Spark (Part 3)
  • Introducing AzureDataPipelineTools
  • Azure Data Factory: Dev Mode vs Published Code
  • Azure DevOps: SqlPackage Deployment Timeouts
  • Azure Data Factory: Making Non-Dynamic Linked Services Dynamic
Tags
ADFv2 (4) ADLSv2 (1) Associative Grouping (3) Azure (4) Azure Data Lake (1) AzureDataPipelineTools (1) Azure Devops (2) Azure Functions (1) Certificates (1) CTE (1) Databricks (1) Data Cleansing (3) Data Factory (4) Design Patterns (1) Graph DB (1) Security (1) Signing (1) Spark (1) tSQL (4) vNext (1)
  • Blog
  • About Niall
  • Talks & Events
  • LinkedIn
  • Twitter
Hestia | Developed by ThemeIsle