who uses sql server?

hey all,
it's good to see that posts are starting to come through...just wondering, how many of you actually use sql server. it's about 40% in the currnt poll, but i want to hear actual peoples stories... for example your job, role, sites/apps you've worked on, etc... just a bit of a bio if you like...

We are a web and windows development shop. We use mainly sql server there, but allow customers to pick from other databases. those that have no preference get Sql Server. We also support Oracle and Informix, as well as have supported Interbase in the past.

Sql server is our database of choice now, and we (I) am building up quite a store of code to help support that database. Stored procs and utilities and the like.

i used both sql server and mysql...depends on the scope of the application. i used sql server for really big ecommerce apps and mysql for everything else. i love using mysql on both win and linux with php..it's a great combo.

with sql server i used triggers, sproces, udf's, bcp, etc...

I do use MySql and php for web development not associated with my day job. I have been contracting and tinkering with my own sites and ideas for a few years now. I do love mysql for what it does in its realm. I wish that there was one db with all great features... but alas.

So for the web site development, it was cheaper in the beginning to go with php and mysql, and I have since come to love and appreciate them in their own right.

Being a Development DBA I find ita unique experience to develop against all these dbs and gain broader experience with them all.

I have tinkered with sql server, hopefully when i get some time, ill be able to develope a small app to fully test it. but untill then, its just gonna stay on my machine.


But i mainly use mysql (since its free and easy to use)

i'm just testing it out right now, cause i dont know the first thing about running any apps with it. i'm slowly gonna ease my way into learning it, so maybe i can make my own discussion board in asp one day, using sql on the backend cause ms access is too slow

I use Sql Server for the most of my projects whether its big or small if it is programmed with, .NET.

With .NET I use it because it's Sql optomised objects are around 10 times faster than of OLEDb ones. That's a lot of performance difference.

Another good reason i use Sql server is its expandability and availability. I first develop my apps using MSDE (Microsoft Data Engine) which is free. Then the company buying the app can decide wether they want to buy the Sql Server or stay with MSDE.

its expandable and its freely available for the developers.

If you think MSDE isn't good enough, there is Sql Server enterprise edition 180day evaluation which is also free.

Do you have free material on the Internet that I can make a fast start offf on the MSSQL which I can download it to read locally?

are you serious?? also when i installed msde it installed sql server 7, is that free too?? also you guys should write more mssql articles

MSDE doesn't really install SQL server. MSDE is like stripped version of SQL Server...

It might look like a SQL Server but it reallsy is MSDE..

here is quote from MSDN about MSDE

Hey guys,
ASP_MAN, did you read my article on Beginning SQL Server 2000? it should contain everything you need to know to create your first database. It's here: http://www.devarticles.com/art/1/109

YOu're also in luck, because i'm about to publish an article on SQL Server 2000 today Don't worry guys, i've been busy behind the scences with our writers and I have a couple of *HUGE* deals in the pipe line which I can't discuss yet, but let's just say that we're going to increase in size in terms of content and visitors 10 fold within 3 months :P

Keep an eye out for my article, will be here this afternoon.

P.S.: We will be writing alot more MySQL and MSSQL articles now that we've seen the results of the poll.

Great news to have another MSSQL article. I did install the MSSQL, but since I do not have any good reference, I dare not touch it yet. I am expecting the new article. Thanks in davance.

we are on the same page there

Cool, MSSQL is still abit above me, but im looking forward to reading the article