Articles

Technical Article

Working with Image Objects in InfoPath 2003 and SQL Server 2000

You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a robust and rich interface to store and access data in SQL Server databases. Learn about best practices for integrating SQL Server databases and InfoPath form data, with an illustrative example.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-22

1,146 reads

SQLServerCentral Article

Versioning

How many times has an application exploded because you upgraded or patched SQL Server? How many people were aware that a patch was applied? New author Andre Vigneau has dealt with this and gives us some code that our applications can use to check to see if anything has changed. It doesn't keep the code working, but it does allow you to inform users that something has changed.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-21

5,804 reads

Technical Article

MDX Essentials: Basic Set Functions: The EXTRACT() Function

This is the twenty-fourth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-21

1,747 reads

SQLServerCentral Article

Implementing a Flexible Backup Strategy

SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2004-10-19

11,356 reads

Technical Article

SQL Server 2000 Security - Part 13 - SQL Injection attack

Typically, access to data is provided via client applications, which increases the range of potential vulnerabilities and places an equal share of responsibility for data security on software developers. This is especially important since application flaws can have just as catastrophic implications as a misconfigured or unsecured SQL Server installation.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-19

2,337 reads

SQLServerCentral Article

Custom String Functions

SQL Server's Data Transformation Services (DTS) is a fantastic tool for importing data from any type of source. However even with this tool, you sometimes need more flexibility than it appears to have, especially if the data formats are unknown far enough in advance. New author Chris Cathers has developed a technique that allows him to be extremely flexible without causing too many headaches down the road.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-10-18

9,634 reads

SQLServerCentral Article

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2004-10-15 (first published: )

9,692 reads

Blogs

Don’t Fear the Technology

By

The concern that a particular technology is going to destroy the world seems to...

Creating a Custom SQL Server Security Checklist Using the DoD STIG

By

The STIG is detailed, which is a good thing, but I found myself wanting...

Creating a Local Model Chatbot on Windows

By

After my session at VSLive last week, I had a few questions from the...

Read the latest Blogs

Forums

Alamat BCA KCP Sopo Del Telp:0821°7555°651

By layanan_Bca88

Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...

Alamat BCA KCP South Quarter Telp:0821-8200-203

By m4rt1n4

Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...

Alamat BCA KCP Graha Paramita Telp:08218200233

By R4nt4u

Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers