Upgrading a database can seem frightening! Fortunately, Agile BI offers exceptional tools from Microsoft and support to help you smoothly upgrade SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on the 12th of April 2016. Find here three steps that can help make this an efficient upgrade:
First, do you know what is in your database environment?
For an efficient upgrade SQL Server 2005, it is necessary to organise everything before getting started. Step one in your planning process is to explore what is in your database environment: workloads, virtual or physical servers, what’s running on which versions and editions of software, and so on. For example, you will want to find out before upgrade SQL Server 2005 if SQL Server 2005 is running in your environment. Then, discover if any applications are running on SQL Server 2005 so you can protect critical data after the end-of-support date.
When you upgrade SQL Server 2005, Agile BI can help you running the Microsoft Assessment and Planning Toolkit, which automates the process of gathering data about your database environment. We can also help you find unidentified databases that might be impacted by end of support. Further we can also provide offerings to help you do a detailed assessment of your database environment and recommend next steps. The cooperation with the right partner can greatly reduce work and worries on an upgrade.
Second, do you target destinations for each application and workload?
One of the most important steps in upgrade SQL Server 2005 to SQL Server 2014 is the step to target destinations for each application and workload.
After collecting data about what is running in your IT environment, the next step to think about is where you will run your upgraded databases. When it comes to updating your data platform, you have a few options for where to move applications and workloads. You can
- upgrade your on-premises servers
- implement virtual machines
- or move to the cloud — a combination of three is the most common option
Microsoft published recently a guide about the SQL Server Upgrade Target Decision Tool to help you think through this process, compare your options, and identify upgrade targets based on your individual business needs.
How should I approach Consolidation and Virtualisation?
When you are upgrading it is the perfect time to look for ways to gain efficiency and manage performance — in this case consolidation and virtualisation. Have a look at the diagram which highlights how you might approach consolidating and virtualising your applications and workloads as well as taking Web applications to the cloud with Azure SQL Database.
It is possible to move certain applications and processes to upgraded on-premises servers to get the reliable performance necessary for mission-critical tasks.
If choosing to virtualise using Windows Server Hyper-V or Azure VMs, one of the great benefits of virtualisation is that you can run multiple applications or workloads on the same server while each maintains its own separate environment. Another benefit is that Azure VMs help further reduce total cost of ownership and increase availability. Because Azure VMs are hosted in the cloud, you can leverage the high availability of Microsoft’s cloud infrastructure while reducing capital expense for purchasing your own hardware and related IT costs.
Another option is to consolidate multiple databases or instances using Windows Server and Hyper-V to reduce IT sprawl, increase efficiency and free up resources for new tasks.
Moving your Web applications to the cloud and reducing administration is possible using Azure SQL Database, which is a database-as-a-service in the cloud. With this option, you get the benefits of a cloud infrastructure with enterprise-grade security and scale, high availability, superior performance and near-zero maintenance.
Are you ready for an increased ROI?
Of course you are! Check out the Microsoft Consulting study – Experience the benefits of SQL Server 2014 when migrating.
Third, have you found your upgrade strategy?
This is where an experienced and reliable Microsoft partner can help you. When upgrade SQL 2005 Agile BI can walk you through some common upgrade strategies and offer ways that you can approach the upgrade process. By planning thoughtfully, your upgrade will be less complicated, smoother and more cost-effective.
Larger upgrade projects can take six to 12 months to execute, so the time to contact Agile BI – a reliable Microsoft Gold Partner is now!
Marco Russo DAX expert: What is DAX? And why you have to know Marco Russo if you know DAX?
DAX (Data Analysis Expressions) is the native formula and query language for Microsoft Power Pivot and SQL Server Analysis Services Tabular models. Important to know is that DAX is NOT a programming language, DAX is a formula language!
DAX formulas are very similar to Excel formulas.
To create one, you type an equal sign, followed by a function name or expression, and any required values or arguments. Like Excel, DAX provides a variety of functions that you can use to work with perform calculations using dates and times, strings, or create conditional values.
Why is DAX so important?
It is not hard to create a workbook and import some data into it. You can even create PivotTables or PivotCharts that display essential information without using any DAX formulas. But, what if you need to analyse critical sales data across different product categories and for different date ranges? Or, you need combine important inventory data from several tables in different data sources? DAX formulas provide this capability and many other important capabilities as well. Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line.
This is Business Intelligence, and Marco Russo DAX expert will help you get there.
Born and based in beautiful Turin (Italy), Marco Russo and Alberto Ferrari from SQLBI published in October this year the book “The Definitive Guide to DAX – Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI”.
This guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques. Marco Russo and Alberto Ferrari use this book as companion content for their courses Mastering DAX and Optimizing DAX. This book proofs the expertise of Marco Russo and Alberto as the Number one DAX experts in the world. Agile BI proudly announces that Marco Russo will present the first time ever in Australia his Mastering DAX and Optimizing DAX Trainings in Sydney and Melbourne.
Use the chance to get in touch with the DAX star Marco Russo at a training session of your choice in Sydney or Melbourne and ask all the questions you always wanted to ask about DAX!
Agile BI is a leading Data Analytics consulting firm based in Sydney. We are a Gold Microsoft partner with fully-certified experienced people that can implement, tailor, and support Microsoft Business Intelligence products and solutions.
- Gartner positions Microsoft as a leader in BI and Analytics Platforms for ten consecutive years 16 Feb 2017
- Power BI, Flow, and PowerApps Webinars for February 23 - April 6 13 Feb 2017
- Congratulations to this month's Featured Data Stories Gallery submissions 10 Feb 2017
- Visual Awesomeness Unlocked: Dual KPI custom visual 09 Feb 2017
Get in touch
1300 441 618
(02) 8088 7440
Suite 2, Level 1, 18-20 York Street, Sydney, NSW 2000