SSWUGtv – Security and Sharepoint
With Stephen Wynkoop
With all the sensitive data you store in Sharepoint, how do you make sure it’s protected? Check out todays edition of SSWUGtv as Stephen interviews Patrick Townsend for some real world answers.
Watch the Show
Interrogating Your Database
The last few days we have been talking about a problem submitted by one of our readers who had a database with a large number of stored procedures, with no knowledge of which ones were current, or even which ones even worked.
Today I was reminded by Jonathan Sion of Nob Hill Software about their tool, Diana Lite. I bumped into their products a few years ago when I was mining a database for some different things, and remembered how simple it made interrogating a database. The interface was simple and easy to follow.
Jonathan sent me a link to their latest tool, Diana Lite, http://nobhillsoft.com/DianaLite.aspx, so I had to go and check out what they have going now. They have been busy over there at Nob Hill. Check out this introduction from their web site:
Diana Lite helps you find your way through all your database entities. Easily navigate through your tables, views, procedures and all over entities, across all your servers and databases. Find exactly what you are looking for – then script it, view the data in it, do a search for a substring in an entity source, search through all tables to find specific data in them, Browse through your code and quickly answer questions like ‘which procedures deletes from this table, or updates this table column’ etc… (we are adding features on a monthly basis) It Supports SQL Server (2005 – 2008R2) and MySQL. For now, its given completely free. (Which will not last for long)
Well, the software is available for free, so it may be worth your time to check out the features they have and see if it is useful in your environment.
One of the things Diana Lite does is it takes the capabilities of the tool I used previously, Marie Alix, which allows you to query the data, and enables the same kind of analysis on the database objects themselves. Instead of interrogating the data contained in the database, you are interrogating the code and schema defining the database. How cool is that!
There is so much more…but this ought to raise your interest in looking onto Diana Lite.
Do you have other tools with similar capabilities you like to use? Have you used any of the Nob Hill software? Get into the conversation and share your experience by writing btaylor@sswug.org.
Thanks Jonathan for the update.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
Tips for using SQL Server 2012 data types
In this article, Alexander Chigrik shows some helpful tips to choose the appropriate SQL Server 2012 data types.
Featured White Paper(s)
How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues
read more)