| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 08 September 2005 : 18:51:18
|
| Have read just a bit about it. In principle, I'd say it might be good, since it adds flexibility, and it will add possibilities that you didn't have so far. Of course, this may also be put to bad use, but that's always the tradeoff involved. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 September 2005 : 07:58:47
|
I had bought a book about SQL Server 2005 but hand't paid that much attention to it, so I picked it up to get a bit more info to reply to you.
First, I would consider that the possibility you mentioned, shouldn't bring a change of tiers, when considering where the major of programming should occur. We're talking just about new possibilities, regarding SPs, UDFs and triggers. What programming should go into that? Well, quite likely people will, at large, to use SPs, UDFs and triggers as it was done in previous versions. Their purpose is well known. They have, however, the possibility of using all .NET languages to write these SPs, UDFs and triggers, which adds additional flexibility and may allow you to do things you couldn't do before... Well you could write extended stored procedures before and use them in SQL Server, so the possibility of using any language for that was already there. The use of .NET code, however, is much more secure than what happened before with extended stored procedurs, which adds a lot more reliability to your system.
So, I reinforce the previous idea: this seems a very interesting possibility, specially if used for the its intended purpose. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 09 September 2005 : 18:46:10
|
I don't know much about it yet, just that I'll be able to use C# & VB dotNet to do stored procedures in the future. More than likely I won't upgrade to 2005 for long enough, if I ever do. I have Express installed and must get around to messing with it. For all of the things I wanted to do in this thread I found a few ways to do it, some more convenient than others but at least I had a number of options to choose from.
I have to say that with your help it is now taking me a fraction of the time this job would have taken me. I get timeout errors about 3% of the time (large databases - I use DTS for those instead) but overall I really really happy with it.
When I'm finished this task I'll have another interesting challenge.... |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 September 2005 : 19:48:24
|
You'll be able not only to use C# and Vb.Net but also any other .Net language. T-SQL will still available as well  .
I'm glad that my help can be of use. I have fun doing it too  . |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
|
|
Topic Locked
