June 21, 2016

ERP software for the food industry through new partnership with SI Foodware

Theta has recently become the SI Foodware partner for New Zealand. We can now offer our food industry customers business and financial software that’s specifically designed for them.

By

Theta

June 16, 2016

Discover advanced analytics: event in Christchurch

We're hosting a business-focused event in Christchurch this month. Come along to hear about how advanced analytics can help you transform your data into intelligent action through intuitive interactions and natural language questions.

By

Theta

June 15, 2016

SQL tip #5: Be prepared for SQL 2016

Did you know that in SQL Server 2016 you can now specify the location of the tempdb files during setup?

By

Theta

June 8, 2016

SQL tip #4: using output clause to return changed items

Did you know that you can use the output clause to return updated or inserted rows without having to select them again?

By

Theta

June 2, 2016

Introducing SQL Server 2016 – the best SQL Server yet!

SQL Server 2016 enters general release today. To mark the occasion, we asked a couple of our SQL Server experts, Head of Microsoft Solutions and Architecture Rob Hawthorne, and Senior Consultant Richard Laing, what they consider to be the highlights of the new release.

By

Theta

May 27, 2016

Taking a broader view with big data and analytics

This post is based on a presentation by Rob Hawthorne at the Customer 3.1 Conference in Auckland this week.

By

Theta

May 25, 2016

SQL tip #3: consider a table variable

Most developers know the # preceding a local temporary table very well, as temporary tables are really useful when you need to keep some stuff in a place for a moment while you do something else. But you may not know there are quite a lot of processes that go into making this table, or that these can really inhibit the reuse of execution plans. So a harmless #temp may be bloating your memory or putting extra pressure on your TempDB and you might not even know about it.

By

Theta

May 23, 2016

Understanding digital transformation

Digital transformation and “disruption” are widely discussed – often in abstract and theoretical terms. But what does digital transformation really mean for your business, and what should you be doing about it?

By

Theta

May 13, 2016

Integrate 2016 - Highlights

Integrate 2016, the main Microsoft integration conference, was held from 11-13 May in London. The event had more than 380 attendees from 22 countries, representing 187 companies, with presenters from various Microsoft product teams and from the MVP Program.

By

Theta

May 4, 2016

SQL tip #1: Store SQL DB files in Azure storage

Did you know that you can configure an Azure SQL VM (or on premise machine) to store SQL data (.mdf) and log (.ldf) files in Azure storage?

By

Theta