Click here to monitor SSC
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 (6.8K reputation)

Group: Moderators
Points: 6770 Visits: 1908
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
MP-537807
MP-537807
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1292 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
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1553 Visits: 3443
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 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)

Group: General Forum Members
Points: 508 Visits: 1532
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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14371 Visits: 9729
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