Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
609 reads
Art
Pluralsight = Essential Training
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,342 reads
FIGlet SQLCLR ASCII Font Art
If you haven’t heard of the name before, you must have seen what it does at some point. FIGlet which...
2014-02-13
1,724 reads
Basic RegEx in SSMS
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
5,938 reads
And that is 2013
I’ve been blogging for a couple of years now and although I’ve never been a prolific blogger (and never will!),...
2013-12-23
570 reads
Getting the read/write ratio for a database
EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below...
2013-11-30
4,789 reads
Removing HTML formatting tag - BR - from XML using XQuery
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,921 reads
What to do next certification wise
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
706 reads
Just Wow!! features
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,323 reads
Crash when inserting to a FileTable with a parallel plan
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,358 reads
Blogs
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....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
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