Tuesday, June 29, 2010

SQL Azure available in West European Region and East Asia


As announced in one of my previous blogs, the release of SQL Azure Update 3 is now available. This release of SQL Azure is now also available in 2 new data centers. These data centers are located in the West European Region and the East Asia region. In this SQL Azure Update 3 the following new features are available:
  • 50 GB Database Support – You can now store even more data in a single SQL Azure database as the database size has been increased to 50 GB. This will provide your applications increased scalability. For detailed pricing information on SQL Azure and how to create or modify your database to take advantage of the new size, see this blog post.  In general every GB of data will cost 10 $. For business edition started with 100 $.
  • Spatial Data Support - SQL Azure now offers support for the Geography and Geometry types as well as spatial query support via T-SQL. This opens the Windows Azure Platform to support spatial and location aware applications.
  • HierarchyID Data Type Support – The HierarchyID is a variable length system data type which provides you the ability to represent tree like structures in the database.
Enjoy it, and I'm already looking forward to the reporting server support, so we can make use of the all the maps in combination with the supported spatial data support.

Wednesday, June 23, 2010

SQL Server 2008 R2 Developers Training Kit (June 2010 update)

SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server.



Image credit: Knurftendans

The training kit offers the following benefits:

  • Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
  • Provides a comprehensive set of videos, presentations, demos and hands-on labs
  • Contains new content for developers who are new to SQL Server.
  • Contains new content for SQL Server 2008 R2.
  • Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
  • Easy to download and install.
The training kit is designed for developers, technical specialists and consultants.

Content of the training kit:
32 presentations
39 demos
24 hands-on labs
55 videos'


Click here to download the SQL Server 2008 R2 Update for Developers Training kit.

I think you will enjoy it.

Thursday, June 10, 2010

Windows 7 upgrade from XP or Vista: Yes or No looking from a user perspective

Windows 7 is commercial avaliable since 22 October. A lot is already  written about Windows 7. In this blog I will share my personal experiences about Windows 7. I have used a lot of different operating systems in the past on my laptop. Windows NT 4 workstation, Windows 95, Windows Server 2003, Windows XP, Windows Vista and Windows 7.


Photo credit: Oskay


During my upgrade to Windows Vista is was the first time that I had a negative experience in the upgrade of my laptop. Of course some things improved but I also lost some things which works perfectly in Windows XP. I will give my 4 biggest disappointments:
  1. Power usage. Impossible to configure brightness difference of my screen between plugged in and running on batteries. I'm always looking to the optimal power management configuration when running on batteries. It gives me a lot of flexibility. The longer I can run on batteries the better is my user experience. Overall I experience 20 percent less time running on batteries.
  2. Wireless network connectivity. I work a lot at home and in the office. Both have their own wireless network. To travel between home and the office I uses the sleep or hybernate function to close my laptop.  In 60 percent of the situations reconnecting to the internet works fine however in 40 % I need to turn of my wireless card or reboot my machine. As you can imagine this is a bad user experience especially because rebooting takes a lot of time to do.
  3. Hibernate does not work in combination with Sleep. My laptop is configured to sleep when I close the lid. At the end of the working day I hibernate my laptop with the power button. If I close the lid to early, my laptop switch to sleep. At home, I open my laptop which wakes up from sleep and continues the hybernation process. On XP the hybernation process is not interupted by the sleep process.
  4. Availabilty of drivers. For instance for printers and camera's
Because of my negative experiences with the upgrade from Windows XP to Vista, I decided to wait a few weeks with upgrading my laptop to Windows 7. I wanted to hear the experiences of other people. After hearing mostly good stories from a lot of people I upgrade my laptop to the 64 bits version of Windows 7. Unfortunaltly, I need to do a reinstall because an upgrade from Vista 32 bits to Windows 7 64 bits is not supported. The new install of Windows 7 was amazing fast. Within 15 minutes I was connected to the internet. However the rest of the day I was busy with reinstalling the rest of my applications, including service packs and security updates. For instance:  MS Office, Live Meeting, Communicator, Antivirus Software, Visual Basic, SQL Server 2008 including Reporting Server and Analysis Server etc..


Are my 4 biggest disappointments solved with the upgrade to Windows 7 ?
  1. Power usage is not solved. Power usage is the same as on Windows Vista.
  2. Wireless network connectivity is solved. I do not experience reconnections problems anymore between different wireless networks.
  3. Hibernate does not work in combination with Sleep. This is not solved.
  4. Availability of drivers. This is solved. I decided to upgrade to the 64 bits version of Windows 7. Without any problems I could find all 64 bits drivers I needed.
Should you upgrade to Windows 7? The answer is Yes but it depends.
  • Are you running on Windows Vista? Yes upgrade to Windows 7 without any doubt. It will improve you overall user experience.
  • Are you running on Windows XP, my advice is to upgrade to Windows 7 when you planned to replace the hardware.
  • Buying new hardware: Vista or Windows 7. Buy Windows 7. In case you have more the 3 GB of memory, select the 64 bits version. This will avoid manually memory configurations to use all memory.

I realize that a lot of users can't make the choice them selves to upgrade. There are more factors to consider, like application compatibility. For what I have seen, if your application runs on Vista it will also run on Windows 7.  Within my company we did not make any changes to our application Globe to get certified for Windows 7. We only add some typical Windows 7 features to it like the jumplist.


What do I like the most of Windows 7?

The answer is simple: Live taskbar previews. Look to this movie if you do not know what live taskbar previews are.



A dutch version of this blog post is available on the computable site.
Enjoy using Windows 7.

Thursday, June 3, 2010

Did you already request an improvement report for your Exact solution?

As mentioned in a previous blog post, Exact started developing the Exact System Information (ESI) tool. With this tool you can receive an improvement report via e-mail. What can you expect in the report?


1. Server improvements.

The server improvement section is related to your SQL server configurations and answers questions like: Have you installed the latest Service packs? Can you make changes in your SQL Server configuration to make use of all available memory? Etcetera.

Screenshot of Server Improvements:


2. Database improvements.

The database improvements section is related to the database itself and gives advice about new available product updates, clean up of historical journal records, clean up of voided entry record, background jobs, clean up of temporary tables etcetera.

Screenshot of database improvements:


The number of requested improvement reports are growing every month. The Exact System Information tool can be downloaded and used for free by all organizations that uses Exact Globe and/or Exact Synergy (Enterprise). Did you already request an improvement report? Do not forget to specify your email address when running the tool.


If you have feedback please comment on this blog or send an email to Andre.van.de.Graaf@exact.com
The ESI tool can be downloaded here. This blogpost is also published on the Exact Product Blog.