The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.
2001-12-25
1,855 reads
Happy Holidays database administrators! As a parting present before you go home for your year-end break, Microsoft has announced a security problem in SQL Server 7.0 and 2000.
2001-12-24
6,569 reads
This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.
2001-12-06
1,547 reads
One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?
2001-12-04
6,236 reads
This past week, a worm virus began to attack SQL Servers on the internet that hold a blank password. Read some of the details about what this virus can do here.
2001-12-03
13,224 reads
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
2001-11-06
7,248 reads
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.
2001-07-19
14,941 reads
2001-07-19
2,600 reads
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