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

Happy Reading

Peter Ward

^top

Getting Value from SQL Server Monitoring

In this free breakfast you will see how to reduce the cost of SQL Server monitoring and support. 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. This breakfast will show how SQL Server 2008 R2 helps reduce monitoring and support costs. Register for this free breakfast here.

^top

Encrypting SSIS Configurations

There are a number of different aspects to consider when securing SSIS configurations in a SQL Server - the permissions to the configurations themselves, the bytes stored on disk and in backups, the network packets between client and server, and so on. The following blog post provides a good overview of how to implement encryption for SQL Server. This post can be found here.

^top

Cumulative update 8 for SQL Server 2008 R2

Cumulative update 8 contains a number of hotfixes for the Microsoft SQL Server 2008 R2 for issues that have been resolved since the release of SQL Server 2008 R2. This build of this cumulative update package is also known as build 10.50.1797.0. For more details and to download the cumulative update refer to here.

^top

Expert SQL Server Training

Are you looking for deep SQL Server training from experts that work day-to-day in the trenches rather than someone that just follows the bouncing-ball? Each WARDY IT Solutions SQL Server training course is delivered by a consultant that works in the field on some of the largest SQL Server sites in Australia. You can download the full WARDY IT Solutions training schedule here and book online here for these not to be missed training events.

^top

SQL Server Cost Recovery White Paper

One of the challenges facing the IT departments of many organizations today is who pays for the operational support of the SQL Server databases that are used by the business? WARDY IT Solutions has written a white paper that explores the implementation of SQL Server Cost Recovery to recover the costs associated with database management. This white paper can be downloaded here.

^top

PowerPivot Analytics for Exchange Calendars

Often you spend a lot of time in meetings and at the end of the month, it’s difficult to determine how you spent your time, and whether or not you spent it effectively. Calendar Analytics allows users to connect to their Microsoft Exchange Calendar and get a dashboard view on meeting statistics using PowerPivot. You can download the free add-in 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

SQL Server Number 2 in DBMS Revenue

In a recent Vendor Analysis Report Excerpt, leading industry analyst firm, IDC, states that Microsoft overtook IBM in RDBMS license revenue to claim the number 2 spot and that Microsoft was the only one of the top 3 vendors to show positive license revenue growth. You can access this analysis here.

^top

SQL Server 2008 R2 Analysis Services Operations Guide

The Analysis Services Operations Guide is a white paper that describes how operations teams can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. The white paper can be found 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.

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