Browse by Tags

All Tags » Sql Server 2005 (RSS)

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 : CREATE TABLE HumanResources.Employees ( Id int IDENTITY ( 1 , 1 ) NOT NULL, -- Other columns , CONSTRAINT...
Posted by Edgar Sánchez | 9 comment(s)
Filed under:

Do that come with an E1^n! line?

In an announcement on the future of SQL Server and related technologies, Paul Flessner mentions that: Today the cost of storage continues to be on an amazing trajectory; one could reasonably expect that the cost of a terabyte will be reduced from about...
Posted by Edgar Sánchez | 1 comment(s)
Filed under:

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...

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...
Posted by Edgar Sánchez | 1 comment(s)
Filed under:

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: We've got an official...

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...

CTEs in SQL Server 2005

SQL Server 2005 brings a handful of interesting enhancements inside TSQL Data Manipulation Language. An example: Let's say that on the good old Northwind Products table we are asked to separate the products by price in three groups; we have to take the...
Posted by Edgar Sánchez | with no comments
Filed under:

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...

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...
More Posts Next page »