The Vacation Conundrum
Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...
2015-02-17
879 reads
Blog Posts
T-SQL – Read CSV files using OpenRowSet
We can directly access a CSV file using T-SQL.
Input file
Configure server to run Ad Hoc Distributed Queries
sp_configure 'Ad Hoc Distributed...
2015-02-17 (first published: 2015-02-09)
15,623 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...
2015-02-16
53 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...
2015-02-16
38 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better, the killer feature for me is quickly deploying the...
2015-02-16
2 reads
Dealing with layered function calls
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...
2015-02-16 (first published: 2015-02-05)
6,283 reads
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,951 reads
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
649 reads
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
31 reads
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
48 reads
Blogs
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...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Forums
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
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
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