by Jerrad Dahlager | May 18, 2023 | Azure, Blog, Cloud, Microsoft
Microsoft Azure offers various database management options for organizations based on their specific requirements. There are three primary SQL database offerings: Azure SQL Database, Azure SQL Managed Instance, and SQL Virtual Machines (VMs). In this blog post, we...
by XTIVIA | Apr 5, 2018 | Azure, Blog
1. Sign Up for Azure Visit https://signup.azure.com and follow the steps to sign up for Azure. Requirements Microsoft Account Mobile Phone Credit Card 2. Visit the Microsoft Azure Portal Once completed with signing up head on over to the portal Visit:...
by Anosh Wadia | Jun 22, 2017 | Blog, Customer Relationship Management
As powerful as Infor CRM groups are, they, unfortunately, do not allow you to aggregate data. Your options are either to create a report, export to Excel, or create a dashboard to summarize information. However, you can summarize record level data using SQL Views in...
by XTIVIA | May 5, 2016 | Blog, Databases
Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said “What’s wrong with DB2? my query is running long! Are there lock timeouts happening?”...
by XTIVIA | Feb 5, 2015 | Blog, Data Management, Databases
DB2’s automated maintenance does not currently allow us to automate inplace reorgs. Inplace reorgs are more online than other reorgs, and in my experience are heavily used. This means that many DBAs wrap some sort of scripting around reorgs. Working in a variety...
by XTIVIA | Dec 24, 2014 | Blog, Data Management, Databases
SQL Server is indeed a powerfull database management system, however Microsoft has not yet included the run yourself feature as of yet. And it is because of this Database Administrators need a good set of tools to not only manage SQL Server but to also monitor what is...