Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
154 reads
SQL Server Rocks!
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
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
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,869 reads
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
166 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
628 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
130 reads
Time for a change in career
A few months back I made the decision to leave the relative comfort and security of my permanent role and...
2014-07-09
567 reads
Deferred-drop tipping point
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,745 reads
Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,629 reads
Blogs
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers