Loads of SQL Server tips as well as all the latest SQL Server news brought to you by Australia's Leading SQL Server Consultants and Trainers
WARDY IT Solutions
Newsletter Issue #50
WARDY IT Solutions
In this issue:

SQL Server Training Schedule SQL Server Training Schedule
High Availability using Database Mirroring High Availability using Database Mirroring
Free SQL Server 2008 R2 eBook Free SQL Server 2008 R2 eBook
SharePoint Workflow Integration with MDS SharePoint Workflow Integration with MDS
PowerPivot Planning and Deployment PowerPivot Planning and Deployment
Parallel Data Warehouse Load 14 Million rows per Seconds
SQL Server Healthcheck SQL Server Healthcheck
SQL Server 2008 R2 Express Size Limit SQL Server 2008 R2 Express Size Limit
SQL Server 2000 to 2008 Upgrade Whitepaper Agent Alerts Management Pack
SQL Server Virtual DBA SQL Server Virtual DBA

WARDY IT Solutions

Did you know?

WARDY IT Solutions was a finalist for the QLD ACS awards for Service Delivery and Training two year in a row


WARDY IT Solutions Virtual DBA manages some of the largest mission critical SQL Server sites in Australia

 

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

 

Well what more is there to say - SQL Server 2008 R2 has been released and is available for download.

 

Many people have looked at SQL Server 2008 R2 as simply a Service Pack for SQL Server 2008, however having worked with it in production environments for over 6 months, I can safely say that 2008 R2 is certainly a release in its own right. SQL Server 2008 R2 includes a number of exciting enhancements and new capabilities including Application and Multi-Server Management and StreamInsight.

 

Microsoft is launching SQL Server R2 worldwide on May 12th and for those who aren’t able to attend the worldwide SQL Server 2008 R2 launch you, can view the SQL Server 2008 R2 Digital Tour at www.sqlserverlaunch.com. Microsoft SQL Server 2008 R2 is now available for MSDN and TechNet subscribers.

 

To take advantage of our proven experience in delivering solutions based on Microsoft SQL Server 2008 R2 and help your organisation with the upgrade path then call 1300 WARDY IT (927 394) today.

 

Happy Reading

Peter Ward

^top

SQL Server Training Schedule

It is not too late to register for our Q2 training courses, including Australia’s first PowerPivot training courses. WARDY IT Solutions has developed the following exclusive SQL Server courses including the first PowerPivot training course to be delivered in Australia:

For more details and to register for these courses email contact@wardyit.com.

^top

High Availability using Database Mirroring

High availability continues to be a very important subject for many organisations. Microsoft has recently released a white paper that describes how to use database mirroring to increase the availability of a transactional replication environment. To download this white paper refer to here.

^top

Free SQL Server 2008 R2 eBook

If you are unable to attend one of our upcoming SQL Server training courses then the next best way to learn what is new in SQL Server 2008 R2 is a new free eBook. In this book you will find that there are a lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2 that will have a positive impact on your applications, ranging from improvements in operation to those in management. To download this eBook refer to here.

^top

SharePoint Workflow Integration with MDS

Master Data Services (MDS) has been introduced with SQL Server 2008 R2 to assist organisations to centrally manage data assets. MDS also provides a workflow engine, however if your workflow requires more complex event processing, such as multi-tiered approvals or complex decision trees, you can configure Master Data Services to start a SharePoint workflow. To find out more about this integration refer to here.

^top

PowerPivot Planning and Deployment

PowerPivot is an innovative data analysis technology that redefines how organizations of all kinds deliver and succeed with business intelligence. Like any new technology, planning and coordination is required to ensure the overall success of the deployment efforts. To find out more about PowerPivot you can attend Australia's first PowerPivot training or download the white paper which is available here.

^top

Load 14 Million rows per Seconds

Unisys is the first in the market to offer a pre-packaged SQL Server optimized solution based on SQL Server 2008 R2. In fact the SQL Server Powerrack is the first high-end SQL Server solution completely based on SSD. To find out more on the Powerrack refer to 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 2008 R2 Express Size Limit

The database size limit for SQL Server 2008 R2 Express has been increased to 10GB. To download this new release of the free version of SQL Server refer to here.

^top

Agent Alerts Management Pack

SQL Server writes messages to the EventLog when various events occur in the database engine. The Agent Alerts Management Pack is designed to assist in simplifying the monitoring of these notifications. To download the pack refer to here.

^top

SQL Server Virtual DBA

For the second year running our Virtual DBA was a finalist in the QLD Australian Computer Society Awards QLD ICT Awards for Service Delivery and Training.

 

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 service 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 is a Microsoft Gold Certified Partner
WARDY IT Solutions is the APC 2009 Microsoft Data Management Partner of the Year
WARDY IT Solutions
WARDY IT Solutions