10 Misconceptions of Hiring a Virtual DBA

10 misconceptions of hiring a Virtual DBA

Leaving your mission critical databases in the hands of a third party can be daunting. With the right service provider, there’s no need to be concerned.

At WARDY IT Solutions, our objective is to allow our customers to totally forget about their SQL Server environment. We know that might sound hard to believe but after reading this post, you’ll understand why the Virtual DBA Service is different.

#1: I’ll need to sack my DBAs

#2: I can’t trust external consultants with company data and servers

trust external consultants with company data and servers

#3: My IT team won’t know what’s happening with our databases

#4: I’ll be tied into a long term contract

#5: Virtual DBAs are reactive not proactive

#6: A Virtual DBA will cost me more in the long run

#7: I’ll have to permanently upgrade my plan to cover short term work

#8: A different person will be working on my database every week

#9: I’ll lose visibility of my servers

#10: I won’t get my money’s worth

 





Learn more about our Virtual DBA service




February 2017 QLD SQL Server User Group

February 2017 QSSUG

Azure Machine Learning Test Drive

Wouldn’t it be beneficial if a hospital could identify patients who are at high risk of readmission, or predict wait times based on staff levels, patient data and emergency room size?

Machine learning tries to provide the answers. Azure Machine Learning makes it supremely easy to build machine learning experiments that train, score and evaluate ML models and publish as web service.

In this session, Ram will cover how to easily build, test and deploy machine learning models using Azure Machine Learning.

The session will be demo based and will inspire you to further extend Azure Machine Learning capabilities.

About the Presenter

Ram Katepally is a Data Analytics Consultant for WARDY IT Solutions. He is MCSE for both Data Platform & Data Analytics, with a passion for analytics and visualizations. In his free time he is a avid player of chess.

Click here to register for the February 2017 QLD SQL Server User Group

Location:

Microsoft Brisbane – Level 28, 400 George Street, Brisbane

Date & Time:

Thursday, 23rd February 2017
Catering from 5:30PM for a 6:00PM Start (meetings typically finish at 7:30PM)

Register now!

January 2017 Round Up

New Training Courses

Happy New Year to all! For those of you hoping to make 2017 the year of professional development, we have a number of new training courses to help you on your way:

There are a number of other training opportunities over the next month including SQL Saturdays in Sydney and Melbourne and Microsoft Ignite on the Gold Coast.  WARDY IT Solutions is proud to be a sponsor of these events and we look forward to meeting some of you in person at our booth.

Blog: Do I really need a SQL Server DBA?

Data has become the lifeblood of almost every organisation today and timely access to this data is key for providing insight and making business decisions. Check out our latest blog post to read our thoughts on the topic.

SQL Server Database Healthcheck

Reduce the need for expensive upgrades by optimising your existing infrastructure and identify problem areas with the SQL Server Database Healthcheck. We carry out a comprehensive examination of your SQL Server environment. Helping to reduce the business risks associated with down-time, performance bottlenecks, and the complexities of deploying and managing Microsoft SQL Server. Find out more.

SQL Server 2016 Service Pack 1

With SQL Server 2016 Service Pack 1 Microsoft made a number of key improvements including allowing a consistent programmability surface area for developers and organisations across SQL Server editions. This will enable you to build advanced applications that scale across editions and cloud as you grow. Developers and application partners can now build to a single programming surface when creating or upgrading intelligent applications, and use the edition which scales to the application’s needs.  Click here to download and find out all of the key benefits of SQL Server 2016 Service Pack 1.

Power BI Phone Reports

With Phone reports you can specifically tailor a portrait view of your existing report on Power BI Desktop for mobile viewers. With this update, everyone can create report views optimised for phones, to enhance the experience of viewing Power BI reports on phones. Learn more about authoring phone reports in Power BI Desktop and the report experience on phones.

New Microsoft Offering: SQL Server Premium Assurance

IT departments are in a fundamental state of change, with the drive for digital transformation creating many new applications and moving others to the cloud. At the same time, companies must also maintain stable and secure operation of their existing applications databases. To provide better flexibility in managing these diverse priorities, Microsoft has announced two new offerings to help run applications longer without disruption: Windows Server Premium Assurance and SQL Server Premium Assurance.

$900 Service Pack Service

Are you struggling to keep up to date with the latest SQL Server Pack?  For only $900 ex. GST WARDY IT Solutions can review a SQL Server instance, prepare an implementation plan, install the latest SQL Server service pack for your instance and provide post implementation support. To take advantage of this limited offer contact us today.

SQL Server Support: Virtual DBA

Virtual DBA is our very own award-winning remote database administration service based here in Australia. Our Microsoft certified team of DBAs watch over your databases 24x7x365, providing a cost effective solution to meet the day-to-day challenges of availability, performance and administration of SQL Server databases. Plans starting from just $1450 ex. GST per month. Find out more.

Overview of Azure Data Lake

Azure Data Lake offers a hyper-scale data repository for storing data of any type and is built to the open HDFS standard. You can store trillions of files and single files can be over a petabyte in size. Azure Data Lake makes it easy to run massively parallel data transformations and data processing programs using U-SQL, R, Python and .NET over massive datasets and all with just a few lines of code and absolutely no infrastructure to manage. Find out more about Azure Data Lake.

Do I really need a SQL Server DBA?

Do I really need a SQL Server DBA?

Data has become the lifeblood of almost every organisation today and timely access to this data is the key for providing insight and making business decisions. For many organisations data not only provides insights but is also the key to enabling business transformation. This transformation was recently summarised by Microsoft CEO Satya Nadella when he described “data as the new electricity”. Many industry analysts describe data as one of the most important assets that an organisation has and as a result appropriate management of data is paramount.

As the data for most business systems is stored in a database there is a need for a coordinated role to manage the data, this is fulfilled by a Database Administrator (DBA). Broadly the role of a DBA includes a number of functions broken down into the broad categories of capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting and data recovery. While holistically all of these are important responsibilities of a DBA, where production databases are concerned, performance and data recovery are key. These two functions alone affect overall productivity and will directly impact the businesses ability to operate.

When you first take a car out of the showroom it runs perfectly; it starts first time, there are no strange noises and none of the warning lights are on. However, over time if the car is not maintained and serviced the performance deteriorates and the reliability is significantly reduced. Similarly, without regular maintenance and ongoing tuning database systems performance will deteriorate over time. This is where an experienced DBA is key to the operation of the businesses data systems, they ensure that performance and reliability are maintained and adapt the environment to meet changing usage patterns and scalability requirements along with any other organisational requirements.

Another function of a DBA and arguably the most important is that of data recovery. All too often when organisations think about recovery they are only focused on backup strategies; however, a backup isn’t successful until you have been able to successfully restore from it, reliably and within appropriate timeframes. The DBA ensures that the businesses data recovery time and recovery point objectives are exceeded whilst optimising the total cost to the organisation to deliver the required high availability and disaster recovery solutions. In short, down time equates to lost revenue, if you need to insure your data is available in a timely manner to allow you to make informed business decisions or close transactions then you need a DBA’s expertise to design and manage your data recovery solutions

In short, if you are using any form of business system in your organisation and the data stored within that system is of value, a DBAs expertise will help you to manage the cost effectively whilst maximizing the value you can obtain from your data assets.