Articles

External Article

Fun with Powershell

Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.

2024-02-09

SQLServerCentral Article

SQL Window Functions Series: NTILE()

Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.

4.67 (3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

4,379 reads

Blogs

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

My 2024 in Data: Music

By

This is my last week of the year working (I guess I come back...

A New Word: Suente

By

suente– n. the state of being so familiar with someone that you can be...

Read the latest Blogs

Forums

String Variable and sp_executesql

By stevec883

I am not understanding why this command completes "successfully" and it seems correct to...

printing complete path

By mtz676

get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...

adding dtc to my pkg

By stan

Hi below i show the control flow of my pkg.   I'd like to enlist...

Visit the forum

Question of the Day

Superseded Indexes

Which of these indexes is superseded by another?

See possible answers