Hi,
I'm ussually just told what I will be working with, but today I was asked to
choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But
also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million
records per calculation (yes, that's the spec). I'm using SQLServer 2000
(possibly 2005 if my employer wants to risk it), and ASP.NET. The
calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance,
John
huh ? well barnes and nobles thought it was good enough + 2 years ago
when it was still in early Beta so risk wich risk ? ,,,,,
Well first tip use a seperate Web and SQL server this is much better
scalable
for business servers i would go for the poweredge series of DELL maybe two
2850 `s ' one with 2 gb ( for the webserver ) and the other one with as
much memory as fits in the budget for the sql database
regards
Michel Posseth
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>|||Your not going to get a one line answer, as database sizing and web server
sizing are entirely different things and you've not hinted at whether you
expect different servers, raid clusters, resilience, failover, SAN/NAS
storage, lots of web traffic - only that you expect the database to be quite
busy. You've neitehr said if your 100 mill records are 1 bit large, or 1
meg each split across many tables, 1 user per hour or 100,000 per second -
and of course it all counts.
This is not a simple job, and if I was you I would be going back to whoever
asked you to chose the hardware and tell them you need to speak to the
hardware vendor, as they can normally help you make some initial estimates
and suggest appropriate hardware. Dont be fooled by your company being
small, for a high performance database you will easily spent $10,000.
A bit of light reading to get you started
http://www.sql-server-performance.c...re_planning.asp
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>|||"John Timney ( MVP )" <timneyj@.despammed.com> wrote in message
news:uZnMnzg5FHA.3188@.TK2MSFTNGP15.phx.gbl...
> Your not going to get a one line answer, as database sizing and web server
> sizing are entirely different things and you've not hinted at whether you
> expect different servers, raid clusters, resilience, failover, SAN/NAS
> storage, lots of web traffic - only that you expect the database to be
> quite busy. You've neitehr said if your 100 mill records are 1 bit large,
> or 1 meg each split across many tables, 1 user per hour or 100,000 per
> second - and of course it all counts.
> This is not a simple job, and if I was you I would be going back to
> whoever asked you to chose the hardware and tell them you need to speak to
> the hardware vendor, as they can normally help you make some initial
> estimates and suggest appropriate hardware. Dont be fooled by your
> company being small, for a high performance database you will easily spent
> $10,000.
> A bit of light reading to get you started
> http://www.sql-server-performance.c...re_planning.asp
> --
> Regards
>
Thanks, I will look at the URL.
BTW-There will probably be about 10 users, who will all together, probably
run less than 20 different scenarios per week. So not a lot of load. And
the records will be over 4 tables.
Thanks again,
John|||My 2 cents:
1. By the fastest disk you can find.
2. A single processor will obviously be slower than 2, 4, etc. This
factors out to exponentially slower calculations.
3. $10,000 isn't even nearly adequate unless your willing to wait, and
wait, and wait, and wait.....
4. Given the limited information you've provided I'd assume a 4 processor
machine with 4 GB of ram would still be painfully slow.
5. I agree with waiting on SQL 2005. Let everyone else experiment for 6
months. Microsoft has done their due dilligence but I'd wager there are
things out there waiting to nail people. I'm already seeing things in the
news groups about why things aren't working (Security is enable by default),
patches bringing servers down (Saw that one today in the setup newsgroup),
etc.
"John" wrote:
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
to
> choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option. Bu
t
> also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
>
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Friday, March 30, 2012
Need help choosing Server Hardware
Hi,
I'm ussually just told what I will be working with, but today I was asked to
choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But
also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million
records per calculation (yes, that's the spec). I'm using SQLServer 2000
(possibly 2005 if my employer wants to risk it), and ASP.NET. The
calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance,
John
[vbcol=seagreen]
huh ? well barnes and nobles thought it was good enough + 2 years ago
when it was still in early Beta so risk wich risk ? ,,,,,
Well first tip use a seperate Web and SQL server this is much better
scalable
for business servers i would go for the poweredge series of DELL maybe two
2850 `s ? one with 2 gb ( for the webserver ) and the other one with as
much memory as fits in the budget for the sql database
regards
Michel Posseth
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
|||Your not going to get a one line answer, as database sizing and web server
sizing are entirely different things and you've not hinted at whether you
expect different servers, raid clusters, resilience, failover, SAN/NAS
storage, lots of web traffic - only that you expect the database to be quite
busy. You've neitehr said if your 100 mill records are 1 bit large, or 1
meg each split across many tables, 1 user per hour or 100,000 per second -
and of course it all counts.
This is not a simple job, and if I was you I would be going back to whoever
asked you to chose the hardware and tell them you need to speak to the
hardware vendor, as they can normally help you make some initial estimates
and suggest appropriate hardware. Dont be fooled by your company being
small, for a high performance database you will easily spent $10,000.
A bit of light reading to get you started
http://www.sql-server-performance.co...e_planning.asp
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
|||"John Timney ( MVP )" <timneyj@.despammed.com> wrote in message
news:uZnMnzg5FHA.3188@.TK2MSFTNGP15.phx.gbl...
> Your not going to get a one line answer, as database sizing and web server
> sizing are entirely different things and you've not hinted at whether you
> expect different servers, raid clusters, resilience, failover, SAN/NAS
> storage, lots of web traffic - only that you expect the database to be
> quite busy. You've neitehr said if your 100 mill records are 1 bit large,
> or 1 meg each split across many tables, 1 user per hour or 100,000 per
> second - and of course it all counts.
> This is not a simple job, and if I was you I would be going back to
> whoever asked you to chose the hardware and tell them you need to speak to
> the hardware vendor, as they can normally help you make some initial
> estimates and suggest appropriate hardware. Dont be fooled by your
> company being small, for a high performance database you will easily spent
> $10,000.
> A bit of light reading to get you started
> http://www.sql-server-performance.co...e_planning.asp
> --
> Regards
>
Thanks, I will look at the URL.
BTW-There will probably be about 10 users, who will all together, probably
run less than 20 different scenarios per week. So not a lot of load. And
the records will be over 4 tables.
Thanks again,
John
|||My 2 cents:
1. By the fastest disk you can find.
2. A single processor will obviously be slower than 2, 4, etc. This
factors out to exponentially slower calculations.
3. $10,000 isn't even nearly adequate unless your willing to wait, and
wait, and wait, and wait.....
4. Given the limited information you've provided I'd assume a 4 processor
machine with 4 GB of ram would still be painfully slow.
5. I agree with waiting on SQL 2005. Let everyone else experiment for 6
months. Microsoft has done their due dilligence but I'd wager there are
things out there waiting to nail people. I'm already seeing things in the
news groups about why things aren't working (Security is enable by default),
patches bringing servers down (Saw that one today in the setup newsgroup),
etc.
"John" wrote:
> Hi,
> I'm ussually just told what I will be working with, but today I was asked to
> choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option. But
> also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
>
I'm ussually just told what I will be working with, but today I was asked to
choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But
also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million
records per calculation (yes, that's the spec). I'm using SQLServer 2000
(possibly 2005 if my employer wants to risk it), and ASP.NET. The
calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance,
John
[vbcol=seagreen]
huh ? well barnes and nobles thought it was good enough + 2 years ago
when it was still in early Beta so risk wich risk ? ,,,,,
Well first tip use a seperate Web and SQL server this is much better
scalable
for business servers i would go for the poweredge series of DELL maybe two
2850 `s ? one with 2 gb ( for the webserver ) and the other one with as
much memory as fits in the budget for the sql database
regards
Michel Posseth
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
|||Your not going to get a one line answer, as database sizing and web server
sizing are entirely different things and you've not hinted at whether you
expect different servers, raid clusters, resilience, failover, SAN/NAS
storage, lots of web traffic - only that you expect the database to be quite
busy. You've neitehr said if your 100 mill records are 1 bit large, or 1
meg each split across many tables, 1 user per hour or 100,000 per second -
and of course it all counts.
This is not a simple job, and if I was you I would be going back to whoever
asked you to chose the hardware and tell them you need to speak to the
hardware vendor, as they can normally help you make some initial estimates
and suggest appropriate hardware. Dont be fooled by your company being
small, for a high performance database you will easily spent $10,000.
A bit of light reading to get you started
http://www.sql-server-performance.co...e_planning.asp
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"John" <pls@.dontspamme.com> wrote in message
news:eo1Vabg5FHA.2628@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm ussually just told what I will be working with, but today I was asked
> to choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option.
> But also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
|||"John Timney ( MVP )" <timneyj@.despammed.com> wrote in message
news:uZnMnzg5FHA.3188@.TK2MSFTNGP15.phx.gbl...
> Your not going to get a one line answer, as database sizing and web server
> sizing are entirely different things and you've not hinted at whether you
> expect different servers, raid clusters, resilience, failover, SAN/NAS
> storage, lots of web traffic - only that you expect the database to be
> quite busy. You've neitehr said if your 100 mill records are 1 bit large,
> or 1 meg each split across many tables, 1 user per hour or 100,000 per
> second - and of course it all counts.
> This is not a simple job, and if I was you I would be going back to
> whoever asked you to chose the hardware and tell them you need to speak to
> the hardware vendor, as they can normally help you make some initial
> estimates and suggest appropriate hardware. Dont be fooled by your
> company being small, for a high performance database you will easily spent
> $10,000.
> A bit of light reading to get you started
> http://www.sql-server-performance.co...e_planning.asp
> --
> Regards
>
Thanks, I will look at the URL.
BTW-There will probably be about 10 users, who will all together, probably
run less than 20 different scenarios per week. So not a lot of load. And
the records will be over 4 tables.
Thanks again,
John
|||My 2 cents:
1. By the fastest disk you can find.
2. A single processor will obviously be slower than 2, 4, etc. This
factors out to exponentially slower calculations.
3. $10,000 isn't even nearly adequate unless your willing to wait, and
wait, and wait, and wait.....
4. Given the limited information you've provided I'd assume a 4 processor
machine with 4 GB of ram would still be painfully slow.
5. I agree with waiting on SQL 2005. Let everyone else experiment for 6
months. Microsoft has done their due dilligence but I'd wager there are
things out there waiting to nail people. I'm already seeing things in the
news groups about why things aren't working (Security is enable by default),
patches bringing servers down (Saw that one today in the setup newsgroup),
etc.
"John" wrote:
> Hi,
> I'm ussually just told what I will be working with, but today I was asked to
> choose the hardware myself.
> First off, it's a small company, so a $10,000 server is not an option. But
> also, a $500 box isn't going to cut it either.
> Basically, I am builing a web app which generates from 10-100 million
> records per calculation (yes, that's the spec). I'm using SQLServer 2000
> (possibly 2005 if my employer wants to risk it), and ASP.NET. The
> calculations are all done in stored procedures.
> Comments, suggestions, and URLs are much appreciated.
> Thanks in advance,
> John
>
>
Friday, March 23, 2012
Need DW/AS Evangelism information
I have recently created cubes using the company I work
for data. I would like to switch form using Crystal
Reports to using AS and Reporting Services.
However I am not the greatest public speaker. Does anyone
know where I can find a few good web pages that will help
to convince my bosses that using AS is the way to go as
well as Reporting Services. In other words I need to
become a Data Warehouse Evangelist.
Can I get an Amen from the congregation.
(the following questions can be asked by your "opponents")
Why do you want to change a working technology in your company?
if CR is used and works fine, why changing to a new technology?
What are the costs advantages?
What we can't do today and we will do with a DW?
Using a reporting solution does not need datawarehouse, today a lot of
reports can be generated directly from an operationnal system. So if you ask
for a datawarehouse solution, is that because you want to provide more power
and new features to your users, so its a good argument for you.
Providing ad-hoc analysis features is a good point which required a
datawarehouse. And using this datawarehouse for the end users reports is
important to make sure that everyone will see the same cleansed information.
But does your user really need ad-hoc access?
If a user open 1 report by month, too bad. If a user asked you for a new
report every day, you have found the solution.
Crystal report cannot be compared to analysis services and a datawarehouse
solution!
So switching from a simple reporting solution to an ad-hoc query solution
based on OLAP cubes + reports is not allways simple. You'll win only if your
boss need to have answers to questions and if today these answers takes a
long process.
No added value, you'll loose.
Find a guy who need this type of solution in your company (like a HR analyst
or financial manager...) and this person will help you to promote your idea.
No sponsor, no success.
From my experience, if you found a process improoved by a datwarehouse
solution, you win.
In my job, I have reduced the time to create the budget from 2 months to
1week.
I have provided near real time access to information only available only 1
time a day before, and with a higher data quality (in a manufacturing
company).
In another hand, I have projects failure: too complex system not used by the
end user is the first reason. Data not needed by the end user in the
datawarehouse. Bad change management following the project=not used project.
Be prepared for a lot of questions is your better way to win.
Propose a prototype is also a good way to convince you boss, if they can
compare the old and new version of their job, they promote you :-)
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:0aa801c52bfc$c6e5f780$a501280a@.phx.gbl...
>I have recently created cubes using the company I work
> for data. I would like to switch form using Crystal
> Reports to using AS and Reporting Services.
> However I am not the greatest public speaker. Does anyone
> know where I can find a few good web pages that will help
> to convince my bosses that using AS is the way to go as
> well as Reporting Services. In other words I need to
> become a Data Warehouse Evangelist.
> Can I get an Amen from the congregation.
>
for data. I would like to switch form using Crystal
Reports to using AS and Reporting Services.
However I am not the greatest public speaker. Does anyone
know where I can find a few good web pages that will help
to convince my bosses that using AS is the way to go as
well as Reporting Services. In other words I need to
become a Data Warehouse Evangelist.
Can I get an Amen from the congregation.
(the following questions can be asked by your "opponents")
Why do you want to change a working technology in your company?
if CR is used and works fine, why changing to a new technology?
What are the costs advantages?
What we can't do today and we will do with a DW?
Using a reporting solution does not need datawarehouse, today a lot of
reports can be generated directly from an operationnal system. So if you ask
for a datawarehouse solution, is that because you want to provide more power
and new features to your users, so its a good argument for you.
Providing ad-hoc analysis features is a good point which required a
datawarehouse. And using this datawarehouse for the end users reports is
important to make sure that everyone will see the same cleansed information.
But does your user really need ad-hoc access?
If a user open 1 report by month, too bad. If a user asked you for a new
report every day, you have found the solution.
Crystal report cannot be compared to analysis services and a datawarehouse
solution!
So switching from a simple reporting solution to an ad-hoc query solution
based on OLAP cubes + reports is not allways simple. You'll win only if your
boss need to have answers to questions and if today these answers takes a
long process.
No added value, you'll loose.
Find a guy who need this type of solution in your company (like a HR analyst
or financial manager...) and this person will help you to promote your idea.
No sponsor, no success.
From my experience, if you found a process improoved by a datwarehouse
solution, you win.
In my job, I have reduced the time to create the budget from 2 months to
1week.
I have provided near real time access to information only available only 1
time a day before, and with a higher data quality (in a manufacturing
company).
In another hand, I have projects failure: too complex system not used by the
end user is the first reason. Data not needed by the end user in the
datawarehouse. Bad change management following the project=not used project.
Be prepared for a lot of questions is your better way to win.
Propose a prototype is also a good way to convince you boss, if they can
compare the old and new version of their job, they promote you :-)
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:0aa801c52bfc$c6e5f780$a501280a@.phx.gbl...
>I have recently created cubes using the company I work
> for data. I would like to switch form using Crystal
> Reports to using AS and Reporting Services.
> However I am not the greatest public speaker. Does anyone
> know where I can find a few good web pages that will help
> to convince my bosses that using AS is the way to go as
> well as Reporting Services. In other words I need to
> become a Data Warehouse Evangelist.
> Can I get an Amen from the congregation.
>
Need DW/AS Evangelism information
I have recently created cubes using the company I work
for data. I would like to switch form using Crystal
Reports to using AS and Reporting Services.
However I am not the greatest public speaker. Does anyone
know where I can find a few good web pages that will help
to convince my bosses that using AS is the way to go as
well as Reporting Services. In other words I need to
become a Data Warehouse Evangelist.
Can I get an Amen from the congregation.(the following questions can be asked by your "opponents")
Why do you want to change a working technology in your company?
if CR is used and works fine, why changing to a new technology?
What are the costs advantages?
What we can't do today and we will do with a DW?
Using a reporting solution does not need datawarehouse, today a lot of
reports can be generated directly from an operationnal system. So if you ask
for a datawarehouse solution, is that because you want to provide more power
and new features to your users, so its a good argument for you.
Providing ad-hoc analysis features is a good point which required a
datawarehouse. And using this datawarehouse for the end users reports is
important to make sure that everyone will see the same cleansed information.
But does your user really need ad-hoc access?
If a user open 1 report by month, too bad. If a user asked you for a new
report every day, you have found the solution.
Crystal report cannot be compared to analysis services and a datawarehouse
solution!
So switching from a simple reporting solution to an ad-hoc query solution
based on OLAP cubes + reports is not allways simple. You'll win only if your
boss need to have answers to questions and if today these answers takes a
long process.
No added value, you'll loose.
Find a guy who need this type of solution in your company (like a HR analyst
or financial manager...) and this person will help you to promote your idea.
No sponsor, no success.
From my experience, if you found a process improoved by a datwarehouse
solution, you win.
In my job, I have reduced the time to create the budget from 2 months to
1week.
I have provided near real time access to information only available only 1
time a day before, and with a higher data quality (in a manufacturing
company).
In another hand, I have projects failure: too complex system not used by the
end user is the first reason. Data not needed by the end user in the
datawarehouse. Bad change management following the project=not used project.
Be prepared for a lot of questions is your better way to win.
Propose a prototype is also a good way to convince you boss, if they can
compare the old and new version of their job, they promote you :-)
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:0aa801c52bfc$c6e5f780$a501280a@.phx.gbl...
>I have recently created cubes using the company I work
> for data. I would like to switch form using Crystal
> Reports to using AS and Reporting Services.
> However I am not the greatest public speaker. Does anyone
> know where I can find a few good web pages that will help
> to convince my bosses that using AS is the way to go as
> well as Reporting Services. In other words I need to
> become a Data Warehouse Evangelist.
> Can I get an Amen from the congregation.
>
for data. I would like to switch form using Crystal
Reports to using AS and Reporting Services.
However I am not the greatest public speaker. Does anyone
know where I can find a few good web pages that will help
to convince my bosses that using AS is the way to go as
well as Reporting Services. In other words I need to
become a Data Warehouse Evangelist.
Can I get an Amen from the congregation.(the following questions can be asked by your "opponents")
Why do you want to change a working technology in your company?
if CR is used and works fine, why changing to a new technology?
What are the costs advantages?
What we can't do today and we will do with a DW?
Using a reporting solution does not need datawarehouse, today a lot of
reports can be generated directly from an operationnal system. So if you ask
for a datawarehouse solution, is that because you want to provide more power
and new features to your users, so its a good argument for you.
Providing ad-hoc analysis features is a good point which required a
datawarehouse. And using this datawarehouse for the end users reports is
important to make sure that everyone will see the same cleansed information.
But does your user really need ad-hoc access?
If a user open 1 report by month, too bad. If a user asked you for a new
report every day, you have found the solution.
Crystal report cannot be compared to analysis services and a datawarehouse
solution!
So switching from a simple reporting solution to an ad-hoc query solution
based on OLAP cubes + reports is not allways simple. You'll win only if your
boss need to have answers to questions and if today these answers takes a
long process.
No added value, you'll loose.
Find a guy who need this type of solution in your company (like a HR analyst
or financial manager...) and this person will help you to promote your idea.
No sponsor, no success.
From my experience, if you found a process improoved by a datwarehouse
solution, you win.
In my job, I have reduced the time to create the budget from 2 months to
1week.
I have provided near real time access to information only available only 1
time a day before, and with a higher data quality (in a manufacturing
company).
In another hand, I have projects failure: too complex system not used by the
end user is the first reason. Data not needed by the end user in the
datawarehouse. Bad change management following the project=not used project.
Be prepared for a lot of questions is your better way to win.
Propose a prototype is also a good way to convince you boss, if they can
compare the old and new version of their job, they promote you :-)
"Phil396" <anonymous@.discussions.microsoft.com> wrote in message
news:0aa801c52bfc$c6e5f780$a501280a@.phx.gbl...
>I have recently created cubes using the company I work
> for data. I would like to switch form using Crystal
> Reports to using AS and Reporting Services.
> However I am not the greatest public speaker. Does anyone
> know where I can find a few good web pages that will help
> to convince my bosses that using AS is the way to go as
> well as Reporting Services. In other words I need to
> become a Data Warehouse Evangelist.
> Can I get an Amen from the congregation.
>
need direction on SSB replacing existing technology
Hello, I have an existing suite of applications in my company where remote laptop users enter data into a local database instance. There are several different applications with several different databases (some users run application A and C, others run A and B and D, etc). All of this data needs to make its way into both their local databases, and to the front office database. In addition, some of the data goes out of the front office to other end users (supervisors get data from people under them).
Currently, we get the data back and forth by creating text files full of SQL statements that are run on either the end user servers or the main server, and we zip and ftp these SQL Script files back and forth.
I am looking into the benefits of replacing this process with a Service Broker application, but I'm still too much of a newbie to understand how this might work. What should my messages contain? Should they contain the same SQL statements that are currently in the script files, and then a SSB process would grab the SQL and run it? Or should the message types be more specific to each application?
any pointers to articles that go beyond "here's what SSB is" would be appreciated.
matt tagliaferri
Why aren't you considering SQL Server Replication?|||I've used replication for other tasks - I've found it to be a bit difficult to manage and troubleshoot. Ansynchonous messaging seems to most closely match our existing method of sending the data around (scripts via ftp).
matt tag
|||
Implementing replication on top of Service Broker will require a lot of effort in terms of building the plumbing to read/write data, marshalling/unmarshalling, managing schemas, monitoring, configuration, etc. I'm not sure if it actually helps reduce the problem.
Service Broker is useful when you truely want to build loosely-coupled apps. That is apps that are not bound w.r.t. availability, time, schemas, administrative control, identities, scalability, etc. But it is more general purpose than replication and therefore requires more effort.
Monday, March 19, 2012
Need an opinion
Over the past two years (and with the help of many of you), I have created a CMMS that is used by my company. I have all the machine data stored in SQL Server. I have used MS Access and ASP's as the front end for data entry. I use SQL Server Agent to run exception reporting (email).
When I started I had no Experience at all with programming other than classes taken 98-99 (html, C++, vb).
Having said that, I am sure some of you can recall your first attempts at creating an app. With the constant upgrades to do more stuff, I am at the point that I need to go back and clean up (remove obsolete code).
Now for the question. I want to revamp my front-end particularly the Access App. If you were going to create a new app for data entry/reporting and your main strength was vbscript, what would you use?
Thanks,
LeeVB.Net of course.|||Originally posted by joejcheng
VB.Net of course.
I have created asp's using vbscript, but how does one get started with VB.net?|||My recommendation would be c#. There are enough differences between vbscript and vb.net that transitioning to c# is marginally steeper - c# also encourages better techniques for object oriented development. Also, you can translate easily to java once you have learned c#.
Anyway, research books on amazon.com to see which books would best suit your needs (whether it be vb.net or c#). Also, which will you focus more on - windows or web development. If you will develop in asp.net, then search for the appropriate books. Do you have access to visual studio .net or 2003 ?|||I have visual studio V6 but it is not .net|||At one point ms had a $50 upgrade from vs 6 to .net - but that does not exist anymore. Well if you can get .net then do so. If not, then you can develop with vs6 using visual interdev developing asp web pages using vbscript/javascript. But I would push your company to purchase the .net ide because ms is starting to drop support/distribution for several applications including those that deal with asp.|||"Front end" applications ought to be simple .. as simple as possible .. and there's usually a lot of rationale for "stick with the devil you know." That would be Visual Basic in some variation or another. And if possible, it ought to be the existing application if you can possibly do it.
First, you should carefully and systematically identify exactly what it is about the present application that compels you to replace it. That makes it absolutely essential to commit many thousands of dollars to doing so (even if you'll be the one who receives most of those dollars!). You need to be able to write down exactly what the deficiencies are, exactly how you'd be able to recognize an appropriate solution to those deficiencies if one hit you in the face (a solution, that is, not a deficiency...), and you ought to be able to defend those conclusions and decisions against your favorite "devil's advocate." Think from the business's point of view, not your own, and defend your company's supply of liquid cash as hard as you can. It's a good exercise.
You ought to thoroughly explore the "build vs. buy" decision angle: why is it impossible for your business not to simply buy a solution? Is your company really the first one to have been faced with this problem? Has no one solved it before? If such a solution does exist, how much would that alternative cost? (And don't blink at "$50,000" 'cuz your alternative might cost more. Again, be honest. Even cynical.)
If the true answer is, "well, I wanna learn another language and this sounds like a good excuse to do it," :rolleyes: be honest, from a business point of view that don't wash. :)
Maybe the existing application can be tweaked a little and fixed. You've put a lot of time into what you have now and it's tough to justify scrapping it.
These are the kinds of arguments you should impose on yourself. If your project flies through all of this self-imposed rigor, then :D ... you've found a project really worth doing, and you'll have developed a crystalline idea of exactly how to succeed with it.|||First you must know that in the beginning my job was to "administrator" a canned MMS and not in the development of a program. My background is in day to day maintenance of machinery. I wear several hats and the developer is not even in the job description. It is something that has happened out of necessity.
It is kinda complicated, but the short of it is that my program is very custom to our plant, and in the past 6 months, I have had several people from other plants and divisions come in to review our maintenance program. All have liked our program as it keeps the end user in mind, but because it is so custom it is not easily transferable. It combines machine history with plant performance down to the operator.
What I would like to do is take the custom code (machine specific to our plant hard coded in) out and make it dynamic, so that it would work for other plants. I want to do in a way that is most efficient and most appealing to the user. And in that I mean low resource usage (hardware and peoples time).
I understand your last 4 paragraphs and that is the reason that the majority of the redo will be done by me on my own as an opportunity to continue to grow as a developer. Having said that, that is why I am wanting to find a platform that is easy to learn and not expensive to purchase as an individual.
When I started I had no Experience at all with programming other than classes taken 98-99 (html, C++, vb).
Having said that, I am sure some of you can recall your first attempts at creating an app. With the constant upgrades to do more stuff, I am at the point that I need to go back and clean up (remove obsolete code).
Now for the question. I want to revamp my front-end particularly the Access App. If you were going to create a new app for data entry/reporting and your main strength was vbscript, what would you use?
Thanks,
LeeVB.Net of course.|||Originally posted by joejcheng
VB.Net of course.
I have created asp's using vbscript, but how does one get started with VB.net?|||My recommendation would be c#. There are enough differences between vbscript and vb.net that transitioning to c# is marginally steeper - c# also encourages better techniques for object oriented development. Also, you can translate easily to java once you have learned c#.
Anyway, research books on amazon.com to see which books would best suit your needs (whether it be vb.net or c#). Also, which will you focus more on - windows or web development. If you will develop in asp.net, then search for the appropriate books. Do you have access to visual studio .net or 2003 ?|||I have visual studio V6 but it is not .net|||At one point ms had a $50 upgrade from vs 6 to .net - but that does not exist anymore. Well if you can get .net then do so. If not, then you can develop with vs6 using visual interdev developing asp web pages using vbscript/javascript. But I would push your company to purchase the .net ide because ms is starting to drop support/distribution for several applications including those that deal with asp.|||"Front end" applications ought to be simple .. as simple as possible .. and there's usually a lot of rationale for "stick with the devil you know." That would be Visual Basic in some variation or another. And if possible, it ought to be the existing application if you can possibly do it.
First, you should carefully and systematically identify exactly what it is about the present application that compels you to replace it. That makes it absolutely essential to commit many thousands of dollars to doing so (even if you'll be the one who receives most of those dollars!). You need to be able to write down exactly what the deficiencies are, exactly how you'd be able to recognize an appropriate solution to those deficiencies if one hit you in the face (a solution, that is, not a deficiency...), and you ought to be able to defend those conclusions and decisions against your favorite "devil's advocate." Think from the business's point of view, not your own, and defend your company's supply of liquid cash as hard as you can. It's a good exercise.
You ought to thoroughly explore the "build vs. buy" decision angle: why is it impossible for your business not to simply buy a solution? Is your company really the first one to have been faced with this problem? Has no one solved it before? If such a solution does exist, how much would that alternative cost? (And don't blink at "$50,000" 'cuz your alternative might cost more. Again, be honest. Even cynical.)
If the true answer is, "well, I wanna learn another language and this sounds like a good excuse to do it," :rolleyes: be honest, from a business point of view that don't wash. :)
Maybe the existing application can be tweaked a little and fixed. You've put a lot of time into what you have now and it's tough to justify scrapping it.
These are the kinds of arguments you should impose on yourself. If your project flies through all of this self-imposed rigor, then :D ... you've found a project really worth doing, and you'll have developed a crystalline idea of exactly how to succeed with it.|||First you must know that in the beginning my job was to "administrator" a canned MMS and not in the development of a program. My background is in day to day maintenance of machinery. I wear several hats and the developer is not even in the job description. It is something that has happened out of necessity.
It is kinda complicated, but the short of it is that my program is very custom to our plant, and in the past 6 months, I have had several people from other plants and divisions come in to review our maintenance program. All have liked our program as it keeps the end user in mind, but because it is so custom it is not easily transferable. It combines machine history with plant performance down to the operator.
What I would like to do is take the custom code (machine specific to our plant hard coded in) out and make it dynamic, so that it would work for other plants. I want to do in a way that is most efficient and most appealing to the user. And in that I mean low resource usage (hardware and peoples time).
I understand your last 4 paragraphs and that is the reason that the majority of the redo will be done by me on my own as an opportunity to continue to grow as a developer. Having said that, that is why I am wanting to find a platform that is easy to learn and not expensive to purchase as an individual.
Need an easy way to replicate SQL Server Database
Dear Sir/Madam,
Hello,
I'm a MCSA and administrator of a large scale company, we have two
member server (with the same hardware configuration) that both have SQL
Server.
On one of these servers we have a SQL database that it stored more than
600,000,000 characters and everyday 700,000 characters added to it.
I really don't have information about SQL Server , Databases and how to
replicate them.
Would you please guide me that how can I easily replicate this important
database in these both servers, to have a redundant databases?
Yours Sincerely,
Ahmad Reza
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Ahmad,
there are various options for redundant databases. The classical one for
your situation is not actually replication, but is log shipping. There is
plenty of information in books on line about how to set it up (quite
straightforward). To use it out of the box, you'll need enterprise edition
of sql server, but if you have standard then there are scripts on the
resource kit to do it. There are other options and in a previous post
Michael Hotek lists his selection in this order which I agree with:
1. Transactional with queued updating
2. Merge
3. Transactional
Please post up any further questions.
Regards,
Paul Ibison
|||I would suggesting looking at the information in SQL Server 2000 Books on
Line. The types of replication available in SQL Server 2000 are documented
there as well as how to set them up.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I would also add that the word "easy" doesn't come into play here. Is it
complicated? No. Is it complex? Yes. You need a good understanding of
what a SQL Server is, what it does, and how it operates before even
attempting replication. If you don't start there, it is a very quick route
to blowing up an environment. That is NOT due to replication. It is due to
the way that data reacts and is handled in a distributed environment that
introduces many added challenges that simply don't exist on a single
machine. If there is a way to accomplish what you need without using
replication, my strong recommendation is to use the other solution.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Hello,
I'm a MCSA and administrator of a large scale company, we have two
member server (with the same hardware configuration) that both have SQL
Server.
On one of these servers we have a SQL database that it stored more than
600,000,000 characters and everyday 700,000 characters added to it.
I really don't have information about SQL Server , Databases and how to
replicate them.
Would you please guide me that how can I easily replicate this important
database in these both servers, to have a redundant databases?
Yours Sincerely,
Ahmad Reza
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Ahmad,
there are various options for redundant databases. The classical one for
your situation is not actually replication, but is log shipping. There is
plenty of information in books on line about how to set it up (quite
straightforward). To use it out of the box, you'll need enterprise edition
of sql server, but if you have standard then there are scripts on the
resource kit to do it. There are other options and in a previous post
Michael Hotek lists his selection in this order which I agree with:
1. Transactional with queued updating
2. Merge
3. Transactional
Please post up any further questions.
Regards,
Paul Ibison
|||I would suggesting looking at the information in SQL Server 2000 Books on
Line. The types of replication available in SQL Server 2000 are documented
there as well as how to set them up.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I would also add that the word "easy" doesn't come into play here. Is it
complicated? No. Is it complex? Yes. You need a good understanding of
what a SQL Server is, what it does, and how it operates before even
attempting replication. If you don't start there, it is a very quick route
to blowing up an environment. That is NOT due to replication. It is due to
the way that data reacts and is handled in a distributed environment that
introduces many added challenges that simply don't exist on a single
machine. If there is a way to accomplish what you need without using
replication, my strong recommendation is to use the other solution.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Need an allround DBA (development&Admin) in MSSQL and Oracle
All,
International company in Australia needs an allround DBA
(development&Admin) in MSSQL and Oracle.
If you have 5+ experience in development and (not OR) Administration in
both MSSQL and Oracle and like challenges, please send CV to
rooty_hill2002@.yahoo.com.au.
I will send the position description to suitable candidates.
Cheers,
YakSorry, the email box is not shown properly. It should be
rooty_hill2002@.yahoo.com.au|||I don't know what happened! The email box is still not shown properly!
It should have "rooty_hill2002" in front of @.!
Monday, March 12, 2012
need advices on database server Architecture!
i recently started working for a smaller company. they purchased a new
sql server for dev and qa purpose, a developer's box. there would be
sql2k on it for .net development. it's raid 10 hardware (very high
performance) with 2GB ram.
My question is, besides the sql server service, the network admins want
to use this physical server as a test/qa server for the followings: SQL
reporting server, OLAP (for some warehouse/ETL/cube development),
IIS/web server (for intranet), and application server for vb.net
applications.
as a DBA, should i ok that? what would be the strong reasons not to do
so (dump all the stuff on the same dev/qa box)? i've never encountered
situation like this before because i used to work for larger
organizations and the application, reporting, IIS/web servers were
always seperate physical servers.
also, where should Visual Source Safe program reside ideally? on a file
server? application server? or on a database server?
any good article links would be greatly appreicated as well.
thank you guys!!
SteveIt depends. <wink>
What does your production environment look like? Your QA server should
hopefully mimick the production environment as closely as possible.
If it just for development purposes and you are not doing any major load
testing on the system, then I don't really see a huge problem with putting
all of those programs on there. I would suggest you add another 2GB of RAM
though.
As far as SourceSafe is concerned, I would probably go with a different
source control program. There are several out there that integrate with
VS.NET and use SQL Server as the storage engine. This is especially useful
if you are doing development over a VPN from home as they use HTTP or .NET
remoting and are much faster than VSS and much more sturdy (IMO).
That's my .02 cents.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||generally your dev environments are going to be a punch of "poo"
I would be OK with that.
My opinion is that each individual developer should have entire app on their
OWN dev box. (DB Server, App Server, Web Server, the works).
The QA environment and/or staging environment needs to more closely mimic
Prod.
Greg Jackson
Portland, OR|||thank you for the quick response. yes, I do understand that QA server
should mimick the production environment as closely as possilbe. in the
case, most application development on this server will be for internal
use with limited users. in terms of ram size, i know more is better but
have to limit to 2BG because the version of our sql server we use.
in terms of VSS, what other source control programs you'd recommend?
and where should they be implemented?
thank you|||> in terms of VSS, what other source control programs you'd recommend?
> and where should they be implemented?
> thank you
>
http://www.sourcegear.com/vault
I would put it on a machine that's in your DMZ or that's somehow got HTTP
access to it so you can (if needed) access it over the internet w/ the
client (Vault client or vs.net)|||You might want to look into using vmware. You'll need to increase the RAM to
4 (or more) GB though.
Bob
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1111685730.536432.312550@.f14g2000cwb.googlegroups.com...
> i recently started working for a smaller company. they purchased a new
> sql server for dev and qa purpose, a developer's box. there would be
> sql2k on it for .net development. it's raid 10 hardware (very high
> performance) with 2GB ram.
> My question is, besides the sql server service, the network admins want
> to use this physical server as a test/qa server for the followings: SQL
> reporting server, OLAP (for some warehouse/ETL/cube development),
> IIS/web server (for intranet), and application server for vb.net
> applications.
> as a DBA, should i ok that? what would be the strong reasons not to do
> so (dump all the stuff on the same dev/qa box)? i've never encountered
> situation like this before because i used to work for larger
> organizations and the application, reporting, IIS/web servers were
> always seperate physical servers.
> also, where should Visual Source Safe program reside ideally? on a file
> server? application server? or on a database server?
> any good article links would be greatly appreicated as well.
> thank you guys!!
> Steve
>|||CVS
GAJ|||"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1111687330.998586.126860@.o13g2000cwo.googlegroups.com...
> thank you for the quick response. yes, I do understand that QA server
> should mimick the production environment as closely as possilbe. in the
> case, most application development on this server will be for internal
> use with limited users. in terms of ram size, i know more is better but
> have to limit to 2BG because the version of our sql server we use.
> in terms of VSS, what other source control programs you'd recommend?
> and where should they be implemented?
> thank you
>
I would still up the RAM. Just because it's there, doesn't mean SQL will
actually use it. I am assuming you are running standard edition of SQL.
The other 2GB that SQL isn't using would be used by the other applications.
Rick|||thanks guys, i know more is always better for the RAM. but the server
price between the 2GB ram and 4GB ram is significant. the server has
been purchased. a little late for that. but it's good to know for the
next purchase.
sql server for dev and qa purpose, a developer's box. there would be
sql2k on it for .net development. it's raid 10 hardware (very high
performance) with 2GB ram.
My question is, besides the sql server service, the network admins want
to use this physical server as a test/qa server for the followings: SQL
reporting server, OLAP (for some warehouse/ETL/cube development),
IIS/web server (for intranet), and application server for vb.net
applications.
as a DBA, should i ok that? what would be the strong reasons not to do
so (dump all the stuff on the same dev/qa box)? i've never encountered
situation like this before because i used to work for larger
organizations and the application, reporting, IIS/web servers were
always seperate physical servers.
also, where should Visual Source Safe program reside ideally? on a file
server? application server? or on a database server?
any good article links would be greatly appreicated as well.
thank you guys!!
SteveIt depends. <wink>
What does your production environment look like? Your QA server should
hopefully mimick the production environment as closely as possible.
If it just for development purposes and you are not doing any major load
testing on the system, then I don't really see a huge problem with putting
all of those programs on there. I would suggest you add another 2GB of RAM
though.
As far as SourceSafe is concerned, I would probably go with a different
source control program. There are several out there that integrate with
VS.NET and use SQL Server as the storage engine. This is especially useful
if you are doing development over a VPN from home as they use HTTP or .NET
remoting and are much faster than VSS and much more sturdy (IMO).
That's my .02 cents.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||generally your dev environments are going to be a punch of "poo"
I would be OK with that.
My opinion is that each individual developer should have entire app on their
OWN dev box. (DB Server, App Server, Web Server, the works).
The QA environment and/or staging environment needs to more closely mimic
Prod.
Greg Jackson
Portland, OR|||thank you for the quick response. yes, I do understand that QA server
should mimick the production environment as closely as possilbe. in the
case, most application development on this server will be for internal
use with limited users. in terms of ram size, i know more is better but
have to limit to 2BG because the version of our sql server we use.
in terms of VSS, what other source control programs you'd recommend?
and where should they be implemented?
thank you|||> in terms of VSS, what other source control programs you'd recommend?
> and where should they be implemented?
> thank you
>
http://www.sourcegear.com/vault
I would put it on a machine that's in your DMZ or that's somehow got HTTP
access to it so you can (if needed) access it over the internet w/ the
client (Vault client or vs.net)|||You might want to look into using vmware. You'll need to increase the RAM to
4 (or more) GB though.
Bob
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1111685730.536432.312550@.f14g2000cwb.googlegroups.com...
> i recently started working for a smaller company. they purchased a new
> sql server for dev and qa purpose, a developer's box. there would be
> sql2k on it for .net development. it's raid 10 hardware (very high
> performance) with 2GB ram.
> My question is, besides the sql server service, the network admins want
> to use this physical server as a test/qa server for the followings: SQL
> reporting server, OLAP (for some warehouse/ETL/cube development),
> IIS/web server (for intranet), and application server for vb.net
> applications.
> as a DBA, should i ok that? what would be the strong reasons not to do
> so (dump all the stuff on the same dev/qa box)? i've never encountered
> situation like this before because i used to work for larger
> organizations and the application, reporting, IIS/web servers were
> always seperate physical servers.
> also, where should Visual Source Safe program reside ideally? on a file
> server? application server? or on a database server?
> any good article links would be greatly appreicated as well.
> thank you guys!!
> Steve
>|||CVS
GAJ|||"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1111687330.998586.126860@.o13g2000cwo.googlegroups.com...
> thank you for the quick response. yes, I do understand that QA server
> should mimick the production environment as closely as possilbe. in the
> case, most application development on this server will be for internal
> use with limited users. in terms of ram size, i know more is better but
> have to limit to 2BG because the version of our sql server we use.
> in terms of VSS, what other source control programs you'd recommend?
> and where should they be implemented?
> thank you
>
I would still up the RAM. Just because it's there, doesn't mean SQL will
actually use it. I am assuming you are running standard edition of SQL.
The other 2GB that SQL isn't using would be used by the other applications.
Rick|||thanks guys, i know more is always better for the RAM. but the server
price between the 2GB ram and 4GB ram is significant. the server has
been purchased. a little late for that. but it's good to know for the
next purchase.
Need advice on obtaining an SQL server
The company I work for is looking into purchasing a server and SQL license
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).
I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>
|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).
I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>
|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
Need advice on obtaining an SQL server
The company I work for is looking into purchasing a server and SQL license
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you
need to either buy per
processor license or make sure that every user who uses the app server (your
web site) has a SQL
Server Client Access License. I assume that the web server is public, so you
need to go per
processor. It is *not* enough to have a CAL for only the app server (read ab
out multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. T
alk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gb
l...
> The company I work for is looking into purchasing a server and SQL license
to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it f
or use within a company.
> We are a non-profit government appointed agency and are not setting this u
p for sales, just for
> serving data to the public free of charge. And only the web server would b
e interacting with the
> SQL server, we are not trying to set up some kind of tunneling application
for people to access
> the SQL server directly. The web administrator and web server would be the
only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest
tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and
avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you
need to either buy per
processor license or make sure that every user who uses the app server (your
web site) has a SQL
Server Client Access License. I assume that the web server is public, so you
need to go per
processor. It is *not* enough to have a CAL for only the app server (read ab
out multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. T
alk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gb
l...
> The company I work for is looking into purchasing a server and SQL license
to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it f
or use within a company.
> We are a non-profit government appointed agency and are not setting this u
p for sales, just for
> serving data to the public free of charge. And only the web server would b
e interacting with the
> SQL server, we are not trying to set up some kind of tunneling application
for people to access
> the SQL server directly. The web administrator and web server would be the
only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest
tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and
avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free
http://msdn.microsoft.com/sql/express/default.aspx
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
Need advice on obtaining an SQL server
The company I work for is looking into purchasing a server and SQL license
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free:)
http://msdn.microsoft.com/sql/express/default.aspx
--
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
to serve database content. We are currently using IIS and Access.
The price was estimated to be $10,000. It seemed a little steep to me, but
our IT guy said that when you buy SQL for web use they charge more than if
you only needed it for use within a company. We are a non-profit government
appointed agency and are not setting this up for sales, just for serving
data to the public free of charge. And only the web server would be
interacting with the SQL server, we are not trying to set up some kind of
tunneling application for people to access the SQL server directly. The web
administrator and web server would be the only two clients.
Does this sound like the correct price for a basic SQL server? The lowest
tier of service should suit us fine, we just want a boost in speed from the
IIS/Access setup and avoid the odd crashes associated it (once every few
months).I can only comment on the SQL Server side:
If you expose data through an app server (which IIS is in this aspect), you need to either buy per
processor license or make sure that every user who uses the app server (your web site) has a SQL
Server Client Access License. I assume that the web server is public, so you need to go per
processor. It is *not* enough to have a CAL for only the app server (read about multiplexing in the
licensing doc).
One thing to consider is SQL Server Express.
Another thing is if MS has some special deal for non-profit organizations. Talk to your MS rep about
this.
Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Matt" <mattmatt32@.notmail.com> wrote in message news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license to serve database
> content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but our IT guy said that
> when you buy SQL for web use they charge more than if you only needed it for use within a company.
> We are a non-profit government appointed agency and are not setting this up for sales, just for
> serving data to the public free of charge. And only the web server would be interacting with the
> SQL server, we are not trying to set up some kind of tunneling application for people to access
> the SQL server directly. The web administrator and web server would be the only two clients.
> Does this sound like the correct price for a basic SQL server? The lowest tier of service should
> suit us fine, we just want a boost in speed from the IIS/Access setup and avoid the odd crashes
> associated it (once every few months).
>|||Seems like SQL Express would be ideal for you (and it is free:)
http://msdn.microsoft.com/sql/express/default.aspx
--
William Stacey [MVP]
"Matt" <mattmatt32@.notmail.com> wrote in message
news:OFO$G%23T5FHA.3384@.TK2MSFTNGP11.phx.gbl...
> The company I work for is looking into purchasing a server and SQL license
> to serve database content. We are currently using IIS and Access.
> The price was estimated to be $10,000. It seemed a little steep to me, but
> our IT guy said that when you buy SQL for web use they charge more than if
> you only needed it for use within a company. We are a non-profit
> government appointed agency and are not setting this up for sales, just
> for serving data to the public free of charge. And only the web server
> would be interacting with the SQL server, we are not trying to set up some
> kind of tunneling application for people to access the SQL server
> directly. The web administrator and web server would be the only two
> clients.
> Does this sound like the correct price for a basic SQL server? The lowest
> tier of service should suit us fine, we just want a boost in speed from
> the IIS/Access setup and avoid the odd crashes associated it (once every
> few months).
>
Friday, March 9, 2012
Need Advice on Backups
We are a pretty small sized company that has one sql server that also
serves as our application server. We backup our server to a tape drive
nightly using Veritas. We have a Dell PowerValut 110T.
Starting about two days ago (much to my dismay) backups started
failing.
We have 3 main SQL Server databases we use for applications. They are
all in 'simple' recovery mode and full backed up once a night at 8pm
the ta a file on the server. The location which that file lives is
not backed up to tape drive.
The veritas tape backup USED TO do a FULL backup of the databases when
it runs at 9pm. nightly.
The only way I can get my tape backups to stop failing is to put the
tape backup in 'differental' mode. Which i'm not sure if is ok or
not.
I don't have the space on my tape drive to do a full backup.. That's
why the backup is failing. I have limited space on the server so i'm
not sure changing to full recover is an option. I need some help and
advice to get the best backup plan i can with what I have.
Thanks.Well!, Space , Space is all the cry around.
Need to have lots(Tons) of space, when working on Critical Database
Servers.
What is your Backup Retain Strategy on Local Server as well the TAPE.
Have Rolling Backup Plans. i.e retain backups for lesser #of days.
Take a Weekly Full Backup+Daily Differential Backup+(if possible and
space permits Transaction Log Backups every few Hours).
It Depends : How Critical is your Data!,
What is the Amount of Data Loss can you Take.(Time between one
transaction log and next)
Try 3rd Party Compression Tools - SQL LiteSpeed - Good Compression.|||This might get you through for a while. It is not an approach I would
care to use in production, but then neither is Simple recovery mode.
Monday, Thursday: A full, B differential, C differential
Tuesday. Friday: A differential, B full, C differential
Wednesday, Saturday: A differential, B differential, C full
Sunday: all differential
Roy Harvey
Beacon Falls, CT
On Thu, 01 Nov 2007 12:12:17 -0700, TDanley <taranbuckley@.hotmail.com>
wrote:
>We are a pretty small sized company that has one sql server that also
>serves as our application server. We backup our server to a tape drive
>nightly using Veritas. We have a Dell PowerValut 110T.
>Starting about two days ago (much to my dismay) backups started
>failing.
>We have 3 main SQL Server databases we use for applications. They are
>all in 'simple' recovery mode and full backed up once a night at 8pm
>the ta a file on the server. The location which that file lives is
>not backed up to tape drive.
>The veritas tape backup USED TO do a FULL backup of the databases when
>it runs at 9pm. nightly.
>The only way I can get my tape backups to stop failing is to put the
>tape backup in 'differental' mode. Which i'm not sure if is ok or
>not.
>I don't have the space on my tape drive to do a full backup.. That's
>why the backup is failing. I have limited space on the server so i'm
>not sure changing to full recover is an option. I need some help and
>advice to get the best backup plan i can with what I have.
>Thanks.
serves as our application server. We backup our server to a tape drive
nightly using Veritas. We have a Dell PowerValut 110T.
Starting about two days ago (much to my dismay) backups started
failing.
We have 3 main SQL Server databases we use for applications. They are
all in 'simple' recovery mode and full backed up once a night at 8pm
the ta a file on the server. The location which that file lives is
not backed up to tape drive.
The veritas tape backup USED TO do a FULL backup of the databases when
it runs at 9pm. nightly.
The only way I can get my tape backups to stop failing is to put the
tape backup in 'differental' mode. Which i'm not sure if is ok or
not.
I don't have the space on my tape drive to do a full backup.. That's
why the backup is failing. I have limited space on the server so i'm
not sure changing to full recover is an option. I need some help and
advice to get the best backup plan i can with what I have.
Thanks.Well!, Space , Space is all the cry around.
Need to have lots(Tons) of space, when working on Critical Database
Servers.
What is your Backup Retain Strategy on Local Server as well the TAPE.
Have Rolling Backup Plans. i.e retain backups for lesser #of days.
Take a Weekly Full Backup+Daily Differential Backup+(if possible and
space permits Transaction Log Backups every few Hours).
It Depends : How Critical is your Data!,
What is the Amount of Data Loss can you Take.(Time between one
transaction log and next)
Try 3rd Party Compression Tools - SQL LiteSpeed - Good Compression.|||This might get you through for a while. It is not an approach I would
care to use in production, but then neither is Simple recovery mode.
Monday, Thursday: A full, B differential, C differential
Tuesday. Friday: A differential, B full, C differential
Wednesday, Saturday: A differential, B differential, C full
Sunday: all differential
Roy Harvey
Beacon Falls, CT
On Thu, 01 Nov 2007 12:12:17 -0700, TDanley <taranbuckley@.hotmail.com>
wrote:
>We are a pretty small sized company that has one sql server that also
>serves as our application server. We backup our server to a tape drive
>nightly using Veritas. We have a Dell PowerValut 110T.
>Starting about two days ago (much to my dismay) backups started
>failing.
>We have 3 main SQL Server databases we use for applications. They are
>all in 'simple' recovery mode and full backed up once a night at 8pm
>the ta a file on the server. The location which that file lives is
>not backed up to tape drive.
>The veritas tape backup USED TO do a FULL backup of the databases when
>it runs at 9pm. nightly.
>The only way I can get my tape backups to stop failing is to put the
>tape backup in 'differental' mode. Which i'm not sure if is ok or
>not.
>I don't have the space on my tape drive to do a full backup.. That's
>why the backup is failing. I have limited space on the server so i'm
>not sure changing to full recover is an option. I need some help and
>advice to get the best backup plan i can with what I have.
>Thanks.
Need Advice (pulling my hair out)
I am the only DBA for a company of about 200 employees which makes about 100 million a year; I have 8 SQL servers some with over 70 databases on them that feed our web sites and educational web sites. I also have a few databases that are between 75 and 120 Gig that is for our circulation system. I am the Systems admin for all of the systems that run of my SQL server, so that makes our circ system, tradeshow system, accounting system, web sites there are about 90 of them or so. I also do programming for our IT department and some web site stuff as well as for our tradeshow dept. I am the answer man for our sales people and programmers, I also have the knowledge to build by own servers and run a network. So that’s over 200 databases plus all the other *** that I do. Oh and by the way I'm supposed to help out and cover for our Tec support guys, witch there are 2 of them by the way. I can never take any more than 3 days off at a time; I have a month’s vacation. I do all this for under $55,000 a year. I am never included in any decisions on software that runs on SQL nor am I consulted on any thing having to do with SQL. I work for a director who knows nothing about SQL server. There are 2 JR data guys and they do just data queries and deal with the day to day circ requests. These guys both have an office not to mention the tech guys have an office and guess what I am in a cube. I asked my boss for a laptop with a Verizon air card so when I’m not at work if something happens that needs my attention I do have to drive to work or go home and remote in, here is the best part he looked at me and asked if I was high. I am on call 24/7 365. I have over 10 years experience working with SQL. I’m I crazy for staying? I have been with this company for almost 8 years; I am the one who started them out on SQL server. I have converted every thing over to SQL 98.5% of all the company data I am in charge of. What would you do?
In a nutshell...
You're in a toxic environment that will not improve. You've heard of the saying "A prophet is never welcomed in his own home country", right? This applies to you in this situation because, in your own words, you have 10 years of experience but have been with the same company for 8 of those 10 years. You are at a stage in your current employment situation where you are being taken for granted. And the salary you mentioned...I'd have to know what area of the country you're working in to know what is reasonable, but $55k with 10 years of experience is damned-near insulting. To put it in perspective, I too have 10 years of experience. I have changed companies every 2-3 years and now earn more than twice the figure you quoted (in Austin, Texas).
Do yourself a favor: Go to http://www.careerbuilder.com and be prepared for an eye-opening experience. Upload your resume and be prepared to field a ton of phone calls. A person with 10 years of experience is always a hot catch for a company, and you can rest assured you'll find one that will make you happy.
To answer your final question: I would leave. Pure and simple.
|||In the US, $50K is marginally entry level for DBA.
It is really time to do some 'soul-searching', and plan your future.
Just like employers conduct 'annual reviews', employees should also do their own 'annual review'. It may be the 'right' position for you, only you know all of the details.
|||Thanks for your response. I live in Phoenix Az and I found out that DBA's with my experience level range from 75 to 92 k a year. I am so outta here. Careerbuilder and monster have lots of possibilities.|||My employers annual review was poor. According to salary.com entry level DBA's range from 60k to 68,500. Needles to say I'm getting used and insulted. Just one other thing with my company for myself and my family to get med insurance with the company is 685.00 a month.Wednesday, March 7, 2012
Need a leg up on migrating from SQL 7 to SQL 2005 (HOW TO?)
I have a SQL7 server that runs one database for our company. The rest of the datastore is on a SQL2005 server. How best can I transfer the SQL7 database to SQL2005??
There are a variety of ways, but the most straightforward is to simply back up the SQL 7.0 database, and restore it onto a SQL 2005 instance...
--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--
Is your SQL 7 server patched to the last SP (4, if I recall properly)? I believe that is a prerequisite. If it is, what is the exact error you're getting?
--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--
I applied SP3 and SP4. Afterwards, I was able to produce a useable backup that I was able to restore to SQL 2005
Thanks for your help
Need a hand...
i've been writing an app for my company that has a front end screen in which the user types in all infos needed (ie. name, address, city, state, etc - 82 fields to be exact) then clicks an "add" button, which i put at the bottom, and have that data dumped into a SQL table... the page is then redirected to another page which reads the record just added and displays all the fields that the user submitted...
here is my front end "add" screen code behind written in C#:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
publicpartialclassVinny_Credit_Application_AddCredApp : System.Web.UI.Page
{
protectedvoid Page_Load(object sender,EventArgs e){
}
protectedvoid SubmitButton_Click(object sender,EventArgs e){
string ConnectionString =ConfigurationManager.ConnectionStrings["ws2dbConnectionString2"].ConnectionString;SqlConnection connection =newSqlConnection(ConnectionString);
SqlCommand cmd =newSqlCommand(@."INSERT INTO CreditAppFile (GI_RB_Div,
GI_RB_ExistCust,
GI_TB_LegalFirmName,
GI_TB_Address,
GI_TB_City,
GI_DDL_State,
GI_TB_Zip,
GI_TB_TradeName,
GI_TB_BillAddress,
GI_TB_BillCity,
GI_DDL_BillState,
GI_TB_BillZip,
GI_TB_ContName,
GI_TB_Title,
GI_TB_MobilePager,
GI_TB_Email,
GI_TB_Fax,
GI_TB_BusDesc,
GI_TB_BusStartDate,
GI_TB_BusPhone,
GI_RB_PuchOrdsReq,
GI_RB_BusType,
GI_RB_LiensJudges,
GI_RB_TaxExempt,
GI_TB_FedIDNO,
GI_RB_PriorBankrupt,
GI_TB_PriorBankr,
BFR_TB_ContPhone,
BFR_TB_AcctNum1,
BFR_TB_AcctNum2,
BFR_TB_CurrBal1,
BFR_TB_CurrBal2,
BFR_TB_CurrBal3,
BFR_TB_CurrBal4,
BFR_RB_AcctType,
TR_TB_ContName1,
TR_TB_ContAddr1,
TR_TB_ContCity1,
TR_DDL_ContSt1,
TR_TB_ContZip1,
TR_TB_ContPhone1,
TR_TB_Cont_Acct1,
TR_TB_ContName2,
TR_TB_ContAddr2,
TR_TB_ContCity2,
TR_DDL_ContSt2,
TR_TB_ContZip2,
TR_TB_ContPhone2,
TR_TB_Cont_Acct2,
TR_TB_ContName3,
TR_TB_ContAddr3,
TR_TB_ContCity3,
TR_DDL_ContSt3,
TR_TB_ContZip3,
TR_TB_ContPhone3,
TR_TB_Cont_Acct3,
PI_TB_Name1,
PI_TB_HomeAddr1,
PI_TB_BDay1,
PI_TB_SSNum1,
PI_TB_HomePh1,
PI_TB_PrcntOwn1,
PI_TB_NetWorth1,
PI_TB_AnnInc1,
PI_TB_MonHouPay1,
PI_TB_Name2,
PI_TB_HomeAddr2,
PI_TB_BDay2,
PI_TB_SSNum2,
PI_TB_HomePh2,
PI_TB_PrcntOwn2,
PI_TB_NetWorth2,
PI_TB_AnnInc2,
PI_TB_MonHouPay2,
PI_TB_Name3,
PI_TB_HomeAddr3,
PI_TB_BDay3,
PI_TB_SSNum3,
PI_TB_HomePh3,
PI_TB_PrcntOwn3,
PI_TB_NetWorth3,
PI_TB_AnnInc3,
PI_TB_MonHouPay3
)
VALUES (
@.GI_RB_Div,
@.GI_RB_ExistCust,
@.GI_TB_LegalFirmName,
@.GI_TB_Address,
@.GI_TB_City,
@.GI_DDL_State,
@.GI_TB_Zip,
@.GI_TB_TradeName,
@.GI_TB_BillAddress,
@.GI_TB_BillCity,
@.GI_DDL_BillState,
@.GI_TB_BillZip,
@.GI_TB_ContName,
@.GI_TB_Title,
@.GI_TB_MobilePager,
@.GI_TB_Email,
@.GI_TB_Fax,
@.GI_TB_BusDesc,
@.GI_TB_BusStartDate,
@.GI_TB_BusPhone,
@.GI_RB_PuchOrdsReq,
@.GI_RB_BusType,
@.GI_RB_LiensJudges,
@.GI_RB_TaxExempt,
@.GI_TB_FedIDNO,
@.GI_RB_PriorBankrupt,
@.GI_TB_PriorBankr,
@.BFR_TB_ContPhone,
@.BFR_TB_AcctNum1,
@.BFR_TB_AcctNum2,
@.BFR_TB_CurrBal1,
@.BFR_TB_CurrBal2,
@.BFR_TB_CurrBal3,
@.BFR_TB_CurrBal4,
@.BFR_RB_AcctType,
@.TR_TB_ContName1,
@.TR_TB_ContAddr1,
@.TR_TB_ContCity1,
@.TR_DDL_ContSt1,
@.TR_TB_ContZip1,
@.TR_TB_ContPhone1,
@.TR_TB_Cont_Acct1,
@.TR_TB_ContName2,
@.TR_TB_ContAddr2,
@.TR_TB_ContCity2,
@.TR_DDL_ContSt2,
@.TR_TB_ContZip2,
@.TR_TB_ContPhone2,
@.TR_TB_Cont_Acct2,
@.TR_TB_ContName3,
@.TR_TB_ContAddr3,
@.TR_TB_ContCity3,
@.TR_DDL_ContSt3,
@.TR_TB_ContZip3,
@.TR_TB_ContPhone3,
@.TR_TB_Cont_Acct3,
@.PI_TB_Name1,
@.PI_TB_HomeAddr1,
@.PI_TB_BDay1,
@.PI_TB_SSNum1,
@.PI_TB_HomePh1,
@.PI_TB_PrcntOwn1,
@.PI_TB_NetWorth1,
@.PI_TB_AnnInc1,
@.PI_TB_MonHouPay1,
@.PI_TB_Name2,
@.PI_TB_HomeAddr2,
@.PI_TB_BDay2,
@.PI_TB_SSNum2,
@.PI_TB_HomePh2,
@.PI_TB_PrcntOwn2,
@.PI_TB_NetWorth2,
@.PI_TB_AnnInc2,
@.PI_TB_MonHouPay2,
@.PI_TB_Name3,
@.PI_TB_HomeAddr3,
@.PI_TB_BDay3,
@.PI_TB_SSNum3,
@.PI_TB_HomePh3,
@.PI_TB_PrcntOwn3,
@.PI_TB_NetWorth3,
@.PI_TB_AnnInc3,
@.PI_TB_MonHouPay3
); Select Scope_Identity()"
, connection);
try
{
cmd.Parameters.AddWithValue("@.GI_RB_Div", GI_RB_Div.SelectedValue);cmd.Parameters.AddWithValue("@.GI_RB_ExistCust", GI_RB_ExistCust.SelectedValue);
cmd.Parameters.AddWithValue("@.GI_TB_LegalFirmName", GI_TB_LegalFirmName.Text);cmd.Parameters.AddWithValue("@.GI_TB_Address", GI_TB_Address.Text);
cmd.Parameters.AddWithValue("@.GI_TB_City", GI_TB_City.Text);cmd.Parameters.AddWithValue("@.GI_DDL_State", GI_DDL_State.SelectedValue);
cmd.Parameters.AddWithValue("@.GI_TB_Zip", GI_TB_Zip.Text);cmd.Parameters.AddWithValue("@.GI_TB_TradeName", GI_TB_TradeName.Text);
cmd.Parameters.AddWithValue("@.GI_TB_BillAddress", GI_TB_BillAddress.Text);cmd.Parameters.AddWithValue("@.GI_TB_BillCity", GI_TB_BillCity.Text);
cmd.Parameters.AddWithValue("@.GI_DDL_BillState", GI_DDL_BillState.SelectedValue);cmd.Parameters.AddWithValue("@.GI_TB_BillZip", GI_TB_BillZip.Text);
cmd.Parameters.AddWithValue("@.GI_TB_ContName", GI_TB_ContName.Text);cmd.Parameters.AddWithValue("@.GI_TB_Title", GI_TB_Title.Text);
cmd.Parameters.AddWithValue("@.GI_TB_MobilePager", GI_TB_MobilePager.Text);cmd.Parameters.AddWithValue("@.GI_TB_Email", GI_TB_Email.Text);
cmd.Parameters.AddWithValue("@.GI_TB_Fax", GI_TB_Fax.Text);cmd.Parameters.AddWithValue("@.GI_TB_BusDesc", GI_TB_BusDesc.Text);
cmd.Parameters.AddWithValue("@.GI_TB_BusStartDate", GI_TB_BusStartDate.Text);cmd.Parameters.AddWithValue("@.GI_TB_BusPhone", GI_TB_BusPhone.Text);
cmd.Parameters.AddWithValue("@.GI_RB_PuchOrdsReq", GI_RB_PuchOrdsReq.SelectedValue);cmd.Parameters.AddWithValue("@.GI_RB_BusType", GI_RB_BusType.SelectedValue);
cmd.Parameters.AddWithValue("@.GI_RB_LiensJudges", GI_RB_LiensJudges.SelectedValue);cmd.Parameters.AddWithValue("@.GI_RB_TaxExempt", GI_RB_TaxExempt.SelectedValue);
cmd.Parameters.AddWithValue("@.GI_TB_FedIDNO", GI_TB_FedIDNO.Text);cmd.Parameters.AddWithValue("@.GI_RB_PriorBankrupt", GI_RB_PriorBankrupt.SelectedValue);
cmd.Parameters.AddWithValue("@.GI_TB_PriorBankr", GI_TB_PriorBankr.Text);cmd.Parameters.AddWithValue("@.BFR_TB_ContPhone", BFR_TB_ContPhone.Text);
cmd.Parameters.AddWithValue("@.BFR_TB_AcctNum1", BFR_TB_AcctNum1.Text);cmd.Parameters.AddWithValue("@.BFR_TB_AcctNum2", BFR_TB_AcctNum2.Text);
cmd.Parameters.AddWithValue("@.BFR_TB_CurrBal1", BFR_TB_CurrBal1.Text);cmd.Parameters.AddWithValue("@.BFR_TB_CurrBal2", BFR_TB_CurrBal2.Text);
cmd.Parameters.AddWithValue("@.BFR_TB_CurrBal3", BFR_TB_CurrBal3.Text);cmd.Parameters.AddWithValue("@.BFR_TB_CurrBal4", BFR_TB_CurrBal4.Text);
cmd.Parameters.AddWithValue("@.BFR_RB_AcctType", BFR_RB_AcctType.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContName1", TR_TB_ContName1.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContAddr1", TR_TB_ContAddr1.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContCity1", TR_TB_ContCity1.Text);
cmd.Parameters.AddWithValue("@.TR_DDL_ContSt1", TR_DDL_ContSt1.SelectedValue);cmd.Parameters.AddWithValue("@.TR_TB_ContZip1", TR_TB_ContZip1.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContPhone1", TR_TB_ContPhone1.Text);cmd.Parameters.AddWithValue("@.TR_TB_Cont_Acct1", TR_TB_Cont_Acct1.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContName2", TR_TB_ContName2.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContAddr2", TR_TB_ContAddr2.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContCity2", TR_TB_ContCity2.Text);cmd.Parameters.AddWithValue("@.TR_DDL_ContSt2", TR_DDL_ContSt2.SelectedValue);
cmd.Parameters.AddWithValue("@.TR_TB_ContZip2", TR_TB_ContZip2.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContPhone2", TR_TB_ContPhone2.Text);
cmd.Parameters.AddWithValue("@.TR_TB_Cont_Acct2", TR_TB_Cont_Acct2.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContName3", TR_TB_ContName3.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContAddr3", TR_TB_ContAddr3.Text);cmd.Parameters.AddWithValue("@.TR_TB_ContCity3", TR_TB_ContCity3.Text);
cmd.Parameters.AddWithValue("@.TR_DDL_ContSt3", TR_DDL_ContSt3.SelectedValue);cmd.Parameters.AddWithValue("@.TR_TB_ContZip3", TR_TB_ContZip3.Text);
cmd.Parameters.AddWithValue("@.TR_TB_ContPhone3", TR_TB_ContPhone3.Text);cmd.Parameters.AddWithValue("@.TR_TB_Cont_Acct3", TR_TB_Cont_Acct3.Text);
cmd.Parameters.AddWithValue("@.PI_TB_Name1", PI_TB_Name1.Text);cmd.Parameters.AddWithValue("@.PI_TB_HomeAddr1", PI_TB_HomeAddr1.Text);
cmd.Parameters.AddWithValue("@.PI_TB_BDay1", PI_TB_BDay1.Text);cmd.Parameters.AddWithValue("@.PI_TB_SSNum1", PI_TB_SSNum1.Text);
cmd.Parameters.AddWithValue("@.PI_TB_HomePh1", PI_TB_HomePh1.Text);cmd.Parameters.AddWithValue("@.PI_TB_PrcntOwn1", PI_TB_PrcntOwn1.Text);
cmd.Parameters.AddWithValue("@.PI_TB_NetWorth1", PI_TB_NetWorth1.Text);cmd.Parameters.AddWithValue("@.PI_TB_AnnInc1", PI_TB_AnnInc1.Text);
cmd.Parameters.AddWithValue("@.PI_TB_MonHouPay1", PI_TB_MonHouPay1.Text);cmd.Parameters.AddWithValue("@.PI_TB_Name2", PI_TB_Name2.Text);
cmd.Parameters.AddWithValue("@.PI_TB_HomeAddr2", PI_TB_HomeAddr2.Text);cmd.Parameters.AddWithValue("@.PI_TB_BDay2", PI_TB_BDay2.Text);
cmd.Parameters.AddWithValue("@.PI_TB_SSNum2", PI_TB_SSNum2.Text);cmd.Parameters.AddWithValue("@.PI_TB_HomePh2", PI_TB_HomePh2.Text);
cmd.Parameters.AddWithValue("@.PI_TB_PrcntOwn2", PI_TB_PrcntOwn2.Text);cmd.Parameters.AddWithValue("@.PI_TB_NetWorth2", PI_TB_NetWorth2.Text);
cmd.Parameters.AddWithValue("@.PI_TB_AnnInc2", PI_TB_AnnInc2.Text);cmd.Parameters.AddWithValue("@.PI_TB_MonHouPay2", PI_TB_MonHouPay2.Text);
cmd.Parameters.AddWithValue("@.PI_TB_Name3", PI_TB_Name3.Text);cmd.Parameters.AddWithValue("@.PI_TB_HomeAddr3", PI_TB_HomeAddr3.Text);
cmd.Parameters.AddWithValue("@.PI_TB_BDay3", PI_TB_BDay3.Text);cmd.Parameters.AddWithValue("@.PI_TB_SSNum3", PI_TB_SSNum3.Text);
cmd.Parameters.AddWithValue("@.PI_TB_HomePh3", PI_TB_HomePh3.Text);cmd.Parameters.AddWithValue("@.PI_TB_PrcntOwn3", PI_TB_PrcntOwn3.Text);
cmd.Parameters.AddWithValue("@.PI_TB_NetWorth3", PI_TB_NetWorth3.Text);cmd.Parameters.AddWithValue("@.PI_TB_AnnInc3", PI_TB_AnnInc3.Text);
cmd.Parameters.AddWithValue("@.PI_TB_MonHouPay3", PI_TB_MonHouPay3.Text);cmd.Connection = connection;
cmd.Connection.Open();
string NewID = cmd.ExecuteScalar().ToString();cmd.Connection.Close();
Response.Redirect("DisplayCredApp.aspx?ID=" + Request["NewID"]);
}
catch (Exception ex){
lblMessage.Text ="ERROR: " + ex.Message;lblMessage.Visible =true;}
}
}
this seems to be ok... but i get a load of errors on my "read/display" page which looks like the folowing... (this is the code behind, again, written in C#)
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
publicpartialclassVinny_Credit_Application_DisplayCredApp : System.Web.UI.Page
{
protectedvoid Page_Load(object sender,EventArgs e){
if (!IsPostBack && Response["NewID"] !=null){
string ConnectionString =ConfigurationManager.ConnectionStrings["ws2dbConnectionString"].ConnectionString;SqlConnection connection =newSqlConnection(ConnectionString);
SqlCommand cmd =newSqlCommand(@."SELECT * FROM CreditAppFile WHERE ID = @.ID", connection);cmd.Parameters.Add("@.ID", Response["NewID"].ToString());connection.Open();
SqlDataReader reader = cmd.ExecuteReader();reader.Read();
GI_RB_Div.Text = reader["GI_RB_Div"].ToString();
GI_RB_ExistCust.Text = reader["GI_RB_ExistCust"].ToString();GI_TB_LegalFirmName.Text = reader["GI_TB_LegalFirmName"].ToString();
GI_TB_Address.Text = reader["GI_TB_Address"].ToString();GI_TB_City.Text = reader["GI_TB_City"].ToString();
GI_DDL_State.Text = reader["GI_DDL_State"].ToString();GI_TB_Zip.Text = reader["GI_TB_Zip"].ToString();
GI_TB_TradeName.Text = reader["GI_TB_TradeName"].ToString();GI_TB_BillAddress.Text = reader["GI_TB_BillAddress"].ToString();
GI_TB_BillCity.Text = reader["GI_TB_BillCity"].ToString();GI_DDL_BillState.Text = reader["GI_DDL_BillState"].ToString();
GI_TB_BillZip.Text = reader["GI_TB_BillZip"].ToString();GI_TB_ContName.Text = reader["GI_TB_ContName"].ToString();
GI_TB_Title.Text = reader["GI_TB_Title"].ToString();GI_TB_MobilePager.Text = reader["GI_TB_MobilePager"].ToString();
GI_TB_Email.Text = reader["GI_TB_Email"].ToString();GI_TB_Fax.Text = reader["GI_TB_Fax"].ToString();
GI_TB_BusDesc.Text = reader["GI_TB_BusDesc"].ToString();GI_TB_BusStartDate.Text = reader["GI_TB_BusStartDate"].ToString();
GI_TB_BusPhone.Text = reader["GI_TB_BusPhone"].ToString();GI_RB_PuchOrdsReq.Text = reader["GI_RB_PuchOrdsReq"].ToString();
GI_RB_BusType.Text = reader["GI_RB_BusType"].ToString();GI_RB_LiensJudges.Text = reader["GI_RB_LiensJudges"].ToString();
GI_RB_TaxExempt.Text = reader["GI_RB_TaxExempt"].ToString();GI_TB_FedIDNO.Text = reader["GI_TB_FedIDNO"].ToString();
GI_RB_PriorBankrupt.Text = reader["GI_RB_PriorBankrupt"].ToString();GI_TB_PriorBankr.Text = reader["GI_TB_PriorBankr"].ToString();
BFR_TB_ContPhone.Text = reader["BFR_TB_ContPhone"].ToString();BFR_TB_AcctNum1.Text = reader["BFR_TB_AcctNum1"].ToString();
BFR_TB_AcctNum2.Text = reader["BFR_TB_AcctNum2"].ToString();BFR_TB_CurrBal1.Text = reader["BFR_TB_CurrBal1"].ToString();
BFR_TB_CurrBal2.Text = reader["BFR_TB_CurrBal2"].ToString();BFR_TB_CurrBal3.Text = reader["BFR_TB_CurrBal3"].ToString();
BFR_TB_CurrBal4.Text = reader["BFR_TB_CurrBal4"].ToString();BFR_RB_AcctType.Text = reader["BFR_RB_AcctType"].ToString();
TR_TB_ContName1.Text = reader["TR_TB_ContName1"].ToString();TR_TB_ContAddr1.Text = reader["TR_TB_ContAddr1"].ToString();
TR_TB_ContCity1.Text = reader["TR_TB_ContCity1"].ToString();TR_DDL_ContSt1.Text = reader["TR_DDL_ContSt1"].ToString();
TR_TB_ContZip1.Text = reader["TR_TB_ContZip1"].ToString();TR_TB_ContPhone1.Text = reader["TR_TB_ContPhone1"].ToString();
TR_TB_Cont_Acct1.Text = reader["TR_TB_Cont_Acct1"].ToString();TR_TB_ContName2.Text = reader["TR_TB_ContName2"].ToString();
TR_TB_ContAddr2.Text = reader["TR_TB_ContAddr2"].ToString();TR_TB_ContCity2.Text = reader["TR_TB_ContCity2"].ToString();
TR_DDL_ContSt2.Text = reader["TR_DDL_ContSt2"].ToString();TR_TB_ContZip2.Text = reader["TR_TB_ContZip2"].ToString();
TR_TB_ContPhone2.Text = reader["TR_TB_ContPhone2"].ToString();TR_TB_Cont_Acct2.Text = reader["TR_TB_Cont_Acct2"].ToString();
TR_TB_ContName3.Text = reader["TR_TB_ContName3"].ToString();TR_TB_ContAddr3.Text = reader["TR_TB_ContAddr3"].ToString();
TR_TB_ContCity3.Text = reader["TR_TB_ContCity3"].ToString();TR_DDL_ContSt3.Text = reader["TR_DDL_ContSt3"].ToString();
TR_TB_ContZip3.Text = reader["TR_TB_ContZip3"].ToString();TR_TB_ContPhone3.Text = reader["TR_TB_ContPhone3"].ToString();
TR_TB_Cont_Acct3.Text = reader["TR_TB_Cont_Acct3"].ToString();PI_TB_Name1.Text = reader["PI_TB_Name1"].ToString();
PI_TB_HomeAddr1.Text = reader["PI_TB_HomeAddr1"].ToString();PI_TB_BDay1.Text = reader["PI_TB_BDay1"].ToString();
PI_TB_SSNum1.Text = reader["PI_TB_SSNum1"].ToString();PI_TB_HomePh1.Text = reader["PI_TB_HomePh1"].ToString();
PI_TB_PrcntOwn1.Text = reader["PI_TB_PrcntOwn1"].ToString();PI_TB_NetWorth1.Text = reader["PI_TB_NetWorth1"].ToString();
PI_TB_AnnInc1.Text = reader["PI_TB_AnnInc1"].ToString();PI_TB_MonHouPay1.Text = reader["PI_TB_MonHouPay1"].ToString();
PI_TB_Name2.Text = reader["PI_TB_Name2"].ToString();PI_TB_HomeAddr2.Text = reader["PI_TB_HomeAddr2"].ToString();
PI_TB_BDay2.Text = reader["PI_TB_BDay2"].ToString();PI_TB_SSNum2.Text = reader["PI_TB_SSNum2"].ToString();
PI_TB_HomePh2.Text = reader["PI_TB_HomePh2"].ToString();PI_TB_PrcntOwn2.Text = reader["PI_TB_PrcntOwn2"].ToString();
PI_TB_NetWorth2.Text = reader["PI_TB_NetWorth2"].ToString();PI_TB_AnnInc2.Text = reader["PI_TB_AnnInc2"].ToString();
PI_TB_Name2.Text = reader["PI_TB_MonHouPay2"].ToString();PI_TB_Name3.Text = reader["PI_TB_Name3"].ToString();
PI_TB_HomeAddr3.Text = reader["PI_TB_HomeAddr3"].ToString();PI_TB_BDay3.Text = reader["PI_TB_BDay3"].ToString();
PI_TB_SSNum3.Text = reader["PI_TB_SSNum3"].ToString();PI_TB_HomePh3.Text = reader["PI_TB_HomePh3"].ToString();
PI_TB_PrcntOwn3.Text = reader["PI_TB_PrcntOwn3"].ToString();PI_TB_NetWorth3.Text = reader["PI_TB_NetWorth3"].ToString();
PI_TB_AnnInc3.Text = reader["PI_TB_AnnInc3"].ToString();PI_TB_MonHouPay3.Text = reader["PI_TB_MonHouPay3"].ToString();connection.Close();
}
}
}
been working on this for days... everytime i get a little closer i seem to get that much farther away... if you can help by all means give me what you got...
thanks for all the help in advance!!!!
- Vinny
Hi Vinny,
Thats alot of columns in that table. Anyway what is the error message you are getting. It would help to know where it stops.
Changestring NewID = cmd.ExecuteScalar().ToString();
VinnyPip:
cmd.Connection.Close();
Response.Redirect("DisplayCredApp.aspx?ID=" + Request["NewID"]);
.
.
.
SqlCommand cmd =newSqlCommand(@."SELECT * FROM CreditAppFile WHERE ID = @.ID", connection);cmd.Parameters.Add("@.ID", Response["NewID"].ToString());
Response.Redirect("DisplayCredApp.aspx?ID=" + Request["NewID"]);
to
Response.Redirect("DisplayCredApp.aspx?ID=" +NewID);
Change
SqlCommand cmd =newSqlCommand(@."SELECT * FROM CreditAppFile WHERE ID = @.ID", connection);cmd.Parameters.Add("@.ID", Response["NewID"].ToString());
to
SqlCommand cmd =newSqlCommand(@."SELECT * FROM CreditAppFile WHERE ID = @.ID", connection);cmd.Parameters.Add("@.ID", Request.QueryString["NewID"]);
made the above changes Mike suggested and the main error is still the same...
Description:An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message:CS0021: Cannot apply indexing with [] to an expression of type 'System.Web.HttpResponse'
Source Error:
Line 15: protected void Page_Load(object sender, EventArgs e)Line 16: {Line 17: if (!IsPostBack && Response["NewID"] != null)Line 18: {Line 19: string ConnectionString = ConfigurationManager.ConnectionStrings["ws2dbConnectionString"].ConnectionString;Damn. Missed that one. Change it to
if (!IsPostBack && Request.QueryString["ID"] != null)
And - where I changed something to Request,QueryString["NewID"] before (in the parameters), change that to
Request.QueryString["ID"]|||
that seemed to compile ok...
and for my next trick... uhh... i mean error:
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.InvalidOperationException: Invalid attempt to read when no data is present.
Source Error:
Line 29: reader.Read();Line 30:Line 31: GI_RB_Div.Text = reader["GI_RB_Div"].ToString();Line 32: GI_RB_ExistCust.Text = reader["GI_RB_ExistCust"].ToString();Line 33: GI_TB_LegalFirmName.Text = reader["GI_TB_LegalFirmName"].ToString();
keep em comin' mike... really appreciate this!!!|||
NEVERMIND MIKE!!!!!!!!
IT WORKS!!!!!!
next time you're in NYC the drinks are on me... thanks a ton!!!
|||That suggests there is no data. Check the value of ID in the querystring of the page to make sure it was passed correctly (no spaces or odd urlencoded chars), then try running the query in SSMS to see that it works.
Monday, February 20, 2012
nchar or char or nvarchar or varchar??
Hi,
Which of the above data type (alongwith size) should be used for storing things like Customer Name, Company name etc . ?
Also, what really is the benefit of one over the over :confused:
ThanksOriginally posted by Joozh
Hi,
Which of the above data type (alongwith size) should be used for storing things like Customer Name, Company name etc . ?
Also, what really is the benefit of one over the over :confused:
Thanks
the difference between char and varchar is that: char is a fixed length datatype meaning, if suppose u have char(8) and you store a value say 'Harsh' in this variable then it gets stored a 'Harsh___' where at the right the remaining space is padded with blanks, in short all the 8 bits are utilised.
whereas if it would have been a varchar(8) it would have saved it as 'Harsh' meaning only the exact required size is allocated which is 5 in this case.
When you want to store the data in unicode format use nchar or nvarchar .|||Thanks harshal_in :-) :)
That clarifies... One last quick question:
Is it okay to assume then that the best approach is to use nvarchar OR varchar?|||nvarchar uses double the amount of storage compared to varchar, so use varchar unless you need to store double byte data (eg japanese, chinese)|||Originally posted by Joozh
Thanks harshal_in :-) :)
That clarifies... One last quick question:
Is it okay to assume then that the best approach is to use nvarchar OR varchar?
Don't use the NVARCHAR or NCHAR data types unless you need to store 16-bit character (Unicode) data. They take up twice as much space as VARCHAR or CHAR data types, increasing server I/O and wasting unnecessary space in your buffer cache.
If the text data in a column varies greatly in length, use a VARCHAR data type instead of a CHAR data type. The amount of space saved by using VARCHAR over CHAR on variable length columns can greatly reduce I/O reads, improving overall SQL Server performance.
Another advantage of using VARCHAR over CHAR columns is that sorts performed on VARCHAR columns are generally faster than on CHAR columns. This is because the entire width of a CHAR column needs to be sorted.|||There are some advantages to using the CHAR and NCHAR types, but those advantages are somewhat esoteric. If you want more information see Kalen Delaney's Inside SQL Server 2000 (http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=mHu18NPJNB&isbn=0735609985&itm=1) (which I see as a "must read" for a SQL geek anyway).
Basically it boils down to bookkeeping. Variable length columns require the DBE (data base engine) to compute both the start and the length of the variable columns. This adds considerable overhead at the row manager level, which makes access to all of the columns in a row with variable width columns take longer. This isn't significant in most cases, but it does matter for bulk loads and similar operations. Particularly for staging very large warehouses, it can be significant.
-PatP|||But the size of the row can be just as much a performance factor...
For example Char(255) will store all of that...now think about returning all the data, as comp[ared to what is just there...
I beleive a rule of thumb is something like 10 chars...
10 or less make char, otherwise varchar...
Pat?|||It is actually more complicated than that, but you could approximate the rule by using: If the maximum column length minus the minimum column length is more than 10 characters, then use a variable length column. I still say you should just read the book so you'll understand the gist of the rule (and 10,000 other important things) and the factors that weigh into it, but the approximation is a lot better than nothing.
-PatP
Which of the above data type (alongwith size) should be used for storing things like Customer Name, Company name etc . ?
Also, what really is the benefit of one over the over :confused:
ThanksOriginally posted by Joozh
Hi,
Which of the above data type (alongwith size) should be used for storing things like Customer Name, Company name etc . ?
Also, what really is the benefit of one over the over :confused:
Thanks
the difference between char and varchar is that: char is a fixed length datatype meaning, if suppose u have char(8) and you store a value say 'Harsh' in this variable then it gets stored a 'Harsh___' where at the right the remaining space is padded with blanks, in short all the 8 bits are utilised.
whereas if it would have been a varchar(8) it would have saved it as 'Harsh' meaning only the exact required size is allocated which is 5 in this case.
When you want to store the data in unicode format use nchar or nvarchar .|||Thanks harshal_in :-) :)
That clarifies... One last quick question:
Is it okay to assume then that the best approach is to use nvarchar OR varchar?|||nvarchar uses double the amount of storage compared to varchar, so use varchar unless you need to store double byte data (eg japanese, chinese)|||Originally posted by Joozh
Thanks harshal_in :-) :)
That clarifies... One last quick question:
Is it okay to assume then that the best approach is to use nvarchar OR varchar?
Don't use the NVARCHAR or NCHAR data types unless you need to store 16-bit character (Unicode) data. They take up twice as much space as VARCHAR or CHAR data types, increasing server I/O and wasting unnecessary space in your buffer cache.
If the text data in a column varies greatly in length, use a VARCHAR data type instead of a CHAR data type. The amount of space saved by using VARCHAR over CHAR on variable length columns can greatly reduce I/O reads, improving overall SQL Server performance.
Another advantage of using VARCHAR over CHAR columns is that sorts performed on VARCHAR columns are generally faster than on CHAR columns. This is because the entire width of a CHAR column needs to be sorted.|||There are some advantages to using the CHAR and NCHAR types, but those advantages are somewhat esoteric. If you want more information see Kalen Delaney's Inside SQL Server 2000 (http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=mHu18NPJNB&isbn=0735609985&itm=1) (which I see as a "must read" for a SQL geek anyway).
Basically it boils down to bookkeeping. Variable length columns require the DBE (data base engine) to compute both the start and the length of the variable columns. This adds considerable overhead at the row manager level, which makes access to all of the columns in a row with variable width columns take longer. This isn't significant in most cases, but it does matter for bulk loads and similar operations. Particularly for staging very large warehouses, it can be significant.
-PatP|||But the size of the row can be just as much a performance factor...
For example Char(255) will store all of that...now think about returning all the data, as comp[ared to what is just there...
I beleive a rule of thumb is something like 10 chars...
10 or less make char, otherwise varchar...
Pat?|||It is actually more complicated than that, but you could approximate the rule by using: If the maximum column length minus the minimum column length is more than 10 characters, then use a variable length column. I still say you should just read the book so you'll understand the gist of the rule (and 10,000 other important things) and the factors that weigh into it, but the approximation is a lot better than nothing.
-PatP
Subscribe to:
Posts (Atom)