BLOG

See what we are up to

Three skills to look for in a technology partner

SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you to set up SQL Treeo? When I talked to key decision makers - CEOs, finance directors and IT managers – about monitoring and optimising their SQL Servers, I kept hearing the sam

Read more

Finding Unused Indexes

Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not difficult to find them or defining the criteria for dropping them. Here is how you retrieve them: -- Find Unused Index Script -- Original Author: Pinal Dave (C) 2011 SEL

Read more

Finding Missing indexes

Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV's select 'CREATE INDEX idx_DBO_'+REPLACE(REPLACE(REPLACE(statement,'[',''),']',''),'.','_')+CONVERT(VARCHAR,t1.index_handle)+'E ON '+statement+'('+equality_columns+') '+ CASE W

Read more

C# - Read emails from exchange online mailbox (Office 365) into SQL Server

Situation You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer. Requirements Office365 mailbox SQLServer Exchange WebServices C# (visual studio) Exchange WebServices Applies to: EWS Managed API | Exchange Online | Exchange Server 2013 | Office 3

Read more