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

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

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

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

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

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

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

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

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

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…

Read more

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

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

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

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

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

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

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

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

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than in previous versions. It is IIF and CHOOSE. These two function are very simple but it’s good to know they’re there.

IIF Function
Any developer should be aware of… Read more

T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking and windowing functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE) and other tools, you have really few moments where cursor is better solution. On the other hand, there are still scenarios where cursor… Read more