Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

What do you do with a new SQL Server? Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 11:53 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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
Post #516150
Posted Thursday, June 12, 2008 11:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 9:52 AM
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
Post #516152
Posted Thursday, June 12, 2008 6:50 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 2:49 PM
Points: 1,279, Visits: 2,203
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
Post #516341
Posted Friday, June 13, 2008 3:11 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, April 17, 2014 8:05 AM
Points: 1,451, Visits: 2,911
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
Post #516492
Posted Friday, June 13, 2008 9:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:13 AM
Points: 458, Visits: 1,156
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
Post #516859
Posted Thursday, February 05, 2009 2:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 08, 2009 10:52 AM
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.
Post #651263
Posted Thursday, February 05, 2009 2:21 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
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
Post #651280
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse