Newsflash

We are back again for this month UG session.

Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timings: 10 AM to 01 PM
Date: October 31 2009
Max Available seats : 25 (Please register, we will be closing the registration once we have 5 members registered)

Configure DB Mail Profile in SQL Agent for Automated Alerts

Print
PDF

Written by Lekss NZ | 03 March 2010
Posted in DBA

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 newbie’s tending to do is, once they configured database mail they expect the SQL agent to use it for alerting purposes. To be clear on this part we should make sql server agent to use any one of the configured mail profiles of database mail system otherwise the agent is not going to use them

Read more... Comments (1)

Use xp_logininfo to retrieve AD group members list

Print
PDF

Written by Vidhya Sagar | 23 February 2010
Posted in Security

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 don’t have permission on AD forest. Normally to retrieve this he will sent the request to the AD team and they will be verifying or sending him the list. I informed him that we have an alternate (happy news to him) to use xp_logininfo SQL extended stored procedure to retrieve the list, he has used it and got the desired result. I then thought of putting it in blog since in most of the big companies DBA’s will be limited to the permission so s\he need to check with the respective team to retrieve the settings. This actually needed when an AD group is added to SQL with necessary permission and when a particular user belongs to that group is not able to access SQL, you need to cross verify the AD group members list, so at that time you can utilize this procedure.

Read more... Comments (1)

SQL Server Joins

Print
PDF

Written by Vidhya Sagar | 18 January 2010
Posted in General

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 the help of these relationship you will be retrieving the data using joins efficiently.

Read more... Comments (3)

DotNet 3.5 on Windows 7 to Install SQL Server 2008

Print
PDF

Written by Vidhya Sagar | 21 January 2010
Posted in Troubleshooting

This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks I’m 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 is required. Windows installer 4.5 is installed and enabled by default, .Net 3.5 is included in windows features, so you can directly go there and turn on .Net 3.5, windows 7 will automatically install this. To turn on .Net 3.5  in Windows 7 just follow the steps below

Read more... Comments (2)

Merge Drop Slipstream Setup – SQL Server 2008

Print
PDF
(1 vote, average 5.00 out of 5)

Written by Vidhya Sagar | 05 January 2010
Posted in General

In my previous article we have discussed about Basic slipstream setup, now I’m 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 be reused multiple times and you can burn it in DVD or copy it to a network share. However the main thing is that you need to TEST this setup package before promoting it as the core setup or live setup copy.

Read more... Add new comment

More Articles...