The Young DBA

An 'Inner Join' is used to join operation in an applications, which creates a new result table by combining column values of two tables (A and B) based upon the join-predicate. The query compares each row of A with each row of B to find all pairs of rows which satisfy the join-predicate. When the join-predicate is satisfied by matching non-NULL values, column values for each matched pair of rows of A and B are combined into a result row. We can create inner Join through various method in application. I want to share 3 ways which I used in various application. Implicit Join Method Explicit Join Method Cross Apply Method

Keeping updated production environment is an important task for any DBA. Updated Database Server allows to Secured and bug free environment and it helps to keep growing organization and there business process. To updated our production environment we should know few terms related to Database server maintenance activity.   

Q:- What are the Default Services in SQL Server 2012 ? If this questions is related for Interview then this can be tricky because as per configuration manager the default services related to SQL server are 4 (DB Engine, Full text, Browser and Agent Service). To check run   compmgmt . msc  from CMD Prompt and select SQL Server Configuration Property. Then List of Services will show like below

MS Excel is one of most popular package for every kind of professional in 21st century. I am using this application since 2005 on different ways. I have been worked on excel with Simple tool, Advance tool, macros and VBA applications features. Every Data and Database Professional should know about use of Excel and their features.

Friend Developer’s Day is one of important day for me which I never miss and C#sharpcorner bring again in NCR with legends of IT Gurus, who will teach us new technologies on 28 th June 2014. I am going to learn mongoDB with Asp.net.

SyncBackPro ,  Edit Plus ,  Dreamweaver and S MSgee PC SMS Gateway Server 4.2 are my older tools which i used between 2010 to 2012 in previous organization. Sometimes i am missing all those.

By default the no count setting will be OFF in sql server for any procedure execution. What is happening when we execute any procedure , Sql server connect and send back information to client and client to server. This allows client to show the record set along with message in different tab but this message transferring activity creates an extra over-head on network. We can reduce this overhead by turning   ON to no count so the procedure will get much better performance in execution.