Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
With Steve Jones on vacation, we reprint on of his more popular editorials from the past. This was originally published on Feb 14, 2005.
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
This article describes how to Evaluate Policies on Multiple Instances using EPM and PowerShell.
Spatial support is coming to SQL Azure soon, and Steve Jones thinks about how the service could improve this support.
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.
A guest editorial from Rodney Landrum looks at how we get advice from others in the wild, wild world of the Internet.
In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item 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