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,580 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,105 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
954 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
492 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
994 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
541 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
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers