Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Australia's leading SQL Server consultants, trainers and Business Intelligence specialists

 

  

WARDY IT Solutions
Newsletter Issue #63
WARDY IT Solutions
In this issue:

Maximizing Throughput with RSS Tuning Maximizing Throughput with RSS Tuning
Analysis Services 2008 R2 Performance Guide Analysis Services 2008 R2 Performance Guide
Microsoft Software Assurance Training Vouchers (SATV) Microsoft Software Assurance Training Vouchers (SATV)
Microsoft Business Intelligence 2010 Stack Microsoft Business Intelligence 2010 Stack
Excel Services Data Refresh Flowchart Excel Services Data Refresh Flowchart
SQL Server 2008 Service Pack 3 SQL Server 2008 Service Pack 3
SQL Server Healthcheck SQL Server Healthcheck
Database Consolidation Appliance Database Consolidation Appliance
SQL Server MVP Deep Dives Volume 2 SQL Server MVP Deep Dives Volume 2
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions has more SQL Server Microsoft Certified Trainers than any other organisation in Australia


WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services

 

WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009

Welcome to the October newsletter from Australia's leading SQL Server Consultants, Trainers and Business Intelligence specialists

 

SQL Server 2012 is the next release of the Microsoft SQL Server data platform scheduled to be released in the first half of next year. This release was previously code-named SQL Server Denali. The name and release timeframes for the next release of SQL Server were announced by Microsoft Corporate Vice President Ted Kumert at the recent PASS Summit in Seattle.

 

Apart from the name and release schedule for the next release of SQL Server, a number of other announcements were made at the PASS Summit including SQL Server’s Big Data strategy and the naming of Power View (code-named Crescent) as well as the introduction of a new product code-named Data Explorer. A full wrap-up of all the keynotes from the summit can be found here.

 

The SQL PASS Summit is becoming the must-attend SQL Server conference, however if you are looking for SQL Server training from experts a little closer to home then make sure you register for Kalen Delaney's SQL Server internals course in Brisbane and Sydney. The super early-bird special for this course is available until the 31st of October so make sure you avoid disappointment by booking today.

 

Book Kalen Delaney’s SQL Server internals training

 

Not to be out down with the announcements for SQL Server 2012, WARDY IT Solutions is proud to announce that we are on Deloitte Australia’s Technology Fast 50 winners list for 2011. This is just another testament to WARDY IT Solutions being Australia's leading SQL Server consultants, trainers and Business Intelligence specialists.

 

WARDY IT Solutions is also proud to announce that we have developed and will be delivering the first Microsoft SQL Server 2012 training in Australia. This training is just another example of how WARDY IT Solutions is enabling customers to take advantage of the leading capabilities of Microsoft SQL Server.

 

Next time you need assistance with SQL Server make sure your choice is the largest and most awarded SQL Server specialists in Australia, WARDY IT Solutions.

 

You can keep updated on all the latest WARDY IT Solutions SQL Server news on Facebook & Twitter:

 

 

Happy Reading

Peter Ward

 

^top

Maximizing Throughput with RSS Tuning

Receive-Side Scaling (RSS) was first introduced in Windows Server 2003 to improve the scalability to handle heavy network traffic found in SQL Server OLTP workloads. A new SQLCAT blog describes a set of RSS tuning rules to configure SQL Server to handle high network traffic. This blog post can be found here.

^top

Analysis Services 2008 R2 Performance Guide

A new performance guide white paper has been released for Analysis Services. This guide contains information about building and tuning Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. The performance guide can be downloaded from here.

^top

Microsoft Software Assurance Training Vouchers (SATV)

As a Microsoft Volume Licencing customer, you may be eligible for Microsoft Software Assurance Training Vouchers which are redeemable towards the majority of Microsoft Official Curriculum instructor-led technical classroom training. These courses are designed to help IT professionals and developers working with SQL Server deploy, manage and support an organisations database topology. WARDY IT Solutions are able to accept your SATV's for Microsoft Official Curriculum courses.

^top

Microsoft Business Intelligence 2010 Stack

Are you looking for deep SQL Server Business Intelligence training from experts that work day-to-day in the trenches rather than someone that just follows the bouncing-ball? WARDY IT Solutions Microsoft Business Intelligence 2010 Stack is intended for DBAs, Developers and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment or having a desire to view the new features in the entire stack. To find out more and to register on this course refer to here.

^top

Excel Services Data Refresh Flowchart

A new flowchart has been released for Excel Services that shows the sequence of actions performed by Excel Services when it refreshes data in a data-connected Microsoft Excel workbook that is being rendered by Excel Services. The flowchart also includes the connection errors that can occur at each step, and it suggests configuration steps to avoid or correct the errors. This flowchart can be downloaded from here.

^top

SQL Server 2008 Service Pack 3

The latest Service Pack, Service Pack 3 has just been released for SQL Server 2008. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. You can find out more information about this Service Pack here.

^top

SQL Server Healthcheck

Does your SQL Server environment need a Healthcheck? The WARDY IT Solutions SQL Server Healthcheck is designed to review and verify the implementation of common SQL Server Best Practices. Our Database Healthcheck includes all the usage and administration aspects of a SQL Server database, ensuring that your SQL Servers are managed and operated well. Our approach is to analyse the total health of your SQL Server environment and highlight areas of concern, providing recommendations to improve the health and performance of your database environment. For more details on our SQL Server Healthcheck refer here.

^top

Database Consolidation Appliance

Microsoft recently announced the release of a database consolidation appliance for SQL Server. This consolidation appliance follows on from the existing business intelligence appliances and provides out-of-the-box virtualized database consolidation. The appliance is designed to allow you to consolidate and manages thousands of databases and provides private cloud infrastructure that integrates hardware, software and support. To find out more about the database consolidation appliance for SQL Server refer to here.

^top

SQL Server MVP Deep Dives Volume 2

Individually, each SQL Server MVP possesses an impressive wealth of knowledge and skill. Collectively, the 63 MVPs who contributed to SQL Server MVP Deep Dives, Volume 2 represent over 1000 years of daily experience in SQL Server administration, development, training, and design. This incredible book captures this expertise and passion in a collection of sixty concise chapters. All profits for this book go to Operation Smile. So not only is the SQL Server MVP Deep Dives a great technical reference it is also helping to make a difference. You can pre-order your copy of the SQL Server MVP Deep Dives here.

^top

SQL Server Virtual DBA

WARDY IT Solutions Virtual DBA service was named one of Australia's 100 most innovative products or services, in one of the largest and most audacious innovation awards of its kind in Australia - the Anthill Magazine 'SMART 100' Index.

 

Virtual DBA is a remote database administration service designed by WARDY IT Solutions to assist organisations with the management of Microsoft SQL Server. Our Virtual DBA service provides a cost effective solution to meet the day-to-day challenges of availability, performance and administration of Microsoft SQL Server databases. To find out more about the benefits of a Virtual DBA refer to here.

 

Something you may not know is that our Virtual DBA can be utilised for phone and email support. So, if your organisation just needs someone that they can call on for advice then why not use a Virtual DBA?

^top

WARDY IT Solutions has a Gold Competency in both the Business Intelligence and Data Platform compentencies
WARDY IT Solutions has been the MAPA Data Management Partner of the Year since 2009
WARDY IT Solutions
WARDY IT Solutions