Meet Lisa; she’s a marketing manager with an international travel company. She recently bought a new handbag online. She’d spotted her favorite brand, in the right color and at a price she could afford. Unfortunately, within a few days the bag broke. Disappointed – and prepared for a bit of… Read more

SQLTreeo Add-In   plugin for SQL Server Management Studio   Version Applies to SQLTreeo Add-In version 0.8.7 or higher.     Purpose Informational guide on how to use the SQLTreeo Add-In.     Functionalities   SQLTreeo Add-in allows users to create customized folders in the object tree of SQL Server… Read more

SQLTreeo Add-In   Plugin for SQL Server Management Studio   Version Applies to SQLTreeo Add-In version 0.8.7 or higher.   Purpose Informational guide on how to use the SQLTreeo Add-In.   Reading time +/- 10 minutes   Functionalities   SQLTreeo Add-in allows users to create customized folders in the object… Read more

Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your sector. That might be helping to cure a disease or making a building more energy efficient. Perhaps more annoyingly, data is also responsible for those targeted ads you keep getting… Read more

We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit from the convenience of booking holidays and paying bills online. But, while convenient, those digital experiences can also cause major headaches. As consumers increasingly rely on the internet, so they… Read more

Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If not, what’s the answer? Work more hours or work smarter? We prefer the second option. Automating as much as possible reduces the number of decisions and tasks you have to… Read more

In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment. Here are five top trends we think will drive business activity in 2019. 1. Security will continue to be your biggest… Read more

It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when we launched what became SQLTreeo, although some of the team had been working with databases for years before that. Yet, we’re… Read more

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year for them. They’re the ones running around making sure all the systems for profit and non-profit organizations are running smoothly. While… Read more

“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other similar UX advice, before. We are passionate believers in the idea that technology should help people solve their problems – but the focus should be on the customer not the… Read more

Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps us provide outstanding service to our customers, identify potential new clients, generate sales leads, track competitors, improve business processes and so much more. You would think that protecting and optimizing… Read more

How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When moving home? Almost certainly. But what about in business? Do you ever feel that an extra pair of hands would help you get through your list of database projects? Or… Read more

“We don’t want to know that it’s broken, just that it’s working.” “We want our database to always be available.” These are the types of comments we hear from business leaders all the time. And, we agree. You have a business to run, customers to serve and people to manage,… Read more

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… Read more

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: [crayon-5c511003ea174228722918/] The WHERE clause contains a filter that only shows the indexes… Read more

Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/] The WHERE clause contains a filter that only shows the missing indexes for the current databases and only for indexes that are missing for more then 10 times. You can… Read more

You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.

The post C# – Read emails from exchange online mailbox (Office 365) into SQL Server appeared first on SQLTreeo.

Read more

Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.

The post How to Extract last name or first name(s) from a combined field appeared first on SQLTreeo.

Read more

Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.

The post How to Extract last name or first name(s) from a combined field appeared first on SQLTreeo.

Read more

Enable dark-theme for SSMS   Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS).   Reading time   +/- 10 minutes   References www.sqlserver.info   Contents   Before you start Requirements how to enable dark theme   Before you start The dark-theme is not officially supported by Microsoft, however,… Read more