In Depth Learning at the PASS Summit
The pre-conference sessions for the 2018 PASS Summit were released.
SQL Server From .Net: Making A Connection
A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.
Using T-SQL to Detect Stock Price Reversals with the RSI
Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.
SSIS Design Pattern - Staging Fixed Width Flat Files
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?
Considering Other Views
When we build software, are we empathetic to how others (literally) view our software?
Monitor Query Performance Using Query Store in SQL Server
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security
In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers