programming

Article

Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL community: answering questions. Not only is it complementary to my current job as Simple-Talk editor, it is really a great joy to be able to help other people with their problems. It is also educational to see the kinds of things other people are going through before you also go through them.

2023-04-12

Quantifier predicates

by Additional Articles

SimpleTalk

T-SQL

Article

Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.

2022-01-14

CRUD Operations on a SharePoint List using Python

by Additional Articles

MSSQLTips.com

Python

Article

This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.

2021-11-19

Handling an unknown number of parameters in SQL Server

by Additional Articles

MSSQLTips.com

T-SQL

Article

In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.

2021-11-10

Model and Log Trend Reversals for Time Series Data in SQL Server

by Additional Articles

MSSQLTips.com

T-SQL

Article

This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.

2021-10-15

Plotting in Python for Financial Time Series Data for Exponential Moving Averages

by Additional Articles

MSSQLTips.com

Python

Article

Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.

2021-09-29

How LAG compares to other techniques

by Additional Articles

SimpleTalk

T-SQL

Article

LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques

2021-09-24

What does SET NOCOUNT ON do?

by Additional Articles

Brent Ozar Blog

T-SQL

Article

When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.

2021-07-05