Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
Steve Schmidt, the backup guy for SQL Server, spent a few minutes talking about his work on SQL Server and life. A look at another very interesting member of the SQL Server development team.
By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
Keeping up with your professional development is tough. In the first part of his series, Andy Warren talked about the challenges of keeping current. This article takes a look at how you can effectively find time to grow your career.
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
We've changed the way we send email for the newsetters. Read about our new address and whitelisting.
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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,...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
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...
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