Monday, July 28, 2008

Tuesday, July 22, 2008

Online SQL Formatter Tool

I came across a wonderful online tool from my Team Lead,which helps to format the SQL queries. Its very handy and very useful.

http://www.sqlinform.com

Difference Between normal XML & config(ASP.NET web.config, machine.config) files

  • Both are XML files
  • *.xml Files can be rendered on browser i.e, if u know the path of XML you can access it and see the contents on Browser.
  • *.config file can't be rendered on browser i.e, even if u know the path of XML(*.config) file you can't access it and see the contents on Browser so it is secured.
Thanks to my TL Jeebu.

Tuesday, July 15, 2008

Protecting your Enterprise databases

SQL Server has a SQL Profiler tool, which helps Security Administrators to have a complete view of users who have logged in or out of the server.This information can be used for legal purposes to document activity & for technical purposes to track security policy violations.

For more information please go through the documentation provided with your SQL Server.