Community

Community

Inserting Images into Database

In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database. After this article you

Community

Tips from the SQL Server MVPs

Welcome to SQL Server Magazine’s monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Here are a few of the questions being answered: How do you copy permissions from a user to a database role or vice versa?How do y

Community

XML security who’s who

By Shelley Doll – When a standard is deployed as openly as XML, businesses are bound to have security concerns. The need to control content’s distribution and ensure its integrity keeps many companies from deploying XML without an extranet. Proposed standards will address security issues, and these

Community

Enforcing Association Cardinality

by Will Provost – In this article, we’ll practice a bit of that merciless science. Specifically, we’ll look at ways to control the cardinality of associations between XML elements. The basic implementation, which we’ll review momentarily, of an association between two types is simple enough but is o