Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages
We bring you part 2 of a series on SSIS programming from Ira Whiteside and Actuality Business Intelligence. This article shows you how to dynamically build a package using code.
Database Encryption in SQL Server 2008 Enterprise Edition
This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed.
Parent-child dimensions in SQL Server 2005
Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
Scheduling SSIS Packages - SQL School Video
In this new SQL School video, MVP Brian Knight shows how you can schedule your SSIS packages to execute at a specific time or on a recurring schedule.
XML Import Solution
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
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