.jpg)
.png)
.png)
.png)
& Blogs
News & Blogs
.png)
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?
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?
.png)
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.
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.
.png){kind=spacer}
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?
.png)
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.
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?
.png)
May 2, 2016
Service Scheduling with Microsoft Dynamics CRM Field Service
In this post, Theta's Head of CRM, Ivor Whibley, continues his series on Microsoft Dynamics CRM Field Service.
.png)
April 28, 2016
Marketing automation: the importance of data and process
I was recently invited to present a paper at the Marketing Automation Summit held in Auckland. This was a perfect opportunity for me to refresh myself on all the marketing automation capabilities of Microsoft Dynamics CRM. My given subject was “Tracking progress and hitting targets on time.”
April 27, 2016
SQL tip #2: Remove unnecessary SQL components from an Azure VM
Did you know that when you first request a SQL Azure VM it comes with everything installed? This includes Analysis Services, Integration Services, Reporting Services, etc, even if you don’t want to use them.