Learning Mandarin and Windows Vista

Some readers will know that I’ve been learning Mandarin lately. It’s been really interesting. Most people assume I want to do it because my wife Mai is of Chinese Vietnamese heritage. No such luck as her family speak Tieu Chow, a dialect spoken mainly in part of Vietnam, part of Cambodia and part of Southern China. One in four children born in the world today speak Chinese. I’ve always heard it was really hard but have decided to tackle it anyway. I’ve enabled my Windows Vista system for Chinese input as I’m determined to learn to write as well as read. … Continue reading Learning Mandarin and Windows Vista

SQL Server 2008 now Q3

SQL Server 2008 has now officially slipped to Q3 this year. Details are at: http://blogs.technet.com/dataplatforminsider/archive/2008/01/25/microsoft-sql-server-2008-roadmap-clarification.aspx  

SQL Server 2008 – How effective was my backup compression?

I’ve had a number of people ask me how you can tell if the backup compression in SQL Server 2008 really is effective. The easy answer is to try it and look at the results. To compress a backup, you need to choose the “Compress Backup” option at the bottom of the Options tab in SQL Server Management Studio. Once the backup is done, you can see how effective it was by executing: RESTORE HEADERONLY FROM DISK = ‘PathToYourBackupHere’ This command has been enhanced to have two columns dealing with backup size. One shows the Backup Size, the other shows the … Continue reading SQL Server 2008 – How effective was my backup compression?

Playing videos and sound in Windows Server 2008 using a Virtual PC (VPC)

Over recent weeks, I’ve been involved in building some of the launch materials for the worldwide SQL Server launch events later this year. In the filestream section, I wanted to play a wmv file ie: a video. I thought “that can’t be too hard”. I was wrong on that. I’ve now spent a long time working out what’s needed. In the end, it’s trivial to do. You just have to know what to do. After much googling, all I found were people with lots of questions and few answers. Here’s what you need to do: 1. If you’re using Virtual … Continue reading Playing videos and sound in Windows Server 2008 using a Virtual PC (VPC)

SQL Down Under show 28 – Ed Lehman

SQL Down Under show 28 is now up on the www.sqldownunder.com download site. In this show, my guest Ed Lehman (the community lead for SQL Server at Microsoft) discusses the community around SQL Server, the MVP program, the Connect feedback site, the newsgroups, forums and CodePlex. Enjoy!

SQL Down Under show 27 – SQL Legend – David Campbell

Regular readers will notice that I’ve stepped up the pace of podcasts lately. I’m intending to maintain a one-per-week pace now. Last week, I was pleased to have had old friend Chris Randall on the show. Recording today’s show was another real treat. David Campbell agreed to be on the show. Dave is another of the people that I’d consider to be real legends in the SQL Server group, having come across to Microsoft (from DEC) back in 1994. He went on to be one of the key folk involved in totally replacing the query processing engine, etc. in SQL Server … Continue reading SQL Down Under show 27 – SQL Legend – David Campbell

SQL Server 2008 Readiness Events in Australia coming up

Sharmilla Gosai and our friends at Microsoft Australia have announced SQL Server 2008 readiness events. These include jumpstart sessions specifically targets at administrators, developers and business intelligence professionals. These events offer up-to-date content at a low cost. The developer event runs for two days and is being offered in Sydney, Canberra and Melbourne. For administrators, there is a one day event. As well as Sydney, Canberra and Melbourne, it will be running in Perth, Adelaide and Brisbane. The one day BI event is running in Sydney, Canberra, Melbourne, Perth and Brisbane. You can book early at: https://partner.microsoft.com/Australia/40039523