Articles

ASCII Text Dump

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]

5 (5)

2019-11-12

2,640 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

sqlcmd

By sqlfriend

I found recently sqlcmd is missing on my computer. It used to be there....

Multi-column pivot table help

By Pete Bishop

I have the following data in [table_1]: last_updated type_desc size_bytes used_bytes 2019-05-23 LOG 1835008...

Task Scheduler Job set up for Sql Server Agent

By pdsqsql

Hello, I am trying setup automatic job using the windows task scheduler to notify...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers