Dynamics GP Database Specialist in Southbank, Victoria, Australia | Local service

Dynamics GP Database Specialist

Locality: Southbank, Victoria, Australia

Phone: +61 408 571 941

Add/Update information

Reviews

Tags

• Local service

25.01.2022 As an IT system enabler, I have only one thing to say, "be specific and we'll deliver." 100%. #perceptions #reality

24.01.2022 When we talk about business intelligence and data visualization, Power BI and Tableau are the best tools in the market today. It is always a crucial battle for data analyst to choose the most suitable one for their data. Well, both has their own strengths. I look at Power BI for small businesses, mainly due to its cost and the fact that they normally has relatively small size of dataset. It is quite cheaper and provide all the necessary features to fulfill the small and mediu...m business needs. (Below is the screenshot of #PowerBI I build it from scratch combining two data sources, Excel and Web, in less than 15 minutes. You see how fast you can build interactive data visualization for your decision makers). On the other hand, if your business is large enough then you should consider Tableau. Because it is the most powerful data visualization tool that can work at any scale of business. I'll present Tableau in my next post. See more

15.01.2022 The evolution of business intelligence (BI) technology is enabling richer and more exciting visualisation of data easily. When I started embracing BI about 10 years ago, there was a lack of BI front-end tools. We built dashboard in a hard way, manually developed it using .Net, SSRS and Sharepoint. It took weeks and months. #Tableau was already around since 2004, but as it is a non-Microsoft product, my organisation didn't want me to touch it. Note that there was no Power BI a...t that time. Tableau allows you to build interactive, exploratory and visual dashboard quick and easy. I use the same global coffee roaster data to build a dashboard in minutes. So cool, making data discovery a breeze. You see in the video, it makes you to ask. The upsurge in the chart makes you want to discover what contributes to the peak. Click the peak and it becomes your filter, and all other measures in the dashboard responses. Having said this, think long-range even when you are building a quick dashboard. You can do a lot with custom calculations, filtering and custom SQL in Tableau but the question is, should you? Instead, do the complicated calculations in the backend database whenever possible. We have invested lots of work to come up with validated, well-thought calculated fields and user-friendly field names source data in our #datawarehouse. Leverage this, instead of circumvent all these works by dumping data into and transforming it yourself in Tableau. You dont want to turn up at meetings and your numbers don’t match up, do you?

13.01.2022 As small and medium businesses, you may not have a failover in place. So what if your database server crashes? The backups your databases is crucial, but when things really go wrong, you can call us for the rescue. Within your disaster recovery SLA, we'll take care of your SQL Server installation, restore data up to the last minute, logins, Clients connections, integrating applications, automations, reportings, etc #DynamicsGpDisasterRecovery

03.01.2022 Database mirroring is a solution for increasing the availability of a SQL Server database. It may be as part of your Disaster Recovery plan. While setting up SQL Mirroring, at the end of the process as we start mirroring we may receive the following: "The server network address TCP://SQLServer:5023 cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.... (Microsoft SQL Server, Error: 1418)" Do not worry, verify the following: 1: Make sure that on Mirror Server the database is restored with NO RECOVERY option. 2: Make sure that from Principal the latest LOG backup is restored to mirror server. (Full backup restore won’t be good enough). 3: Check if you can telnet to your ports using command 4: Make sure your firewall is turned off. 5: Make sure the service accounts for Principal, Mirror, (and Witness) are in the respective instances. 6: Delete the end points especially on the Witness server, and recreate them.