5.20.2005

Platicas Sobre SQL Server Mobile en México y Guadalajara

Una vez más tuve el honor de dar un par de pláticas. En esta ocasión sobre SQL Server Mobile (antes conocido como SQL Server CE versión 3.0). Los eventos fueron en la reunión de la Comunidad .NET de la Ciudad de México y en el Microsoft DevDays de Guadalajara.

Es un avance muy importante el de esta versión contra las anteriores.

Lo que más me ha llamado la atención es:

  • La capacidad de SQL Mobile para trabajar con apps en el .NET CF 1.0 (en VS 2005 Beta 2). Es decir, no solo funciona con el .NET CF 2.0.
  • La integración al SQL Server Management Studio de SQL Server 2005. Este tema realmente simplifica las cosas en desarrollo móvil:
    • Podemos editar bases de datos de SQL Mobile en la PC.
    • Contamos ahora con un analizador de consultas para SQL Mobile.
    • Podemos llenar una base SQL Mobile usando DTSs.
  • Lo mejorado y simplificado de la replicación entre SQL Server 2005 y SQL Server Mobile.
    • La configuración, diagnóstico e implementación de replicación (merge replication) es sin exagerar un orden de magnitud más sencilla que antes.
    • El desempeño es mucho mejor gracias al rastreo de cambios a nivel de columna además de renglón.
    • Podemos hacer mucho mejores interfases de usuario en el dispositivo móvil gracias al manejo asíncrono y a los eventos que expone el motor de sincronización.
  • El desempeño de las consultas en el dispositivo móvil gracias al nuevo SQLResultSet que evita que tengamos dos copias en la memoria de los datos (como ocurre con un DataSet) pero al mismo tiempo es más flexible que un DataReader.
Hay muchas otras mejoras, pero estas son las que me parecen más interesantes.

Del lado negativo, hay algunas cosas que falta pulir (espero que así sea para la liberación final más adelante este año):

  • El desempeño del despliegue a los dispositivos o a los emuladores cuando estamos depurando en Visual Studio 2005 es muy malo ya que siempre redespliega todo el .NET CF 2.0 y el SQL Server Mobile. Esto no debiera ser así y quizá se deba a algún problema de configuración. Si encuentro una solución la podré aquí.
  • El consumo de memoria de almacenamiento en el dispositivo de la combinación de el .NET CF 2.0 y el SQL Server mobile es demasiado alto, dejando al dispositivo (si tiene 64MB) con muy poca memoria libre.
También al estar explorando este tema he tenido oportunidad de irme familiarizando con la funcionalidad de Visual Studio 2005. Me parece también un salto importante y hablaré de esto en un futuro post.

Si te interesa más este tema puedes bajar las láminas de mi presentación y el código ejemplo desde el sitio de noticias de emLink.

1 comentario:

eddhuron2091 dijo...

St0ck For Your Review - FCPG

Current Profile
Faceprint Global Solutions (FCPG)
Current Price $0.15


A U.S. based-company dedicated to the goal of
bringing effective security solutions to the marketplace.

With violent and white-collar terrorism on the rise,
companies are starving for innovative security solutions.

FCPG is set to bring hot new security solutions to
the industry, with currently over 40 governmental and
non-governmental contracts, being negotiated.

Please Review Exactly What this Company Does.

Why consider Faceprint Global Solutions (FCPG)?

Faceprint Global Solutions (FCPG) holds the exclusive
marketing rights from Keyvelop, to sell the world�s
leading encryption technology to be distributed directly
to the Healthcare industry in North America.

Faceprint Global Solutions has completed its biometric
software that recognizes facial features of individuals
entering and leaving through airports, ship yards, banks,
large buildings, etc.

FCPG acquired Montreal-based Apometrix Technologies,
which enhances the companies mission of being a
full-service provider to the multi-application smart
card industry. The North American market appears ready
for significant expansion of price-competitive, proven,
multi-application solutions on smart cards. Apometrix's
forecast of over 300 customers and sales of more than $50
million in North America over the next five years, appears
very realistic, according to company management.

Faceprint Global Solutions is currently in contract negotiations
with over 40 governmental agencies and businesses seeking to use
their encryption, biometric, and smart-card technologies.

Breaking News for Faceprint Global Solutions (FCPG)

Faceprint Global Solutions (FCPG) is pleased to announce that
IBM will now offer the world�s leading encryption software to
its major Healthcare clients in North America.

With FCPG owning the exclusive North American rights to distribute
the worlds leading encryption and transmission software developed by
Keyvelop, FCPG is poised to capture large volumes of sales generated
by customers currently using IBM�s software in the healthcare and other industries.
�This is a very positive move for FCPG and for Keyvelop,� said FCPG
CEO Pierre Cote. �We are very happy about the decision to go with IBM.
This is a continuation of the progress made by everyone associated
with FCPG and its partners.�

Buell Duncan, IBM's general manager of ISV & Developer Relations commented,
�Collaborating with Keyvelop will ensure that we develop open solutions
that are easy to maintain and cost effective for our customers in the
healthcare and life sciences industry.�

Among other things, this new software technology which is currently
being used by a number of European healthcare companies, is used to
send any file, regardless of format or size. Encryption keys, evidence
of transmission integrity with fingerprint calculation, time-stamping
of all actions and status record updating, pre-checking sender and
receiver identities, validating file opening dates are part of Keyvelop features.
About FacePrint Global Solutions, Inc.

FCPG operates a business, which develops and delivers a variety of
technology solutions, including biometric software applications on
smart cards and other support mediums (apometric solutions). FCPG�s
products provide biometric solutions for identity authentication and a
host of smart card- and biometrics-related hardware peripherals and
software applications. Apometrix, FCPG�s wholly-owned subsidiary, combines
on-card or in-chip multi-application management solutions with best-of-breed
�in-card matching� biometrics. Keyvelop�s secure digital envelope solution
and Apometrix�s on-card biometrics work together to produce the winning
combination in the fields of security, traceability and identity management.
Conclusion:

The examples above show the Awesome, Earning Potential of little known
Companies That Explode onto Investor�s Radar Screens. This sto,ck will
not be a Secret for long. Then You May Feel the Desire to Act Right Now!
And Please Watch This One Trade!

GO FCPG!

Disclaimer:
Information within this email contains "forwardlooking statements" within
the meaning of Section 27Aof the Securities Act of 1933 and Section 21B of
the Securities Exchange Act of 1934. Any statements that express or involve
discussions with respect to predictions, expectations, beliefs,
plans, projections, objectives, goals, assumptions or future events or
performance are not statements of historical fact and may be "forward
looking statements". "Forward |ooking statements" are based on
expectations, estimates and projections at the time the statements are made
that involve a number of risks and uncertainties which could cause actual
results or events to differ materially from those presently anticipated.
We were paid a sum of three thousand USD to disseminate this information from
ir marketing. Forward loking statements in this action may be identified through
the use of words such as "projects", "foresee", "expects", "will", "anticipates",
"estimates", "believes", "understands" or that by statements indicating
certain actions "may", "could", or "might" occur. Risk factors include
general economic and business conditions, the ability to acquire and develop
specific projects, the ability to fund operations and changes in consumer
and business consumption habits and other factors overwhich the company has
little or no control. The publisher of this newsletter does not represent
that the information contained herein are true and correct.