WARDY IT Solutions Blog

A blog on Australia's leading SQL Server consultants, trainers and Business Intelligence specialists

  • April 2012 SQL Server Newsletter

    The April edition of the WARDY IT Solutions SQL Server newsletter is now available here.

     

    This newsletter includes:

    • Learn DAX in 30 Minutes
    • xVelocity in SQL Server 2012
    • SQL Server Virtual DBA

       

    A full archive of SQL Server newsletters can be found here.

  • SQL Server 2012 Released

    Today SQL Server 2012 has been released. Microsoft has officially released to manufacturing (RTM'd) SQL Server 2012 a day before the SQL Server virtual launch.

     

    An evaluation edition of SQL Server 2012 will be available for download later today from here and general availability will begin on April 1.

     

    General availability means not only will SQL Server 2012 be available from the Volume Licencing Centre, it will also be added to the Microsoft pricelist. To avoid any price impact, purchase SQL Server 2008 R2 with Software Assurance now, or renew your existing Software Assurance plan. By doing so, you will lock in the price of your SQL Server purchase and gain the usage rights to SQL Server 2012! To learn more about the latest licensing and price changes refer to here or contact WARDY IT Solutions today.

     

    If you are looking to get up to speed with this next release of SQL Server, SQL Server 2012 then look no further than WARDY IT Solutions.

  • SQLSaturday Downunder

    PASS SQLSaturday's are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions. For the first time SQLSaturtuday will be held downunder in the following cities Brisbane, Wellington, Canberra, Sydney, Adelaide and Perth. The first event kicks off in Brisbane on the 12th of April.

    For more information and to register for these free SQL Server events refer to here.

    WARDY IT Solutions is proud to be a Gold Sponsor at each of the SQLSaturday events downunder.

  • Virtual DBA Service Provides Immediate Value to Enterprises

    A recent Longhaus study on CIO Confidence found that in the minds of Australian CIOs, DBAs are doing such a good job that there is no need to change the resource structures, with 'if it ain't broke don't fix it' being an appropriate attitude.

     

    However, the growing challenge of using big data within the enterprise is highlighting that traditional approaches to data management are not adjusting well to the increased demand. In the race to adequately scale, CIOs are now turning to new –as-a-service providers in the market.

     

    DBA-as-a-Service Is Growing

    The Longhaus Study found that there is immediate value to enterprises in engaging DBA services, such as the Virtual DBA Service provided by WARDY IT Solutions.

     

    Longhaus estimated that 20% of CIOs are looking towards –as-a-service providers to complement their existing internal DBA resources. Additionally Longhaus found that an attitude of increasing DBA resourcing via recruitment was NOT the right way to go.

     

    Longhaus concluded:

    "Whether the requirement is for traditional hosting of a trusted database infrastructure instance for a proposed SQL Server upgrade, or the broader consideration for -as-a-service database management for extensive SQL environments such as those provided by Australia's WARDY IT Solutions, direct increases to DBA resourcing through recruitment will only represent a very clear step in the wrong direction." – Longhaus study: DBA Roles are the Safest but most Ignored by the CIO.

     

    WARDY IT Solutions Virtual DBA

    The Virtual DBA service from WARDY IT allows clients to lower costs in terms of IT professional staff by allowing remote administration of their SQL Server databases.

    Rather than having to train in-house IT staff to run company databases, Virtual DBA allows a team of seasoned database specialists to handle all SQL Server administration tasks.

    Enterprises around the globe use Virtual DBA with the service monitoring more than 30,000 databases. The service includes 24x7 support as well a Windows Phone App and an iPhone and iPad App.

     

    Sources:

    [1] http://www.longhaus.com/research/research.html

     

  • February 2012 SQL Server Newsletter

    The February edition of the WARDY IT Solutions SQL Server newsletter is now available here.

     

    This newsletter includes:

     

    A full archive of SQL Server newsletters can be found here.

  • January 2012 SQL Server Newsletter

    The January edition of the WARDY IT Solutions SQL Server newsletter is now available here.

     

    This newsletter includes:

     

    A full archive of SQL Server newsletters can be found here.

  • SQL Server 2012 Always On Workshop

    Organisations are continually looking at how they meet the increasing needs of uptime and data availability. Microsoft SQL Server 2012 provides a set of features and capabilities that enable businesses to achieve the highest level of availability and data protection without the cost and complexity. In this one-day hands-on workshop from WARDY IT Solutions you will learn to install and configure SQL Server 2012 on Server Core and take advantage of the new Always On features to deliver high 9's of availability.

     

    The Server Core installation option for the Windows Server 2008 R2 operating system provides a minimal environment for running specific server roles. For the first time with the introduction of SQL Server 2012, SQL Server can be installed on Server Core. This helps to reduce maintenance and management requirements and the attack surface.

     

    SQL Server Always On is a new flexible high availability and disaster recovery solution that provides redundancy within a datacenter and across datacenters, enabling fast application failover. AlwaysOn supports configuring availability at both the database and instance level and enables the reuse of existing hardware investments.

     

    Places on this exclusive hands-on workshop are limited to only 6 people.

     

    When Tuesday 13th March 2011, 9:00am - 4:30pm

    Where WARDY IT Solutions Brisbane CBD Training facilities

    Cost ONLY $600.00 ex. GST

    This cost includes lunch, morning and afternoon tea as well as course resources that you can take back to the office.

     

    Register here for this exclusive course.

  • New Year’s Resolutions

    Happy New Years and best of wishes for 2012!

     

    For many people this time of the year is an opportunity to reflect on the year that was and make plans for the year ahead. This planning often results in creating a number of personal goals and New Year's Resolutions.

     

    So if one of your New Year's Resolutions is to help your career development with SQL Server Training then make sure you check out all the WARDY IT Solutions SQL Server training on offer from Microsoft Official Curriculum to Custom SQL Server Training.

  • SQL Server 2012 Microsoft Official Curriculum

    SQL Server 2012 is coming! Microsoft Learning has already started developing some of the exams, courses, and books that will help you learn SQL Server 2012.

     

    We are pleased to say that WARDY IT Solutions has been commissioned by Microsoft Learning to assist in the development of learning resources and the exams. Here's a preview of some of the SQL 2012 courses under development.

     

    The Quick View

    Title

    Course

    Exam

    Querying Microsoft SQL Server 2012

    10774

    70-461

    Administering Microsoft SQL Server 2012 Databases

    10775

    70-462

    Implementing a Data Warehouse with Microsoft SQL Server 2012

    10777

    70-463

    Developing Microsoft SQL Server 2012 Databases

    10776

    7-464

    Designing Database Solutions for SQL Server 2012

    TBD

    70-465

    Implementing Data Models and Reports with Microsoft SQL Server 2012

    10778

    70-466

    Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Platform

    TBD

    70-467

     

     

    What's changed with SQL 2012 courses?

    • 1:1 mapping between exam, course, and book (no more two-course mapping!)
    • An exam preparation book for each exam
    • More real-world scenarios and business context

       

    What's different about the exams and certifications this time?

    • More community involvement in identifying the skills to be tested (over 300 people participated!)
    • Higher expectations of skill level and experience for the successful candidate
    • More direct focus on core skills such as querying and on business context
    • Recertification required every three years at the Pro level

       

    Recertification

    Microsoft has made the decision that to ensure that the certifications remain a meaningful and valuable indicator of candidate's skills. SQL Server 2012 Professional-level certifications will require recertification every three years. Initially, the recertification requirement will be one or two exams.

     

    If you'd like to no more about SQL Server 2012 Microsoft Official Curriculum then contact WARDY IT Solutions.

  • November 2011 SQL Server Newsletter

    The November edition of the WARDY IT Solutions SQL Server newsletter is now available here.

     

    This newsletter includes:

     

    A full archive of SQL Server newsletters can be found here.

  • Virtual DBA iPhone & iPad Application

    WARDY IT Solutions is proud to announce the release of the Virtual DBA application for the iPhone and iPad. This mobile interface provides you the freedom to easily see the status of your SQL Server topology at any time beyond the limits of your desktop.

     

    The Virtual DBA service provides a cost effective solution to meet the day-to-day challenges of monitoring, availability, performance and administration of your organisation's critical Microsoft SQL Server databases.

     

    The innovations with the Virtual DBA iPhone and iPad application are just another reason that WARDY IT Solutions Virtual DBA service has received so many industry accolades and awards. These awards include the Virtual DBA service being named one of Australia's 100 most innovative products by Anthill Magazine and a finalist in the Best Vendor Tech Support in the 2011 SQL Server Magazine Community Choice Awards.

     

    The iPhone and iPad application is a complimentary value-add that is part of the Virtual DBA service.

     

    You can install the Virtual DBA application by searching for WARDY IT Solutions in the Apple App Store.  Alternatively you can access the application using the following URL -http://itunes.apple.com/en/app/id445590067.

     

    To find out more about how the Virtual DBA service can assist with the management of your SQL Server topology, why not contact the largest and most awarded SQL Server specialists in Australia, WARDY IT Solutions.

  • SQL Server 2012 Licensing Changes

    Today Microsoft announced the changes in licensing that will be introduced in the next release of SQL Server, SQL Server 2012. SQL Server 2012 was previously code-named 'Denali' and is scheduled for release in the first half of 2012.

     

    These licensing changes include simplifying the number of different Editions by eliminating the following SKU's:

    • Datacenter – These features will now be available in Enterprise Edition
    • Workgroup – Standard Edition will replace Workgroup Edition
    • Standard for Small Business – Standard Edition will replace this

     

    The licensing changes also see the introduction of a Business Intelligence SKU which is a brand new SKU that is being introduced for the first time in SQL Server 2012. The Business Intelligence SKU provides all of the SQL Server 2012 Standard Edition functionality and also includes Power View (code-named "Crescent"), reporting and analytics, data-quality services and master-data services. A full breakdown of functionality by each SQL Server 2012 Edition can be found here.

     

    With SQL Server 2012, Microsoft will offer three licensing options:

    • Core-based Licensing for Enterprise Edition
    • Server + CAL (Client Access License) licensing for Business Intelligence Edition
    • A Choice of core-based licensing or Server + CAL licensing for Standard Edition

    Details of the costs of each these licensing options in $USD can be found in the SQL Server 2012 licensing datasheet.

     

    Detailed answers to many common questions about the SQL Server 2012 licensing can be found in the Frequently Asked Questions about SQL Server 2012 Editions and Licensing

     

    To help you understand these licensing changes and what they mean for your organisation WARDY IT Solutions has designed a licensing review specifically for SQL Server 2012.

  • October 2011 SQL Server Newsletter

    The October edition of the WARDY IT Solutions SQL Server newsletter is now available here.

     

    This newsletter includes:

    Maximizing Throughput with RSS Tuning

    Analysis Services 2008 R2 Performance Guide

    Microsoft Software Assurance Training Vouchers (SATV)

    Kalen Delaney SQL Server Training in Australia

     

    A full archive of SQL Server newsletters can be found here.

  • SQL Server 2012 Training

    The name for the next release of SQL Server was announced yesterday at the SQL PASS conference as SQL Server 2012. Previously the next release of SQL Server had the codename "Denali".

     

    WARDY IT Solutions has been developing training for SQL Server 2012 over the past few months and we are proud today to announce the first SQL Server 2012 training in Australia.

     

    Today marks the release of our SQL Server 2012 First look course. This one-day instructor-led training course provides participants a hands-on opportunity to see how SQL Server 2012 will assist organizations to manage mission-critical workloads and provide rich reporting and analytical solutions. The course is running in Sydney and Brisbane on the following dates for the special price of only $199.00 ex. GST:

    Sydney – 17th November

    Brisbane – 18th November

    You can register for the SQL Server 2012 First look course here.

     

    WARDY IT Solutions is also currently developing the following training courses for SQL Server 2012 that will be available soon:

    • Reporting with Power View (Project Crescent)
    • Data Quality and Master Data Services
  • Getting Value from SQL Server Monitoring

    The core role of a Database Administrator is protecting the data assets of an organisation. However today's DBA is juggling many different roles and responsibilities; from day-to-day operational support through to project delivery. As a result of these conflicting priorities, essential database monitoring is often overlooked. WARDY IT Solutions has recently recorded a presentation that shows how you can get more value from SQL Server Monitoring. In this presentation you will see how the performance monitoring features in Microsoft SQL Server 2008 R2 can assist to ensure the availability and reliability of your SQL Server topology.

     

    Getting Value from SQL Server Monitoring - Part 1

    Getting Value from SQL Server Monitoring - Part 2

    Getting Value from SQL Server Monitoring - Part 3

    Getting Value from SQL Server Monitoring - Part 4

    Getting Value from SQL Server Monitoring - Part 5

More Posts Next page »