Father, husband and database professional specializing in everything SQL Server. I have been working with SQL Server since 6.5 and have loved to see the progression of the product. I am an avid PASS volunteer, speaker and chapter leader since 2001. I was the chapter leader for the Triad SQL Server User Group in Winston-Salem, NC off and on for many years.

All authors

All authors

Blogs

The Book of Redgate: Customer Quotes

By

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Using Cron in Postgres Flex

By

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...

Can I Change a Primary Key Value? #SQLNewBlogger

By

I heard someone say recently that you can’t change a primary key value in...

Read the latest Blogs

Forums

Life Moves Pretty Fast

By Grant Fritchey

Comments posted to this topic are about the item Life Moves Pretty Fast

Parse XML data from SQL table using temp tables and variables

By Lord Slaagh

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

50 Years of Microsoft

By Steve Jones - SSC Editor

Comments posted to this topic are about the item 50 Years of Microsoft

Visit the forum

Question of the Day

Multiple Collations

Can I have a collation expression like this in SQL Server 2022? 

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...

See possible answers