SQL-Articles

Category: Articles

  • Configure DB Mail Profile in SQL Agent for Automated Alerts

    In the recent times I have seen so many people asking the same question in MSDN forums on how do I activate database mail for the use of SQL server agent alerts system. So I am taking a chance to document it by using screen shots which can help others. Normally what the newbies tending…

  • Use xp_logininfo to retrieve AD group members list

    I was discussing with one of my colleague and during the discussion he told me that he is not able to view the list of members available in a AD group since he dont have permission on AD forest. Normally to retrieve this he will sent the request to the AD team and they will…

  • DotNet 3.5 on Windows 7 to Install SQL Server 2008

    This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks Im seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5…

  • SQL Server Joins

    SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With…

  • Merge Drop Slipstream Setup

    In my previous article we have discussed about Basic slipstream setup, now Im going to write a article on Merged Drop slipstream setup. In this method you will be merging the service pack with the base setup prior to the installation there by altering the source or base setup files. The merged setup package can…