The Young DBA

Database Consistency Checker (DBCC) commands gives us valuable insight into what's going on inside SQL Server system. There are below DBCC Commands we use day to day Activity . D B C C INFORMATIONAL MAINTENANCE INTERNAL MEMROY DBCC HELP DBCC CHECKALLOC DBCC AUDITEVENT DBCC MEMORYSTATUS DBCC CONCURRENCYVIOLATION DBCC CHECKCATALOG DBCC LOCKOBJECTSCHEMA DBCC FREEPROCCACHE DBCC DES DBCC CHECKCONSTRAINTS DBCC CALLFULLTEXT DBCC FREESESSIONCACHE DBCC MEMUSAGE DBCC CHECKDB DBCC ADDINSTANCE DBCC FREESYSTEMCACH DBCC MEMORYSTATUS DBCC CHECKFILEGROUP DBCC SETINSTANCE DBCC PROCCACHE DBCC CHECKTABLE DBCC INCREMENTINSTANCE TROUBLESHOOTING DBCC UPDATEUSAGE DBCC CLEANTABLE DBCC DELETEINSTANCE DBCC CHECKIDENT DBCC BUFCOUNT(6) DBCC DBREINDEX TUNNING

Metabase (IIS 6.0) The metabase is a structure for storing Internet Information Server (IIS) configuration settings. It performs some of the same functions as the Windows system registry but is specific to Internet Information Server version 4.0. New keys and values have been added for finer and more flexible control of IIS. Like the registry, the metabase is organized in a hierarchical structure that mirrors the structure of your IIS installation. It is made up of nodes, keys, and subkeys. The main organization is by node, with each node in the metabase structure representing a site or directory. Beneath the nodes are keys that may contain one or more IIS configuration values called metabase properties. The metabase keys correspond to individual configuration elements of IIS; each key contains properties that affect the configuration of its associated directory or site. Many of the metabase parameters can be configured from the Internet Service Manager snap-in for the M

Hello Friends,  Recently I have been shared My Post on Change Tracking Log  (winlinuxhelp.com) described how I am storing day to day Database schema change logs Of all server for Reporting &  System Analysis purpose. I want to continue writing about this Topic ..  So today I will share about Change Alert which I have been configured into  system  to alert on every schema changes into my cell. To Create run below Script Create TRIGGER safety1 ON DATABASE FOR CREATE_TABLE , ALTER_TABLE , DROP_TABLE , CREATE_PROCEDURE , ALTER_PROCEDURE , DROP_PROCEDURE , CREATE_VIEW , ALTER_VIEW , DROP_VIEW AS declare @object int                       declare @hr int       declare @rcnum varchar ( 200 ) declare @str varchar ( 200 )                SELECT @str = EVENTDATA (). value ( '(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]' , 'nvarchar(max)' ) --print @str exec @hr = sp_OACreate 'jmail.smtpmail', @object OU

Dear Friends, Today I want to share my experience in Excel.. I think Line Break Character is most popular issue we faced day to day when trying to data cleaning/Transformation in excel or exporting Large data from Excel to SQL for Data warehouse. Sometimes Users typing Enter mistakenly in cell or sometimes copy paste from web page to excel create new line character.  So before using this excel we need to remove this character to make it proper. There is quite a few ways to do so, one of them is to use   Excel find/replace dialog box .  Using this feature is really straightforward, the only problem is that not everyone knows   how to type in the line break symbol . The trick here is to   press ALT and then enter 010 using the numeric keypad . Happy Reading SumnJha