Loadbalancing SQLServer
There are a few facts you need to know when you want to load balance your SQL Server:
- You can loadbalance SQL…
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…
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
Hi,
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
Hi,
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
Hi,
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…
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