<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Carolyn Richardson
»
What do you do with a new SQL Server?
27 posts, Page 3 of 3
««
«
1
2
3
What do you do with a new SQL Server?
Rate Topic
Display Mode
Topic Options
Author
Message
K. Brian Kelley
K. Brian Kelley
Posted Thursday, June 12, 2008 11:53 AM
Keeper of the Duck
Group: Moderators
Last Login: Wednesday, May 08, 2013 5:14 AM
Points: 6,583,
Visits: 1,787
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
MP-537807
MP-537807
Posted Thursday, June 12, 2008 11:55 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, January 25, 2011 9:59 AM
Points: 30,
Visits: 120
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
Vivien Xing
Vivien Xing
Posted Thursday, June 12, 2008 6:50 PM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279,
Visits: 2,191
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
Carolyn Richardson
Carolyn Richardson
Posted Friday, June 13, 2008 3:11 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 1,397,
Visits: 2,738
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
Brian Kukowski
Brian Kukowski
Posted Friday, June 13, 2008 9:56 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:52 AM
Points: 421,
Visits: 963
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
frank.morales
frank.morales
Posted Thursday, February 05, 2009 2:02 PM
Forum 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
GSquared
GSquared
Posted Thursday, February 05, 2009 2:21 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439,
Visits: 9,569
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 »
27 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
