can it be overdone with check statements?

Hi,
I would assume most columns in a db would have a known valid range of values
that it makes sense for the business logics. For example, most counting
columns shouldn't have negative value even though it makes some mathetical
sense but high level application code typically doesn't handle it well. So
I'm wondering if experienced db designers would think it's worth adding a
huge check constraint to make sure all values entered into the table are
within the valid (or expected) range. thank you very much.
I'm a great fan of CHECK constraints!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Zeng" <Zeng5000@.hotmail.com> wrote in message news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> Hi,
> I would assume most columns in a db would have a known valid range of values
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well. So
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>
|||Just like Tibor, I am a great fan of Check constraints and use them
generously. However you can probably overdo anything...The reason I use so
many check constraints is that it protects the database against faulty code,
and users who bypass the application using Excel, QA, SEM or any of the
other tools easily obtainable.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zeng" <Zeng5000@.hotmail.com> wrote in message
news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> Hi,
> I would assume most columns in a db would have a known valid range of
> values
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well.
> So
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>
|||is there any advantage of having one for each isolated column in a table or
a huge one per table (with the use of AND and OR operator)?
Thanks!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uKtOgJCfFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Just like Tibor, I am a great fan of Check constraints and use them
> generously. However you can probably overdo anything...The reason I use so
> many check constraints is that it protects the database against faulty
code,[vbcol=seagreen]
> and users who bypass the application using Excel, QA, SEM or any of the
> other tools easily obtainable.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Zeng" <Zeng5000@.hotmail.com> wrote in message
> news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
mathetical[vbcol=seagreen]
a
>

can it be overdone with check statements?

Hi,
I would assume most columns in a db would have a known valid range of values
that it makes sense for the business logics. For example, most counting
columns shouldn't have negative value even though it makes some mathetical
sense but high level application code typically doesn't handle it well. So
I'm wondering if experienced db designers would think it's worth adding a
huge check constraint to make sure all values entered into the table are
within the valid (or expected) range. thank you very much.I'm a great fan of CHECK constraints!
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Zeng" <Zeng5000@.hotmail.com> wrote in message news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl..
.
> Hi,
> I would assume most columns in a db would have a known valid range of valu
es
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well. S
o
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>|||Just like Tibor, I am a great fan of Check constraints and use them
generously. However you can probably overdo anything...The reason I use so
many check constraints is that it protects the database against faulty code,
and users who bypass the application using Excel, QA, SEM or any of the
other tools easily obtainable.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zeng" <Zeng5000@.hotmail.com> wrote in message
news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> Hi,
> I would assume most columns in a db would have a known valid range of
> values
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well.
> So
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>|||is there any advantage of having one for each isolated column in a table or
a huge one per table (with the use of AND and OR operator)?
Thanks!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uKtOgJCfFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Just like Tibor, I am a great fan of Check constraints and use them
> generously. However you can probably overdo anything...The reason I use so
> many check constraints is that it protects the database against faulty
code,
> and users who bypass the application using Excel, QA, SEM or any of the
> other tools easily obtainable.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Zeng" <Zeng5000@.hotmail.com> wrote in message
> news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
mathetical[vbcol=seagreen]
a[vbcol=seagreen]
>

can it be overdone with check statements?

Hi,
I would assume most columns in a db would have a known valid range of values
that it makes sense for the business logics. For example, most counting
columns shouldn't have negative value even though it makes some mathetical
sense but high level application code typically doesn't handle it well. So
I'm wondering if experienced db designers would think it's worth adding a
huge check constraint to make sure all values entered into the table are
within the valid (or expected) range. thank you very much.I'm a great fan of CHECK constraints!
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Zeng" <Zeng5000@.hotmail.com> wrote in message news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> Hi,
> I would assume most columns in a db would have a known valid range of values
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well. So
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>|||Just like Tibor, I am a great fan of Check constraints and use them
generously. However you can probably overdo anything...The reason I use so
many check constraints is that it protects the database against faulty code,
and users who bypass the application using Excel, QA, SEM or any of the
other tools easily obtainable.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zeng" <Zeng5000@.hotmail.com> wrote in message
news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> Hi,
> I would assume most columns in a db would have a known valid range of
> values
> that it makes sense for the business logics. For example, most counting
> columns shouldn't have negative value even though it makes some mathetical
> sense but high level application code typically doesn't handle it well.
> So
> I'm wondering if experienced db designers would think it's worth adding a
> huge check constraint to make sure all values entered into the table are
> within the valid (or expected) range. thank you very much.
>|||is there any advantage of having one for each isolated column in a table or
a huge one per table (with the use of AND and OR operator)?
Thanks!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uKtOgJCfFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Just like Tibor, I am a great fan of Check constraints and use them
> generously. However you can probably overdo anything...The reason I use so
> many check constraints is that it protects the database against faulty
code,
> and users who bypass the application using Excel, QA, SEM or any of the
> other tools easily obtainable.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Zeng" <Zeng5000@.hotmail.com> wrote in message
> news:%23BEpd4AfFHA.640@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I would assume most columns in a db would have a known valid range of
> > values
> > that it makes sense for the business logics. For example, most counting
> > columns shouldn't have negative value even though it makes some
mathetical
> > sense but high level application code typically doesn't handle it well.
> > So
> > I'm wondering if experienced db designers would think it's worth adding
a
> > huge check constraint to make sure all values entered into the table are
> > within the valid (or expected) range. thank you very much.
> >
> >
>

Can I use business objects as a data source?

We have decided to use business objects in our new application, which seems to be working well, since they can be used as a binding source for grids, etc.

I am trying to evaluate whether SSIS is a practical solution for our ETL requirements. The problem is, I can't find any examples or references, or even the slightest hint that anyone is using them with business objects. Any attempts to search yield a ton of results which are based on a commercial product called "Business Objects" rather than the design pattern.

It is currently a requirement of our development team that all data access must be done via business objects, rather than communicating directly with the database.

Can anyone provide some more information (besides just suggesting I write a custom connection manager)? Is there anyone who has actually made SSIS work with business objects?

Thanks, Richard

What is a "business object"?|||I don't know what kind of information you're looking for. Yes, it can be done. Yes, you'll have to write custom components to talk to the business objects instead of the database. I've done it for Reporting Services as a custom data extension (source) and it wasn't a bunch of fun. SSIS I think would be even less. Biggest downside I can think of off-hand is that you won't be able to bulk load into the database (think row-by-row), which is going to be really painful in an ETL scenario. I've never heard of an ETL process that wasn't allowed to access the database directly.
|||I'd concur with Jay's assessment. I've done some similar work in the past. Business objects are usually not very efficient for accessing large amounts of data. If your data movement is going to be on an individual row basis, I'm not sure SSIS is the best option for implementing it.|||

We are a 3PL, so in our case, ETL is more along the lines of importing batches of orders and exporting batches of shipping confirmations from and to a variety of data formats. Row-by-row is not an issue.

It would be nice to find a working example of how to do this prior to investing a bunch of time into SSIS.

|||This sounds more like BizTalk than SSIS. It isn't your business objects that I'd be concerned about in SSIS, it's the "variety of data formats". SSIS wants to move 10,000+ rows per second between well-defined sources and destinations and do a bunch of transformations along the way. BizTalk wants to route transactions between different systems and talk different formats to each one.
|||

BizTalk has a price tag. We already have SSIS. Everything I've read to date on it indicates that it is something we should be able to use to meet our needs. I am not questioning whether SSIS is the best choice. I would like to know if anyone has used it successfully with business objects, and if so, can they provide some examples, or other helpful information.

Thanks, Richard.

|||What will your business objects be constructed as? COM objects, web services, .NET assemblies? That has an impact on how easy they are to interface with.|||

SSIS Evaluator wrote:

BizTalk has a price tag. We already have SSIS. Everything I've read to date on it indicates that it is something we should be able to use to meet our needs. I am not questioning whether SSIS is the best choice. I would like to know if anyone has used it successfully with business objects, and if so, can they provide some examples, or other helpful information.

Thanks, Richard.

Can I reiterate Phil's question (above)? What exactly are these "business objects"?

-Jamie

|||

It's a generic term for objects that represent business entities and the rules associated with those entities. So you might have a Customer business object, with all the attributes that a customer has, and methods to represent any operations that can be performed on the customer. Usually, these provide a layer of abstraction between the database and the user interface. Business objects know where their data is stored for persistence, and user interfaces request information from the business objects rather than accessing the database directly. Changes in the data from the UI are also handled through the business object. Data validation, enforcement of business rules, etc, are all handled in the business object.

In the OP's case, evidently they have made an architectural decision that all data access has to go through these business objects. As has been stated, it is possible to do this with SSIS. The degree of complexity depends in large part on how the business objects are implemented. If this is being looked at a method to handle importing or exporting data from business objects to an external database, it might work OK, assuming performance is not the major concern. If it is for business object to business object communication, I really think the OP would be better off investigating other tools.

Can I use a published report as a datasource for other reports?

Hi,

I have a data table called STOCKPE which holds stock valuation information at the close of business each day. I wish to use reporting services to extract the data in this table on a daily basis and keep a daily history on the report server. I know I can do this - this isn't my problem.

When I have the history of this table on the report server, can the data that the reports on the report server hold be used as a datasource for another report?

I'm no expert in reporting services, so if this is possible, or if there's a better way of doing it, please use small words and short sentences. No offence intended to all the very well educated SQLRS wizards out there, it's just that I'm not one of them and your answer will be lost on me if you use a lot of abreviations and acronyms.

Thanks,

Chris

Hi,

I guess you are takling about Snaphots in SQL Server RS. Snapshots are dedicted to one Report (actually its a snapshot of the report). AFAIK there is no way to base reports on other reports snapshot data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

I had a feeling this was the case but y'never know so I thought I'd ask all the same.

Thanks for your response, much appreciated.

Chris

Can I run sql server on a peer to peer network?

My dad wants me to write some inventory software for his small business (I am
an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
developer edition of sql server. My dad's company has a peer-to-peer network
(windows xp professional) and they don't want to buy a database server right
now. If I understand correctly, I can write an application for them and
deploy it with the database that I create in sql server(they don't need to
buy a seperate license, correct?). My questions are: If they deploy my
application on one of their pcs, can users on other pcs connect and run the
application (one at a time)? Will the application/database be able to handle
multiple concurrent users(5-10 users)?
Thanks for your help!
Linda Call wrote:
> My dad wants me to write some inventory software for his small
> business (I am an ex-programmer-turned-stay-at-home-mom). I have
> visual studio.net and a developer edition of sql server. My dad's
> company has a peer-to-peer network (windows xp professional) and they
> don't want to buy a database server right now. If I understand
> correctly, I can write an application for them and deploy it with the
> database that I create in sql server(they don't need to buy a
> seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and
> run the application (one at a time)? Will the application/database
> be able to handle multiple concurrent users(5-10 users)?
> Thanks for your help!
If you run SQL Server on a Windows XP PC, then you need to run the
Personal Edition, which I believe has some concurrency throttling with
more than about 5 connections. It will work with more connections, but
you won't see the same performance as the full version. Personal edition
comes with standard/EE/a and probably developer.
The developer edition of SQL Server is not licensed for use in
production environments, so legally, you'll need to purchase a new
license... Of course, you could use MSDE (MS Data engine) which is a
free version of SQL Server for small groups. No client tools are
available, but you can use the free SQL Server Web Data Administrator
for most database tasks.
David Gugick
Imceda Software
www.imceda.com
|||hi linda,
this is mahesh here
you can install sql server(your database) on any machine in your dads office
or you can access database through internet keeping at home but you have to
take care of security then
the thing is what edition yo want to install
because msde comes free & can support 5-10 users but it doesn't support very
useful features of sql sql server 2000 enterprise edition can run on any
server os and supports lot of functionality but it will be somewhat costly
as devid suggested you can use free SQL Server Web Data Administrator
but it might create security problem i don,t have great knowlege abouit this
tools
network might be any network peer to peer or client server it is ment for
data routing only
it has nothing to do with sql server
your server can be accessed by ip address only you can definately create
..net based applications
bye, have a great day
maheshmandhare@.yahoo.com
"Linda Call" wrote:

> My dad wants me to write some inventory software for his small business (I am
> an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
> developer edition of sql server. My dad's company has a peer-to-peer network
> (windows xp professional) and they don't want to buy a database server right
> now. If I understand correctly, I can write an application for them and
> deploy it with the database that I create in sql server(they don't need to
> buy a seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and run the
> application (one at a time)? Will the application/database be able to handle
> multiple concurrent users(5-10 users)?
> Thanks for your help!

Can I run sql server on a peer to peer network?

My dad wants me to write some inventory software for his small business (I a
m
an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
developer edition of sql server. My dad's company has a peer-to-peer networ
k
(windows xp professional) and they don't want to buy a database server right
now. If I understand correctly, I can write an application for them and
deploy it with the database that I create in sql server(they don't need to
buy a seperate license, correct?). My questions are: If they deploy my
application on one of their pcs, can users on other pcs connect and run the
application (one at a time)? Will the application/database be able to handl
e
multiple concurrent users(5-10 users)?
Thanks for your help!Linda Call wrote:
> My dad wants me to write some inventory software for his small
> business (I am an ex-programmer-turned-stay-at-home-mom). I have
> visual studio.net and a developer edition of sql server. My dad's
> company has a peer-to-peer network (windows xp professional) and they
> don't want to buy a database server right now. If I understand
> correctly, I can write an application for them and deploy it with the
> database that I create in sql server(they don't need to buy a
> seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and
> run the application (one at a time)? Will the application/database
> be able to handle multiple concurrent users(5-10 users)?
> Thanks for your help!
If you run SQL Server on a Windows XP PC, then you need to run the
Personal Edition, which I believe has some concurrency throttling with
more than about 5 connections. It will work with more connections, but
you won't see the same performance as the full version. Personal edition
comes with standard/EE/a and probably developer.
The developer edition of SQL Server is not licensed for use in
production environments, so legally, you'll need to purchase a new
license... Of course, you could use MSDE (MS Data engine) which is a
free version of SQL Server for small groups. No client tools are
available, but you can use the free SQL Server Web Data Administrator
for most database tasks.
David Gugick
Imceda Software
www.imceda.com|||hi linda,
this is mahesh here
you can install sql server(your database) on any machine in your dads office
or you can access database through internet keeping at home but you have to
take care of security then
the thing is what edition yo want to install
because msde comes free & can support 5-10 users but it doesn't support very
useful features of sql sql server 2000 enterprise edition can run on any
server os and supports lot of functionality but it will be somewhat costly
as devid suggested you can use free SQL Server Web Data Administrator
but it might create security problem i don,t have great knowlege abouit this
tools
network might be any network peer to peer or client server it is ment for
data routing only
it has nothing to do with sql server
your server can be accessed by ip address only you can definately create
.net based applications
bye, have a great day
maheshmandhare@.yahoo.com
"Linda Call" wrote:

> My dad wants me to write some inventory software for his small business (I
am
> an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
> developer edition of sql server. My dad's company has a peer-to-peer netw
ork
> (windows xp professional) and they don't want to buy a database server rig
ht
> now. If I understand correctly, I can write an application for them and
> deploy it with the database that I create in sql server(they don't need to
> buy a seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and run th
e
> application (one at a time)? Will the application/database be able to han
dle
> multiple concurrent users(5-10 users)?
> Thanks for your help!

Can I run sql server on a peer to peer network?

My dad wants me to write some inventory software for his small business (I am
an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
developer edition of sql server. My dad's company has a peer-to-peer network
(windows xp professional) and they don't want to buy a database server right
now. If I understand correctly, I can write an application for them and
deploy it with the database that I create in sql server(they don't need to
buy a seperate license, correct?). My questions are: If they deploy my
application on one of their pcs, can users on other pcs connect and run the
application (one at a time)? Will the application/database be able to handle
multiple concurrent users(5-10 users)?
Thanks for your help!Linda Call wrote:
> My dad wants me to write some inventory software for his small
> business (I am an ex-programmer-turned-stay-at-home-mom). I have
> visual studio.net and a developer edition of sql server. My dad's
> company has a peer-to-peer network (windows xp professional) and they
> don't want to buy a database server right now. If I understand
> correctly, I can write an application for them and deploy it with the
> database that I create in sql server(they don't need to buy a
> seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and
> run the application (one at a time)? Will the application/database
> be able to handle multiple concurrent users(5-10 users)?
> Thanks for your help!
If you run SQL Server on a Windows XP PC, then you need to run the
Personal Edition, which I believe has some concurrency throttling with
more than about 5 connections. It will work with more connections, but
you won't see the same performance as the full version. Personal edition
comes with standard/EE/a and probably developer.
The developer edition of SQL Server is not licensed for use in
production environments, so legally, you'll need to purchase a new
license... Of course, you could use MSDE (MS Data engine) which is a
free version of SQL Server for small groups. No client tools are
available, but you can use the free SQL Server Web Data Administrator
for most database tasks.
David Gugick
Imceda Software
www.imceda.com|||hi linda,
this is mahesh here
you can install sql server(your database) on any machine in your dads office
or you can access database through internet keeping at home but you have to
take care of security then
the thing is what edition yo want to install
because msde comes free & can support 5-10 users but it doesn't support very
useful features of sql sql server 2000 enterprise edition can run on any
server os and supports lot of functionality but it will be somewhat costly
as devid suggested you can use free SQL Server Web Data Administrator
but it might create security problem i don,t have great knowlege abouit this
tools
network might be any network peer to peer or client server it is ment for
data routing only
it has nothing to do with sql server
your server can be accessed by ip address only you can definately create
.net based applications
bye, have a great day
maheshmandhare@.yahoo.com
"Linda Call" wrote:
> My dad wants me to write some inventory software for his small business (I am
> an ex-programmer-turned-stay-at-home-mom). I have visual studio.net and a
> developer edition of sql server. My dad's company has a peer-to-peer network
> (windows xp professional) and they don't want to buy a database server right
> now. If I understand correctly, I can write an application for them and
> deploy it with the database that I create in sql server(they don't need to
> buy a seperate license, correct?). My questions are: If they deploy my
> application on one of their pcs, can users on other pcs connect and run the
> application (one at a time)? Will the application/database be able to handle
> multiple concurrent users(5-10 users)?
> Thanks for your help!