-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Five database management trends to embrace in 2019

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

0 comments, 231 reads

Posted in SQL Treeo on 7 January 2019

Why do we think water and databases are similar?

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

0 comments, 173 reads

Posted in SQL Treeo on 17 December 2018

Three tips to help your database team avoid burn out this holiday season

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

0 comments, 308 reads

Posted in SQL Treeo on 3 December 2018

Would you give our database monitoring the UX thumbs up?

“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

0 comments, 219 reads

Posted in SQL Treeo on 20 November 2018

A Health Check can keep your SQL database in great shape

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

0 comments, 219 reads

Posted in SQL Treeo on 7 November 2018

Three ways a virtual Database Administrator (vDBA) could be just what your business needs

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

0 comments, 2,331 reads

Posted in SQL Treeo on 24 October 2018

Four tools to help implement Database Continuous Delivery

“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

0 comments, 359 reads

Posted in SQL Treeo on 8 October 2018

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

0 comments, 234 reads

Posted in SQL Treeo on 19 September 2018

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

0 comments, 405 reads

Posted in SQL Treeo on 7 July 2018

Finding Missing indexes

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

1 comments, 322 reads

Posted in SQL Treeo on 7 July 2018

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

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

0 comments, 488 reads

Posted in SQL Treeo on 20 May 2018

How to Extract last name or first name(s) from a combined field

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

0 comments, 74 reads

Posted in SQL Treeo on 19 May 2018

How to Extract last name or first name(s) from a combined field

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

0 comments, 1,267 reads

Posted in SQL Treeo on 19 May 2018

SQL Server Management Studio Dark theme

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

0 comments, 194 reads

Posted in SQL Treeo on 14 March 2018

SQL Server Management Studio Dark theme

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

0 comments, 76 reads

Posted in SQL Treeo on 14 March 2018

Blocking Locks and Deadlocks

Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock occurs when one lock causes another process to wait until the current process is entirely done with the resources. Deadlocks Consider the situation where one partially finished transaction must wait… Read more

0 comments, 98 reads

Posted in SQL Treeo on 28 February 2018

Blocking Locks and Deadlocks

Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock occurs when one lock causes another process to wait until the current process is entirely done with the resources. Deadlocks Consider the situation where one partially finished transaction must wait… Read more

0 comments, 206 reads

Posted in SQL Treeo on 28 February 2018

GDPR Compliant worden

Op 25 mei 2018 treedt de General Data Protection Regulation (GDPR) in werking. Deze nieuwe Europese privacywetgeving is van toepassing op alle lidstaten binnen de Europese Unie. Het doel hiervan is het aan de burgers teruggegeven van de grip op persoonsgegevens en het beschermen van de privacy. In de praktijk… Read more

0 comments, 221 reads

Posted in SQL Treeo on 29 December 2017

Stretch database to cloud.

Microsoft Azure stretch database     Purpose   Information regarding the new feature in SQL Server 2016. Reading time +/- 20 minutes   References Microsoft documentation: https://docs.microsoft.com/en-us/ Contents What is a stretch database? When should you stretch a database? Implementing stretch database. Microsoft Azure stretch database Security. Limitations stretch database.… Read more

1 comments, 149 reads

Posted in SQL Treeo on 22 November 2017

Why do you want to use SQL Service Broker

Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server is using Service broker for its builtin Mail components since SQL Server 2015. Asynchronous SQL Server statements are synchronous, 1 statement after another. Each statement waits until it is… Read more

0 comments, 160 reads

Posted in SQL Treeo on 8 November 2017

Older posts