31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
2011-01-18
2,518 reads
StrateSQL
XQuery for the Non-Expert – @Variable Use
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...
2011-01-17
2,700 reads
31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-17
2,056 reads
31 Days of SSIS – 10 Things About Expressions (16/31)
31 Days of SSIS
Sixteen days in and we are past the half way point for the 31 Days of SSIS...
2011-01-16
986 reads
31 Days of SSIS – Every Which Way Outputs (15/31)
31 Days of SSIS
Saturday morning and you can watch your favorite cartoon, or jump into some fun with SSIS. Today...
2011-01-15
574 reads
PASSMN January Meeting Announced
The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...
2011-01-15
609 reads
31 Days of SSIS – Instant Excel Spreadsheet (14/31)
31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking...
2011-01-14
612 reads
Last Call for Speakers 24 Hours of PASS
Calling for Presenters!Today is the day! If you were planning to submit a session for the next 24 Hours of...
2011-01-14
791 reads
31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-13
1,947 reads
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
2011-01-13
1,866 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