Monday, December 31, 2007

Happy New Year

B4 the sun sets on 2007, b4 the memories fade, b4 the networks get jammed & b4 i get smashed & lose my phone, i am wishin you a very happy 2008...

Telstra Release Windows Mobile 6 Upgrade For Palm Treo 750

Telstra has finally released it's long awaited Windows Mobile 6 upgrade for the Palm Treo 750. More details can be found here.

Not sure if I'll upgrade to their version or just keep using the version I installed via this method.

Wednesday, December 19, 2007

SQL Server Compact 3.5 - Cross Version Comptibility

There has been quite a lot of discussion on the SQL Server Compact Edition MSDN Forum since SQL Server Compact Edition 3.5 was released and most of it has been around it's compatibility (or lack of) with SQL Server 2005 and SQL Server 2008. The good news is that the SQL Server Compact Team have released a great post on their blog about "Connectivity cross version compatibility scenarios for the SQL Server Compact 3.5 release" which should help alleviate some of the misconceptions about the product.

Summary:

  1. SQL Server Compact 3.5 can synchronize with only SQL Server 2005 not with SQL Server 2000.
  2. SQL Server Compact 3.5 Server Tools enables synchronization between SQL Server Compact client versions 3.0, 3.1, and 3.5 and SQL Server 2005 through SQL Server Compact3.5 IIS components.
  3. SQL Server Compact 3.5 SP1 can synchronize with both SQL Server 2005 and SQL Server 2008.
  4. SQL Server Compact 3.5 SP1 Server Tools package enables synchronization between SQL Server Compact client versions 3.0, 3.1, 3.5 and SQL Server 2008 through SQL Server Compact 3.5 SP1 IIS components.

Some of you may have notice that they talk about SP1 versions of SQL Server Compact 3.5 and SQL Server Compact 3.5 Server Tools. Here is a release plan for these packages (no dates provided):

  1. Phase1: Release SQL Server Compact 3.5 Server Tools package for SQL Server 2005 and SQL Server Compact 3.5 SP1 Beta Server Tools package for SQL Server 2008.
  2. Phase2: Release the SQL Server Compact 3.5 SP1 Server Tools package for both SQL Server 2005 and SQL Server 2008. This new package will replace the Phase 1 packages.

The original post also provides a fair bit of detail on various Deployment Scenarios for SQL Server 2000/2005/2008 and SQL Server Compact Edition 2.0/3.0/3.1/3.5 . It doesn't however cover any of the following deployment scenarios:

  1. Upgrading clients from SQL Server Compact version 2.0 to versions 3.0 and 3.1
  2. Upgrading from SQL Server 2000 to SQL Server 2005
  3. Mixed installations including SQL Server compact client versions 2.0, 3.0, 3.1 and SQL Server or publisher versions SQL Server 2000 (8.0), and SQL Server 2005 (9.0)

For more information about these deployment scenarios, please see SQL Server Compact 3.1 Connectivity Tools documentation.

Cross Version Compatibility Support Matrix


The following tables provides the cross version compatibility support for each different type of deployment scenario. The table includes:

  • “Dx”: An identifier for each different scenario.
  • “Existing Support”: A deployment that is already supported. For more information, see SQL Server Compact 3.1 Connectivity Tools.
  • “New Support”: A new supported deployment. This new deployment is explained in this blog post later.
  • “Pending Support”: Specifies that SQL Server Compact 3.5 RTM does not support synchronization to SQL Server 2008 but this support will be enabled in SQL Server Compact 3.5 SP1.


The following table summarizes the compatibility with SQL Server Compact, SQL Server and server IIS components. For more information, see Section 2 Deployment Scenarios. This section requires thorough understanding of Merge Replication deployment.

The full post can be found here.

New Australian Operation of Solid Quality

Greg Low has finally blogged about leaving Readify so I guess this now means it's ok for me to blog about it too :-)

Greg has decided to leave Readify and immerse himself even deeper into SQL Server and surrounding technologies (don't know how that's possible, but I do know it's going to mean great things for the Australian SQL Server Community!).

Greg's old friend and fellow RD Fernando Guerrero (Barcelona) contacted him and asked if he would be interested in setting up a new Australian operation for Solid Quality (http://www.solidq.com/). Well, Greg said yes and will be partnering up with Peter Myers (another SQL Server guru and mentor) to run Solid Q Australia Pty Ltd. What a team!

You can read more about Greg's decision here.

Tuesday, December 18, 2007

SQL Server 2008 Certifications

Trika has kindly provided an explanation on her blog as to why the SQL Server 2008 and Your Microsoft Certifications MCP live meeting was rescheduled once again (Brave girl to have taken some of the blame!). All is not lost though as Trika also provides a link to Gerry's recent blog post on SQL Server 2008 and Certifications.

Summary of SQL Serve 2008 Certifications

  • Two new SQL Server TS level exams planned
    • 70-432 : Will be the SQL Server 2008 equivalent to 70-431 (SQL Server 2005)
    • 70-448 : Will be the SQL Server 2008 equivalent to 70-445 (SQL Server 2005)
  • Pro level exams will more than likely be released 6-12 months after the TS exams. Why? To provide an opportunity for people to get more experienced with the product and understand how it fits in their organisation. This helps to create better Pro exams that are more relevant to the technology and its use.

The design session for 70-432 apparently took place between 12th to 14th December 2008 so this obviously means that the study guide and exam format is still not finalised. Gerry does however point out that this shouldn't stop people studying for the exam and provides the following tips for those wishing to prepare for it's eventual release:

  • Features across 2005 and 2008 are relatively the same except for new additions
  • Download the November CTP or the VHD and install it so that you can become familiar with it now.
  • Read SQL Server 2008 Books Online and pay attention to the "What's New" section for features that have been added or changed as this is likely to be in the exam.
  • Microsoft Learning also has three eLearning clinics on what's new in SQL 2008.

You can also do the Microsoft SQL Server 2008 Virtual Labs outlined in my earlier post.

No other information was provided about exam 70-448.

Saturday, December 08, 2007

INETA APAC Speakers Bureau

Just found out about another benefit of winning Speaker Idol; automatically becoming a member of the INETA APAC Speakers Bureau.

The INETA APAC Speaker Bureau provides user group leaders top notch speakers for their key events. The speakers are provided at no cost to the user group.

If you want to request a speaker for your user group meeting, login to INETA, choose Resources -> Speaker Bureau page and Select Request Speaker. Alternatively if you have a query post a request on the Support Forum (Note: These options are only viewable by user group leaders).

Heroes {Community} Launch

On December 7, technical communities around the world will have the opportunity to participate in a virtual train-the-trainer and launch execution program consistent with the 08 Launch Wave of Windows Server 2008™, Visual Studio 2008™, and SQL Server 2008™.

The Heroes {Community} Launch is an exclusive opportunity to work directly with Microsoft to host your own launch event around Windows Server 2008, Visual Studio 2008, and SQL Server 2008 Microsoft products. The program provides participants with the technical training and launch support resources to showcase some of the technical features of these products within their local community.

As a member of INETA, Culminis and the president of the Canberra SQL Server User Group, I have been invited to enroll as a Heroes {Community} Launch Leader.

So what's the value of being a Heroes {Community} Launch Leader?

Well, I:

  • Get to work directly with Microsoft product groups and subject matter experts to lead a launch event in your local community.
  • Get to be the first to receive new highly relevant and deeply technical training content for Microsoft Windows Server 2008, Visual Studio 2008, and SQL Server 2008.
  • Get to participate in live Q & A sessions with Microsoft and community subject matter experts.
  • Receive complimentary Microsoft e-learning courses that focus on the new and enhanced features of Windows Server 2008.
  • Gain access to speaker and presentation training from Microsoft resources and accredited community experts.
  • Gain access to the Heroes {Community} Launch portal where you can share ideas and success with other Community Launch Leaders worldwide.
  • Receive a product oriented launch kit to support your event.
  • Receive a recognition and thank you package which will include premium versions of product NFR.

Can anyone be a Heroes {Community} Launch Leader? Yes and No.

Firstly; you must be invited to participate. Call for action has so far been sent by MS Global Field, INETA, Culminis, SQL PASS, MSDN/TechNet, CPLS, Microsoft Student Partners (MSP) and User Group Support Services (MS UGSS ). As a User Group Leader I can also nominate two other people to participate. Secondly; once you have registered, Microsoft will coordinate with their regional subsidiaries and INETA to confirm your eligibility to receive a launch kit consistent with the program guidelines.

So, did I choose anyone to help me out? Sure did.

I chose Shaun Baggett who is a regular attendee of the Canberra SQL Server User Group, SQL Down Under Code Camp, CodeCampOz and Canberra .NET User Group, and Catherine Eibner who also attends these events, has presented sessions for both the Brisbane and Canberra SQL Server User Groups and was one of the sponsors of the inaugural Influencers Party at TechEd Australian 2007. They are also people that I know quite well and who I believe will help make this the best ever SQL Server launch for our community.

Friday, December 07, 2007

Free SQL Server 2008 Training

Here are some more SQL Server 2008 training resources.

Collection 6187: What's New in Microsoft SQL Server 2008

In this 3 hour online collection, IT Professionals and Database Developers will learn about the new features in SQL Server 2008. Topics covered within these clinics include:

Thursday, December 06, 2007

SQL Server 2008 CTP5 VHD

Peter has just pointed out that the VHD of SQL Server 2008 CTP5 is now available for download.

So if you've been holding back on trying out all the new features in SQL Server 2008 CTP5 as you didn't want to go through the hassle of installing it, you've now got no excuse!

I Just Got Elfed!

Hey, I (well Laura) just made a total elf of myself. Check it out by clicking the link below.

http://www.elfyourself.com/?id=1187589864

and here's one I made of the 2007 TechEd Influencer Organisers (and who said we couldn't dance!)

http://www.elfyourself.com/?id=1189499591

This elfin' greeting brought to you by OfficeMax.

Wednesday, December 05, 2007

Microsoft SQL Server 2008 Virtual Labs

Want to learn more about SQL Server 2008? Check out these Virtual Labs

What's new in SQL Server 2008 for Database Administrators

In this lab you will be introduced to some of the new features for database administrators in SQL Server 2008. You will work with the new date data type, implement a Declarative Management Framework (DMF) policy and look at new features added to database mirroring. You will also implement and work with table valued parameters and look at database changes using change data capture (CDC).

Implementing Change Data Capture (CDC) in SQL Server 2008

Change data capture (CDC) is designed to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format. The change tables used by CDC contain columns that mirror the column structure of a tracked source table, along with the metadata needed to understand the changes that have occurred. In this lab you will perform the necessary steps to enable data capture in a database.

Working with the new DATE data type in SQL Server 2008

SQL Server 2008 supports several new data types. In this lab you will compare the new DATE/TIME data types to the SQL Server 2005 data types and implement the new data types in table definitions and T-SQL batches.

Administering Servers by Using Declarative Management Framework (DMF) Policies

Declarative Management Framework (DMF) is a policy-based system for managing one or more instances of SQL Server 2008. When SQL Server policy administrators use DMF, they use SQL Server Management Studio to create policies to manage entities on the server such as the instance of SQL Server, databases, or other SQL Server objects. In this lab you will implement a DMF policy and implement that on the server-level, including filtering.

Learn How to Build Occasionally Connected Applications with SQL Server 2008

Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact 3.5.

Authoring Reports Using SQL Server 2008 Reporting Services

After completing this lab, you will be able to launch the Report Designer Preview, create a data source and a data set, design a new report using the Report Designer of SQL Server 2008 Reporting Services, preview your report, enhance your report layout by working with Tablix functionality, and enrich your report using charts.

Tuesday, December 04, 2007

Speaker Idol Prize - MS Press Books


Today the second part of my Speaker Idol prize arrived; my MS Press books. The first part was a trophy (pictured with the books) and the last part is a speaker ticket for TechEd-Developers 2008 which is being held in Barcelona.

I got 22 books all up. Some of which I'll be keeping for myself; others I'll give away as prizes at the Canberra SQL Server User Group.

So what books did I choose? Here's a list:

Books I'm Keeping

  • Inside Microsoft SQL Server 2005: The Storage Engine
  • Inside Microsoft SQL Server 2005: T-SQL Programming
  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
  • MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence Implementation and Maintenance
  • Microsoft® SQL Server 2005 Reporting Services Step by Step
  • Microsoft SQL Server 2005 Analysis Services Step by Step
  • Microsoft SQL Server 2005 Administrator's Companion
  • Microsoft Mobile Development Handbook

Books for Prizes

  • MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (x 2)
  • MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 (x 2)
  • MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (x 2)
  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 (x 3)
  • MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence Implementation and Maintenance
  • Inside Microsoft SQL Server 2005: T-SQL Querying
  • Microsoft SQL Server 2005 Administrator's Companion
  • Introducing Windows Server 2008 (x 2)

Once again, big thanks to all the Speaker Idol Organisers, Compères, Judges and MS Press.

Cheers
Jeff

Sunday, December 02, 2007

MCT Summit (Australia) : 29th-31st January 2008

I've just found out that I'll be presenting three sessions at the Australian MCT Summit; Train the Trainer on SQL 2008 Clinics, SQL Server 2008: What’s New, and SQL Server 2008 Advanced Administration.

Further details about the summit can be found at https://www.local.microsoft.com.au/australia/events/register/home.aspx?levent=993019&linvitation

Hope to see you there :-)

WARDY IT Solutions - November 2007 SQL Server Newsletter

The November 2007 edition of the WARDY IT Solutions SQL Server Newsletter has been released and can be viewed at http://www.wardyit.com/newsletters/nov2007.htm.

In this issue we cover:

To subscribe to the newsletter send an email to newsletter_add@wardyit.com.