WARDY IT Solutions - SQL Server Blog

  • WARDY IT is now a Gold Microsoft Partner

    WARDY IT Solutions has continued to demonstrate its experience with the Microsoft data platform and has been awarded as a Microsoft Gold Certified Partner. Gold Certified Partners represent the highest level of competence and expertise with Microsoft technologies, and have the closest working relationship with Microsoft.

  • We are getting close

    The release of SQL Server 2008 is getting very close. At the Microsoft Worldwide Partner Conference it was announced that SQL Server 2008 will be available on the price list for partners and customers. Full details of the Press Release can be found here.

  • Last Monday’s Date

    Often when reporting there is a need to determine what Monday's date was for the previous week. For example give me all sales from Monday to Sunday for last week. The following Reporting Services snippet will calculate what last Monday's date was:

    DateAdd("d", -6,DateAdd("d", 1 - Weekday(Today), Today)

  • July 08 WARDY IT Community Dinner

    After missing a month due to Tech-Ed US the WARDY IT Community is back for the new financial year.

     

    The WARDY IT Community Dinner is typically held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland. This month the WARDY IT Community Dinner is being held at Zenbar in the City on Monday the 14th of July. To RSVP to be at this event send an email to peter @ wardyit.com.

     

    WHERE Zenbar | Park Level | Post Office Square | 215 Adelaide Street | http://www.zenbar.com.au/contactzen.htm

    WHEN Monday 14th July | 6:30PM

    RSVP Friday 11th July

     

    Add this event to your Outlook Calendar

     

    Please note that you are responsible for the cost of your own dining.

  • SQL Server 2008 RC0 Released

    The much anticipated release of SQL Server 2008 Release Candidate 0 has been made just in time to be announced at the IT Professional week at Tech-Ed US. Andrew Fryer announced in this blog post that RC0 is available for download for MSDN and TechNet subscribers. Release Candidate 0 is the final step before SQL Server 2008 is released later this year.

  • May 08 WARDY IT Community Dinner

    The WARDY IT Community Dinner is typically held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland. This month the WARDY IT Community Dinner is being held at La Dolce Vita at Milton on Monday the 12th of May. To RSVP to be at this event send an email to peter @ wardyit.com.

     

    WHERE La Dolce Vita | Shop 13 & 14 | 20 Park Road | Milton

    WHEN Monday 12th May | 6:30PM

    RSVP Friday 9th May

     

    Please note that you are responsible for the cost of your own dining.

  • Peter Ward re-awarded as MVP

    I have been rewarded for the second year as a Microsoft Most Valued Professional (MVP) for Windows Server System - SQL Server.

    Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the world who are awarded for voluntarily sharing their high quality, real world expertise in offline and online technical communities. Microsoft MVPs are a highly select group of experts that represents the technical community's best and brightest, and they share a deep commitment to community and a willingness to help others.

    For more details regarding this award refer to http://mvp.support.microsoft.com/

  • Code Camp Oz 2008

    Jeff Wharton will be presenting a session on SQL Server CE for developers at Code Camp Oz 2008.

    Code Camp Oz is a free .Net community event that is held at Charles Sturt University in Wagga Wagga (NSW) over the Anzac Day long weekend in April. For more details refer to http://www.codecampoz.com/.

  • Presenting at Tech-Ed US

    Not only is Jeff Wharton presenting at Microsoft Tech·Ed North America 2008 IT Professionals, but I am also. I will be presenting the session Using Server Management Objects to Manage Microsoft SQL Server.

  • Wellington SQL Server User Group

    I will be presenting at the Wellington SQL Server User Group in New Zealand on Thursday the 13th of March. In this session I will be presenting on SQL Server indexing and the new features in SQL Server 2008. For more details regarding this presentation refer to http://dot.net.nz/Default.aspx?tabid=101.

  • February 08 SQL Server Newsletter

    The February 2008 edition of the WARDY IT Solutions SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/feb2008.htm.

  • Why I like Vista

    As I travel around a lot of people see me running Windows Vista and are surprised. Often the comment is something like 'How can you run Vista and still be productive?'. I am the first to admit that there were challenges to start with. However these challenges had more to do with change than anything else. The fact of the matter was I knew XP inside out and Vista was different, so all of a sudden someone moved my cheese and I had no idea how to configure my network settings let alone configure Reporting Services to run on Vista. That's not to say that I haven't had some pain adapting to the change, as I remember one night before a presentation I was about to throw my laptop out the window as I was having all sorts of difficulty ensuring that a Reporting Services demo would work.

     

    Recently the lease on my Subaru Forester came up and I leased another Forester. I was always particularly fond of having the volume control on the right hand side of the radio as it was within easy reach when my favourite song came on. However the new Forester has the volume on the left hand side of the radio which is not quite as convenient, meaning I sometimes miss the first few lines of a song being at volume 10. So am I going to downgrade my new car just because the volume is in a different spot – of course not. Instead I found out that there is a volume button on my steering wheel which is actually a better option than before, however I just need to get used to reaching for the steering wheel instead of the radio.

     

    The more and more I use Vista, the more of these little features that I find. I have often used Norton Ghost and more recently Drive Snapshot to back up my laptop's. I have used these programs as they provide the ability for me to mount the backup as a drive which I can then copy a file from when needed. Over the weekend I decided to re-build my main laptop and decided to give the backup in Windows Vista a shot. To my surprise when I created a full backup the backup was a VHD. Meaning I could simply copy the file to any machine and fire up Virtual PC and use it as though I was sitting on my laptop. I even have the option of using Vhdmount in Virtual Server to mount the VHD as a drive.

     

    So just because the volume control has moved it doesn't mean that you should start looking for a new car.

  • March 08 WARDY IT Community Dinner

    The WARDY IT Community Dinner is typically held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland. Due to popular demand we are finally heading to a Mexican restaurant. So this month the WARDY IT Community Dinner is being held at Montezuma's at New Farm on Monday the 10th of March. To RSVP to be at this event send an email to peter @ wardyit.com.

    WHERE Montezuma's | Shop4, 455 Brunswick Street | New Farm

    WHEN Monday 10th March | 6:30PM

    RSVP Friday 7th March

    Please note that you are responsible for the cost of your own dining.

    Add this event to your Outlook Calendar

  • Jeff Wharton - Speaker Extraordinaire

    Winning Speaker Idol 2007 at Tech-Ed Barcelona was not enough for Jeff Wharton. Not only will Jeff be presenting at Tech-Ed Europe 2008, he has just received notification that he will be presenting at Tech-Ed US 2008 in Orlando.

  • The Week of Releases

    Over the last week there have been two significant rereleases for SQL Server. The first in the long anticipated release of the February Community Technology Preview for SQL server 2008 (aka CTP6) which can be downloaded from here. The second is Cumulative update package 6 for SQL Server 2005 Service Pack 2. For details about the issues resolved in this update package refer to here.

More Posts Next page »