June 30, 2016

SQL tip #6: Scripting multiple SQL objects

Sometimes we need to script multiple SQL objects, either for deployment, documentation or quick search, eg to find SSIS package name.

By

Theta

June 28, 2016

Theta at the movies: Finding Dory

It was a delight host our tenth annual family movie event earlier this month. This year we held three special preview screenings of the long anticipated sequel to Finding Nemo, Finding Dory.

By

Theta

June 28, 2016

Changes in Logic Apps: Schema Refresh 2

With general availability of Logic Apps fast approaching the product team has increased the pace of implementing new features. Another incremental update to the Logic Apps Designer brought welcome functionality changes and user interface improvements, thanks to a new version of the Logic Apps definition schema.

By

Theta

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