Master Data Services 2014: Creating nightly load processes
Introduction
A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into...
2014-01-02 (first published: 2013-12-23)
3,496 reads
SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!
Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...
2014-01-02
3,907 reads
Gotcha!!! Trying to install SQL Server 2012 on Windows 8.1 Professional
OK, after several tranquillizers and much grey hair, I found out why SQL Server 2012 will NOT install on Windows...
2013-12-07
8,359 reads
Setting your predicate arguments at run time Part: 2 MultiSelect
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-26
827 reads
Setting your predicate arguments at run time
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-24
941 reads
Monthly profit percentage techniques
Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...
2013-10-30
1,985 reads
Flexible Fiscal Data Sort
Flexible Fiscal Data Sorting
A few months ago, I faced the challenge of extracting data via SQL Queries (for our enterprise),...
2013-08-02
1,678 reads
Dynamic calculations of running totals
Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...
2013-06-24
1,290 reads
Monitoring SQL Server Agent job run times
Introduction
A few months back, I was asked how long a particular nightly process took to run. It was a super...
2013-05-10 (first published: 2013-04-18)
6,391 reads
Resolving data redundancy up front
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...
2013-04-22
1,277 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
An SSIS Upgrade
Comments posted to this topic are about the item An SSIS Upgrade
Question of the Day
Encoding URLs
I have this data in a 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