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

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

2 comments, 1,064 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, 677 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

1 comments, 1,387 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

9 comments, 815 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

16 comments, 1,357 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

13 comments, 849 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

9 comments, 665 reads

Posted in SQL Treeo on 21 September 2012

SQLTreeo is suspended

Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by quite many people and I have to admit that I couldn’t give them proper support because I had no energy to solve any issues in the evening after… Read more

12 comments, 752 reads

Posted in SQL Treeo on 12 July 2012

SQL Treeo – Extended properties or local file – please vote


I was trying to solve SQL Treeo’s performance issue on slow connection. This posts is also covers feature request of having separate folder structures for each developer (store folder structure in local file). SQL Treeo currently stores object’s folder name to its extended property named “VirtualFolder”. This helps to… Read more

23 comments, 971 reads

Posted in SQL Treeo on 12 May 2012

RedGate SQLSearch & SQL Treeo friendship


one of SQL Treeo users developed clever workaround for SQL Treeo SSMS Add-in to be more compatible with RedGate SQL Search. Enhancement causes that RedGate SQL Search can now jump in folders you created using SQL Treeo Add-in. This allows you to organize your SQL objects in folders… Read more

2 comments, 1,045 reads

Posted in SQL Treeo on 11 May 2012

Add-In for searching object in SSMS without touching mouse

I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and other objects quicker than by using standard SSMS features. Few of them were very well usable but all of them are built to support also complex searching including schema, source… Read more

1 comments, 918 reads

Posted in SQL Treeo on 7 November 2011

New version of SQL Treeo SSMS productivity add-in was released


new, second version of SQL Treeo productivity add-in was released.

For little reminder, here are main features of this add-in:

  • Create custom folders in SSMS’s object explorer using drag&drop. It works for databases, stored procedures, functions, views and tables
  • Ctrl+click on object will bring ALTER script
  • Perform bulk operations…

Read more

2 comments, 2,207 reads

Posted in SQL Treeo on 6 November 2011

SQL Server 2011 “Denali”: Four new useful DMV

SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them were already introduced in SP1 of SQL Server 2008 R2 but it was only two month ago (July 2011). I believe that these views were developed in new release… Read more

0 comments, 677 reads

Posted in SQL Treeo on 14 September 2011

SQL Server DMV Views: Getting slow queries within stored procedure

SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and you find out that it’s slow. It would be nice if you could discover which single query/ies in your procedures causes that it is slow. Few DMV… Read more

0 comments, 1,224 reads

Posted in SQL Treeo on 8 September 2011

SQL Server 2011 “Denali”: Give feedback and win nice gifts

Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for 30$. All you have to do is to report a bug or make a suggestion till September 10, 2011 and be in 300 of first.

Please follow instructions in this… Read more

0 comments, 586 reads

Posted in SQL Treeo on 5 September 2011

Creating Facebook page for blog

Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm and I am very glad. Many users are also waiting for SQL Server 2005/2008 support (2008 R2 is only supported version now) and I will release it soon. I received… Read more

2 comments, 690 reads

Posted in SQL Treeo on 29 August 2011

How to write data from user-defined function

Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL Server. My colleague recently needed to log something from within function so we were searching for solution how to do that with least work. There is one option to call… Read more

0 comments, 1,100 reads

Posted in SQL Treeo on 28 August 2011

Great new analytical functions in SQL Server 2011 “Denali”

SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read about another new functions in Denali’s Books Online. I am missing those functions, I will write about, really for years. They’re filled under “Analytical function” and they are close to… Read more

0 comments, 584 reads

Posted in SQL Treeo on 14 August 2011

Download free SSMS Add-In to create custom folders for database objects

I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in came from fact that I was dealing with hundreds of SQL objects and was fed up of browsing for correct one in SSMS standard folders. I tried also many “quick… Read more

1 comments, 2,440 reads

Posted in SQL Treeo on 8 August 2011

SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it

SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous versions of SQL Server support reading metadata from system catalog but it is possible only for fixed objects. With following new procedures you can do similar thing but for dynamic… Read more

0 comments, 869 reads

Posted in SQL Treeo on 3 August 2011

Older posts