Contents tagged with Sql Server 2005
-
How to get an Identity value with SQL Server 2005
It's usual (actually, I'd say recommended) to have an Identity int column as primary key. I.e., it's a common thing to define a table like this:
-
Do that come with an E1^n! line?
In an announcement on the future of SQL Server and related technologies, Paul Flessner mentions that:
-
Slides for the JSP - ASP.NET Architecture Comparison Webcast
As promised I just uploaded the demo files for the JSP - ASP.NET Architecture Comparison webcast. You can now download the JSP demo project (made with Eclipse) and the ASP.NET demo project (made with Visual Web Developer). Both projects connect to the Northwind database running on SQL Server Express, you will most probably have to modify the connection strings (in the Java data access classes and the ASP.NET web.config file). Do let me know if you have any problems.
-
SQL Server: very popular for new projects
According to this article, 51% of new projects chose SQL Server, fairly ahead Oracle (36.4%) that in turn is way ahead of the rest. Moreover, at least that what it seems like anyway, decision making was done without taking into account SQL Server 2005 which bring even more to the table.
-
TechEd 2005: Day 2 Morning
Paul Flessner keynote had some sexy demos and a few good jokes (and some of usl got a little nervous with the Compact Framework battlebot breaking a SQL Server 2005 connection). Parafernalia aside, the most importants point for me were:
-
Developer webcasts in Spanish
This site has announcements on developer webcasts in Spanish, with emphasis on Visual Studio 2005 and SQL Server 2005 ¡Pasen la voz!
-
Webcast: Clientes inteligentes con Windows Forms 2.0
First of all, I must apologize because, due to technical problems, we weren't able to present live last week webcast (De ASP.NET 1.1 a ASP.NET 2.0). I hope this time we don't have any problems.Today, Tuesday April 19 2005, starting at 2 P.M. Eastern Time (GMT -5), that is 13h00 in Panamá-Bogotá-Quito-Lima, I'll be doing a webcast on the development of smart clients using Windows Forms 2.0. You can register and then join the presentation at http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032273483&Culture=es-MX. Once again, I hope and pray we can go live without problems this time. -
CTEs in SQL Server 2005
SQL Server 2005 brings a handful of interesting enhancements inside TSQL Data Manipulation Language. An example:
-
SmartClient Offline Application Block on .NET 2.0
Today I had the pleasure of showing some concepts and examples of Smart Clients to over 200 people. For doing that, I used the Offline Application Block that has been around for a year already. The interesting thing is that I moved it to Visual Studio 2005 and I compiled it: a change here and there aside, the Application Block moved to .NET 2.0 without problem. Encouraged, I did the same with IssueVision and everything went OK again. It seems like compatibility between .NET 1.1 and .NET 2.0 is doing pretty well. Oh, and I almost forgot: smart clients are cool.
-
VS 2005 Beta 2, RCs and Final Release Dates anyone?
Our small software shop has made its name by aggesively adopting new technologies. At different times it's been Pascal as a business apps language (we've been in the market for a long time... :-( ), LANs, PowerBuilder, Lotus Notes, Java, .NET. Along the years, we've been among the first in our country to create business apps using these technologies, often with Beta versions. Now is the time for .NET 2.0, VS 2005 and SQL Server 2005: we are currently working in 3 projects with these new technologies (it would've been 4, but the 4th was a big bank and they dimmed too risky to use 2005, so we settled on .NET 1.1 and VS 2003). About our 3 Whidbey projects: