Version is expected to be released in the upcoming month
Cheers :)
 |
| SQL Stripes 2012 Screenshot |
Friday, March 16, 2012
SQL Stripes 2012 Edition is coming...
We're about to release SQL Stripes 2012, which, among other fixes & changes, introduces full support for SQL Server 2012, which recently came out.
Version is expected to be released in the upcoming month
Cheers :)
Version is expected to be released in the upcoming month
Cheers :)
Wednesday, March 14, 2012
Get to know - Database Log-Table Viewer (DLTV)
Let me begin by quickly describing the problem we're trying to solve -
When you develop in a SQL Server environment and reaching a point where your environment contains multiple Stored-Procedures, functions, Jobs and other T-SQL related scripts, you often need a simple logging solutions for tracking processes, progress or any other activity in your system.
I'm not taking about profiler-level tracking of just seeing *anything*, but a more pin-point messages such as:
"YYYY/MM/DD HH:MM:SS - Proc1: Started"
"YYYY/MM/DD HH:MM:SS - Proc1: Gathering new users data"
"YYYY/MM/DD HH:MM:SS - Proc1: Adding users to queue table"
"YYYY/MM/DD HH:MM:SS - Proc1: 20%"
"YYYY/MM/DD HH:MM:SS - Proc1: 60%"
"YYYY/MM/DD HH:MM:SS - Proc1: 100%"
"YYYY/MM/DD HH:MM:SS - Proc1: Done"
Now, consider you write such messages (which you simply store in a table created for the purpose), and would like to quickly access them, either by real-time, search, tree-based exploration etc...
Ta-da! That's exactly what we do!
The Log Table viewer project provides a unified logging interface for your SQL code.
A set of log-based procedures for your Server Side And a powerful log viewer/explorer for the client side
Setup is easy -
After installation, you jump right into the configuration screen, on which you define where the log table/procedure are located (tblLog / usp_write_to_log)
If they don't exist yet, you can easily create them using a single click; Save, and that's it - you're ready to go!
As a side-note, you can either specify your server using the regular SQL dialog, or use our "Server Repository", which hold your server collection and available as a shared list by all of our products. (Post about the repository is also coming soon)
So now, both client/server sides are ready. Next thing you do is start writing your log messages.
Test it - connect to the server/database you've configured the client to access, and write this:
EXEC usp_write_to_log @Source='MyScript', @message='Hello World', @severity=1
Execute...
Now go back to the client, click on the "Real-time" tab, and see your message.
Quite simple, wouldn't you say?
Get DLTV here: http://www.doccolabs.com/products.html#LogTableViewer
Here are some sample screenshots of the client in action:
Enjoy! (it's free and all...)
When you develop in a SQL Server environment and reaching a point where your environment contains multiple Stored-Procedures, functions, Jobs and other T-SQL related scripts, you often need a simple logging solutions for tracking processes, progress or any other activity in your system.
I'm not taking about profiler-level tracking of just seeing *anything*, but a more pin-point messages such as:
"YYYY/MM/DD HH:MM:SS - Proc1: Started"
"YYYY/MM/DD HH:MM:SS - Proc1: Gathering new users data"
"YYYY/MM/DD HH:MM:SS - Proc1: Adding users to queue table"
"YYYY/MM/DD HH:MM:SS - Proc1: 20%"
"YYYY/MM/DD HH:MM:SS - Proc1: 60%"
"YYYY/MM/DD HH:MM:SS - Proc1: 100%"
"YYYY/MM/DD HH:MM:SS - Proc1: Done"
Now, consider you write such messages (which you simply store in a table created for the purpose), and would like to quickly access them, either by real-time, search, tree-based exploration etc...
Ta-da! That's exactly what we do!
The Log Table viewer project provides a unified logging interface for your SQL code.
A set of log-based procedures for your Server Side And a powerful log viewer/explorer for the client side
Setup is easy -
After installation, you jump right into the configuration screen, on which you define where the log table/procedure are located (tblLog / usp_write_to_log)
If they don't exist yet, you can easily create them using a single click; Save, and that's it - you're ready to go!
As a side-note, you can either specify your server using the regular SQL dialog, or use our "Server Repository", which hold your server collection and available as a shared list by all of our products. (Post about the repository is also coming soon)
So now, both client/server sides are ready. Next thing you do is start writing your log messages.
Test it - connect to the server/database you've configured the client to access, and write this:
EXEC usp_write_to_log @Source='MyScript', @message='Hello World', @severity=1
Execute...
Now go back to the client, click on the "Real-time" tab, and see your message.
Quite simple, wouldn't you say?
Get DLTV here: http://www.doccolabs.com/products.html#LogTableViewer
Here are some sample screenshots of the client in action:
 |
| Real-time view |
 |
| Explorer |
Enjoy! (it's free and all...)
Thursday, March 1, 2012
Database File Explorer v1.0.1.5 released
Database File Explorer, our revoluntioary database->file->disk space viewer, has a new version which just came out!
Some of the new features on the new versions are:
- Added quick search box
- Faster switching between view modes (Database-based / Drive-based)
- Added a new button to launch Management Studio (SSMS) with direct server connection
- UI improvements
I'm going to write an entire post on this app soon, in the meantime, feel free to grab it:
http://www.doccolabs.com/products.html#DatabaseFileExplorer
Here's a screenshot from the recent version:
Subscribe to:
Posts (Atom)