Archive for the ‘WebAndNetworks’ Category

SQL SP to search for string in all tables in a DB

Wednesday, October 12th, 2005

When working on SQL databases, from time to time you feel the need to search for a integer / string in all the tables of a databses. I found these solutions handy.

a. Search for a string in all tables of SQL Server Database

b. Searching and finding a string value in all columns in a SQL Server table

c. Search entire SQL Server database and all tables for a specified string

I wanted to search for a string while I was working on MS Project server database in production. This query solved my purpose.

1. Run the script (go to url above) in Query Analyzer for the database in which you want to search for a integer / string

2. Use the syntax mentioned or try one in the examples section to search for integer / string
3. View the results by querying the ##tmpSearchResult table

(Imp: Play with the script in your testing environment then use in production. Use it at your own risk.)

EMS MS SQL Manager

Thursday, August 18th, 2005

MS SQL Enterprise Manager is a powerful tool. But if you are looking for some administration tool for MS SQL / MSDE go for EMS MS SQL Manager.

 

It comes in two versions Professional & Lite (Compare). It’s a powerful database management tool with:

 

  • Easy Management of db objects
  • Advanced Data Manipulation Tools
  • Powerful Security Management
  • Visual / Text tools for Query building
  • Data import / exports
  • Administrative Tasks
  • & tons of other features

 

EMS MSSQL Manager Lite for Windows is free. You can download a copy from their website.

Flow diagrams of Code (T-SQL)

Wednesday, August 10th, 2005

At my work I had a long SQL stored procedure code (coded by someone else) which was difficult to understand at first. I was Looking for some tool which could do the job of creating flow diagram of the code. But didn’t find any.

Few days later a friend sent me an email with a link to a tool which can create flow diagrams of almost any code (T-SQL, Java, VB, .NET etc). I’ve tried its demo version which created a flow diagram of my code in 5 sec. Wow.. That was gr8 if I compare it with the 2 days efforts I took to manually create the flow diagram in Visio. Though after comparison I like my Visio :). But still it’s a handy tool for a quick look at the code.

Check it out these tools.

Visustin v3 Flow chart generator (I’ve tried this one)
http://www.aivosto.com/visustin.html

Data Flow Diagram (with Case Studio 2)
http://www.casestudio.com/

Later on while searching I found another interesting tool. I haven’t tried it yet, but it looks like you can code (or edit code) just by making diagrams.

Code Visual to Flow Chart v3.3
http://www.fatesoft.com/flowchart/

 

Windows – SAM (Software Assessment Management)

Monday, August 8th, 2005

SAM (Software Assessment Management) from Microsoft allows you to do:

  • Software Inventory
  • Matching Software with Licenses
  • Review Policies & Procedures
  • Developing a SAM Plan

SAM Procedure walk you through the process of SAM. A list of downloadable documents and templates are available to help you with the implementation of SAM.

Microsoft Assessment and Planning Toolkit (MAP) a free tool from Microsoft allows you to make an inventory of installed Microsoft products on local system or on network.

Contact Softvative for Software Asset Management solution for your organization.

Windows! AD Group Policy Site

Monday, August 8th, 2005

This links is on Active Directory (AD) Group Policy. It elaborates some good features of AD. Check it out at:

http://en.wikipedia.org/wiki/Group_policy

Also check the site for other information. It’s a nice site with good information.

SMTP log Analyzer

Monday, August 1st, 2005

Sawmill offers a log analyzer which can parse a range of log file formats. It can be a good tool to analyze SMTP logs.

http://www.sawmill.net/

Magazine – Free Magazine on Microsoft products

Sunday, July 31st, 2005

Redmondmag.com offers a free magazine with nice in depth articles on different Microsoft products. You can subscribe to its digital version.

Check their site at http://www.redmondmag.com/