CodeGuru Poll: What version of SQL Server are you using?

Quote:

---

Originally Posted by x8086

....so I don’t think so that SQL Server 2005 will have something very different.

Bottom Line Is it doesn’t matter what the DATABASE Is or you are working on BESIC concepts Remain same in all the databases and across all the platforms

---

Sorry, but I also have to disagree for the most part. SQL Server 2005 is bringing lots of changes and improvements. I'll see if I can get an article created with some of the details for our site.

Having said that--
If you are using a database in very minor ways -- accessing small amounts of data in simple table with no concern for speed -- then you are correct in that there is probably no need for a leading-edge database. If, however, you are using advanced features such as DTS, BI, replication, and using large quantities of data in complex fashions, then I believe you'll find upgrading to newer databases can be evolutionary. If you use things like Reporting Services and Analysis Services, then you're goingto probably want to upgrade.

SQL Server 2005 Express Edition is also the replacement for MSDE. This should also be a great improvement for those needing a small engine in their apps.

I just got back from Microsoft and part of what I did there was to be presented details on the features coming in SQL Server 2005. There is some very cool stuff in this release. There are CTP versions available if you want to check it out.

Brad!

Quote:

---

Originally Posted by Brad Jones

SQL Server 2005 Express Edition is also the replacement for MSDE. This should also be a great improvement for those needing a small engine in their apps.

---

This is interesting. What are the system requirments for SQL Server 2005? Does it require the .net framework installed on the system running it? If not, GREAT! If so, useless.

Personally, I avoid anything (feature) of one DBMS that makes porting my database applications from one DMBS to another. It's more work in the application development, but it doesn't tie me to one database vendor.

Being that stored procedures can be written in C# or VB.NET rather than T-SQL, I'd guess that .NET is required. (T-SQL can still be used, but C# and VB.NET let you do queries much more efficiently -- (less lines of code).

I'll see if I can find a list of requirements and post them.

Brad!

Quote:

---

Originally Posted by DHillard

Does it require the .net framework installed on the system running it?

---

Seems yes..
Check the system requirements

Quote:

---

Originally Posted by hspc

Seems yes..
Check the system requirements

---

Seems yes, and seems like it requires version 2.0 of the Framework (which is the current beta version).

Brad!

SQLite