Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,577 reads
Blog Posts
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,097 reads
Four Big Things PASS Could Do Next Year
Here’s my wish list:
Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring...
2014-09-25
735 reads
Installing SQL Server 2014 Language Reference Help from disk
Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...
2014-09-25
953 reads
Presto Chango
About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared...
2014-09-25
490 reads
SQL Server 2014 Cardinality Estimator
SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...
2014-09-25
993 reads
SQLSaturday Orlando Marketing Plan-Part 47
Notes:
We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were...
2014-09-25
477 reads
Taking control of the ‘sa’ account for SQL Server 2012
As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...
2014-09-25
540 reads
The BaCON Debacle, or Who’s Mike?
Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...
2014-09-25
1,065 reads
Why Have a Nom Com?
I don’t want to get too deeply involved in the complaints and struggles of PASS, but I also want to...
2014-09-25
697 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