Articles

SQLServerCentral Article

Reduce Database RoundTrips Using XML

SQL Server 2000 added XML support to allow some basiuc manipulation of XML data. At the time, XML was a hot buzzword in the computer industry and there were lots of applications being written to use XML. While the buzz has cooled, Jon Winer still uses XML in some interesting ways to make his life easier and his applications more rebust. Here he brings us a technique he's used to reduce the number of round trips required by an application.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-11-29

9,436 reads

Technical Article

Data Sanitization Techniques

Data Sanitization is the process of making sensitive information in non-production databases safe for wider visibility. This White Paper is an overview of various techniques which can be used to sanitize sensitive production data in test and development databases.

2004-11-29

1,885 reads

Technical Article

Common Vulnerabilities in Database Security

Creating an enterprise security plan is a complex endeavour. It involves evaluating multiple threats that gain access through many network paths to a hodgepodge of different applications and systems. With the focus on systems and paths, databases are frequently overlooked. Securing the database should be a fundamental tenet for any security practitioner when developing his or her security plan. The database is the source of data, the "crown jewels" in the information economy. Any security effort must start with this in mind and end with the strongest level of controls applied at the database layer.

2004-11-26

2,129 reads

SQLServerCentral Article

Clustering SQL Server 2000 from 500 Feet

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2004-11-25 (first published: )

68,322 reads

Technical Article

Building a 24 x 7 Database

Over the last few years, corporations have invested billions of dollars to integrate the automations of core business systems in large ERP applications. This paper looks at the risk of downtime and solutions for building an around-the-clock database.

2004-11-24

2,129 reads

SQLServerCentral Article

SQL MAIL Using POP3 and SMTP

SQL Server has a great build in messaging system with SQLMail. Unfortunately it requires Outlook and Exchange to work properly. Some people don't like this or do not run Exchange and have issues getting it to work. Gregory Larsen takes a look at how you can use SMTP to send email from SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-11-23

21,137 reads

Technical Article

Updating Data in Linked Servers, Information Schema Views, and More

E
very day a developer somewhere needs to write code to iterate through SQL Server™ system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata. In this month's column, I will address these and other T-SQL development scenarios based on some of the questions I most frequently receive from readers.

2004-11-23

1,686 reads

Blogs

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Do This Before You Contact Your SQL Server Consultant

By

Say you need outside help. You’ve exhausted all the things that you could do...

Microsoft MVP 2026: Ten Years on the Data Platform

By

I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...

Read the latest Blogs

Forums

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

BIT_COUNT() III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() III

The Mythical Bus Accident

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Mythical Bus Accident

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code: 

select bit_count(-1)
What is returned?

See possible answers