Using Regular Expressions With T-SQL: From Beginner To Advanced

Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.

Bitwise OR

List Expressions and Values of Variables in SSIS package

Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?

Dynamically Download FTP Files Using SSDT

Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools

SSRS Expressions Tips and Tricks

Some of the expressions and functions that have come in handy while developing reports in SSRS

Escaping In Expressions

The expressions language in Integration Services is a C style syntax, so you may need to escape certain characters.

RE: Database Create Date after restore.

Its easy if you script it!  We take log backups every 15 minutes.  95 log backups in a single day (skip the time that the full starts).  So, manual restores are NOT something that I want to do!  I wrote a procedure that creates the restore statements for me.  Give it a database name, start time, […]

RE: Could not complete cursor operation 16958

Yup....post the code so that we can examine it.....and get rid of the cursor.If you don't know why I'm advocating the latter route....search here for 'good performance' and 'cursor'.....the 2 phrases rarely go together!99.99% of SQL actions can be done without cursors....with a (noticable)performance boost 99.99% of the time.....