Find The Baseball Players
Or how to query for a particular type of customer. This article examines how you may query for particular rows that match one condition, but may not match another.
Funny SQL Server Error Messages
This is the funniest error message Brian Knight has ever seen in SQL Server.
Using Uniqueindentifier Instead of Identity
Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
DBCC SQLPERF (Logspace) Reporting Internals
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
Support for Network Database Files
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
Microsoft SQL Server OLAP Services Cell-Level Security
This article describes how SQL Server 7.0 (Service Pack 1) OLAP Services takes advantage of the user and group structure in Microsoft Windows NT to offer cell-level security, and describes several ways to tailor permissions to data across the enterprise.
Review: Professional SQL Server 2000 XML
Professional SQL Server 2000 XML - Find out if this book from Wrox is as interesting as it sounds.
Connection Pooling with Microsoft SQL Server 2000 Analysis Services
This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)
An Alternative to Windows NT
Left over from the Y2K fiasco, but a good corporate memo that might still be useful as an alternative to XP.
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