Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

All authors

Blog Post

Don’t Forget the Keys

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...

2017-07-11 (first published: )

2,222 reads

Blog Post

Check Those Settings

Recently, I was tasked with “enhancing” a third party application.  This third party application (TPA) outputs a bunch of files...

2017-03-30 (first published: )

2,267 reads

All authors

Blogs

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

By

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

The North Star for the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The North Star for the...

Multiple Escape Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Escape Characters

reaching ftp thru winscp but erroring in ssis ftp task connection

By stan

Hi, below i show various results trying to reach our ftp site (a globalscape...

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation): 

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned?

See possible answers