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

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

0 comments, 214 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-5b54c086970ce834867307/] 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, 185 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, 147 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, 1,042 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, 37 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, 39 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, 40 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

0 comments, 27 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, 27 reads

Posted in SQL Treeo on 8 November 2017

Create a Login in a SQL Server Availability Group

Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where they use the AG databases. An Availability Group consists of (at least) 2 different SQL Servers: Problem In case of a failover, select/insert/update/delete in that database will fail. Explanation A… Read more

0 comments, 31 reads

Posted in SQL Treeo on 28 October 2017

Dashboard Server Status

Dashboard Server In the Server Dashboard the tile background can change between Green (Ok), Orange (Warning) and Red (Error). When you click on any of the icons additional information is shown with more detail: You can hover over the different pieces of information and popup dialogs will show even more… Read more

0 comments, 31 reads

Posted in SQL Treeo on 20 October 2017

Deactivate SQLTreeo license

Version SQLTreeo SSMS Add-in version 0.8.4 or higher. Purpose Deactivate a SQLTreeo license when your workstation is unavailable. SQLTreeo is limited per workstation, once a license key is activated it cannot be activated again on another workstation. Users who switch or reinstall their workstation without taking the proper steps often… Read more

0 comments, 24 reads

Posted in SQL Treeo on 19 October 2017

SQLTreeo SSMS addin issues

Purpose Get help soon with SSMS Addin issues. In some cases a user might experience problems with their SSMS Add-in. After upgrading to a new version or a new installation. Our customer service will help users with issues to their best abilities. What kind of issues I report to Servicedesk?… Read more

0 comments, 40 reads

Posted in SQL Treeo on 28 September 2017

Loadbalancing SQLServer

Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you have to do some work of your own.

There are a few facts you need to know when you want to load balance your SQL Server:

  • You can loadbalance SQL…

Read more

0 comments, 1,122 reads

Posted in SQL Treeo on 12 November 2013

Improved Customer Support

In the last couple of months SQLTreeo has improved her customer contact skills. Before it was just an email to email conversation between our users and our development guru’s.

As we have been growing with our development team we have also fulfilled the need of a having good support team… Read more

0 comments, 731 reads

Posted in SQL Treeo on 13 September 2013

SQLTreeo – Migration of extended properties to local storage

New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and folders. This option was added because many users had issues with storing their folders in extended properties of SQL objects (mostly because of permission issues).

Users who need to swap… Read more

0 comments, 1,472 reads

Posted in SQL Treeo on 28 March 2013

New SQLTreeo Version

We are glad to announce that new SQLTreeo SSMS Add-In was published.

List of new features/enhancements are following:

  • Local storage support – SQLTreeo stored folder structure to extended properties of SQL objects. Now it’s possible to store folder structure in filesystem. See SSMS Tools->SQLTreeo menu.
  • Few bugs fixed
  • Few performance…

Read more

0 comments, 858 reads

Posted in SQL Treeo on 20 March 2013

You don’t like SQLTreeo price

Today is the first day when we turned SQLTreeo into a commercial product and your emails continue to flood into our mailbox, with the overall message that you don’t like price. We are listening and we want to respond. SQLTreeo is not an entirely business-driven project and we are able… Read more

0 comments, 1,413 reads

Posted in SQL Treeo on 25 October 2012

SQLTreeo now supports SQL Server 2012

New version of SQLTreeo SSMS Add-In was released. We fixed few bugs and include also one major change – SQL Server 2012 support. SQLTreeo Add-In also became commercial product which will help us to give more attention to further development and support. We are now working on local storage support Read more

0 comments, 894 reads

Posted in SQL Treeo on 24 October 2012

SQLTreeo resurrection

I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who will be running web site and add-in further. This step was inevitable as I have no chance to cultivate it in the future.

There are few improvements I highlighted and… Read more

0 comments, 702 reads

Posted in SQL Treeo on 21 September 2012

Older posts