SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What do you do with a new SQL Server?


What do you do with a new SQL Server?

Author
Message
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (25K reputation)

Group: Moderators
Points: 25602 Visits: 1917
SSWUG.com asked a similar question. Since I'm primarily security focused, that was most prominent on my mind. Here's the list I sent them in an email:

Membership of the local Administrators group.
Quick vetting of anyone in the local Administrators group.
What service accounts the services are running under and what rights they have on the server.
Quick vetting of who has the passwords to these service accounts.
Disk allocation and used/free space.
All logins to the SQL Server.
All logins assigned to the various server roles.
All owners of the individual databases.
Quick vetting of anyone that's a member of the sysadmin fixed server role.
Quick vetting of anyone who has a password to a SQL Server login that's a member of the sysadmin fixed server role.
Backup strategy on each database.
Any information on successful testing of restores.
Applications which use the SQL Server.
How they connect in.
Documentation on the actual rights they need.
Comparison of what rights they were given.
How are the database files distributed?
Is the RAID configuration sufficient?

K. Brian Kelley
@‌kbriankelley
MP-537807
MP-537807
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 121
Hi Carolyn,

I still can't get the deadlock to show up in the log. I added the new alert that you mentioned and I added the notify operator as well to the new alert.

Is there something else I can check or do to get the message to show up in the log. I already ran the script that was mentioned in the link in the your original article.

Thanks
MP
Vivien Xing
Vivien Xing
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3818 Visits: 2204
MP (6/12/2008)

Hi Carolyn,

I still can't get the deadlock to show up in the log. I added the new alert that you mentioned and I added the notify operator as well to the new alert.

Is there something else I can check or do to get the message to show up in the log. I already ran the script that was mentioned in the link in the your original article.

Thanks
MP


I like this kind of articles. Wish to have a checking script to automate some of the tasks and generate a report.

Nice to see another way to catch a deadlock. I have a related post and got a few good answers recently. http://www.sqlservercentral.com/Forums/Topic514877-146-1.aspx
Carolyn Richardson
Carolyn Richardson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2941 Visits: 3538
Right click on the properties of the event and look at history. Has the alert ever been triggered? The history will tell you. If it has fired the failure to send you an email is where the problem is, if it hasn't fired you need to try another alert or look at adding trace flags as per the link in the last post.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Brian Kukowski
Brian Kukowski
Mr or Mrs. 500
Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)Mr or Mrs. 500 (551 reputation)

Group: General Forum Members
Points: 551 Visits: 1607
Thanks for the article. I've recently inherited a number of SQL Servers, so have had to give this some thought.

Here's a few additional items...

Has a recent DBCC CHECKDB been run on every database? If not, do so ASAP.

Examine the current logs (SQL Server, Windows) on the server. Any problem areas ?

See what features are enabled under Surface Area Configuration

Find out what client libraries are in use. If IP, does SQL Server listen on a non-default port (For security, hopefully, yes!) From my experience, use of an incorrect port is the cause of a majority of client connectivity issues

Brian Kukowski
frank.morales
frank.morales
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 9
Great article but my problem is this, "I'm new SQL and just loaded SQL 2005 and what/how do I do next?" I can read the article but it doesn't show "How to the steps." Screen shot or a book with picture would be great help.
GSquared
GSquared
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59743 Visits: 9730
frank.morales (2/5/2009)
Great article but my problem is this, "I'm new SQL and just loaded SQL 2005 and what/how do I do next?" I can read the article but it doesn't show "How to the steps." Screen shot or a book with picture would be great help.


If you use this article and discussion as a starting point, you can take each point the author brings up and research them one at a time. It'll be a great introduction to database administration. Kind of like treating this article as if it were the table of contents for a book on being a DBA.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search