Another One Bites the Dust - PASS is Gone, so...What Now?
There has been a lot of noise over the last few weeks since it was announced that due to financial constraints related to canceling the in-person Summit due to...
2021-01-15
74 reads
Blog Posts
Connecting to SharePoint Lists with SSIS
SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint...
2021-01-15 (first published: 2021-01-09)
4,093 reads
Daily Coping 15 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-15
14 reads
Moving the Community Forward
Today is the last day that the PASS and SQL Saturday websites will be active. It’s possible that they will be shut down as this post gets published, and...
2021-01-15
36 reads
Speaking at C# Corner’s Virtual Conference
C# Corner is holding a virtual SQL Server conference on Jan 29-30, 2021. This is a charitable event, aimed at raising money for children affected by COVID-19. I’ll be...
2021-01-15 (first published: 2021-01-07)
198 reads
SQL Server Linux
If you have come from a windows background you may be curious about the world of SQL Server Linux. Yes, the operating system and the implementation of it differs...
2021-01-15
436 reads
Two methods of deployment Azure Data Factory
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes at scale. This post is NOT about what Azure Data Factory is, neither how to...
2021-01-15
8 reads
Daily Coping 14 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-14
11 reads
Farewell, Gareth Swanepoel
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
622 reads
Farewell, Gareth Swanepoel
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
3 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers