Thanks for taking the test!

  • The newsletter looks different enough to be fresh without being different enough to be unfamiliary.

    My only questions would be

    • Have you got enough coming in for a daily newsletter?
    • Are you intending to bring an additional information source on-line?
  • quote:


    For the 'submit' to work on the question, would you need to be logged into the site,

    or does it work by posting the email address?


    We could do that but it may be a security risk in case you forwarded the email to a friend. If you're not signed in, it could ask you to and remember the question you're trying to answer. Either way as long as it's easy.

    Brian Knight

    bknight@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bknight

  • quote:


    • Have you got enough coming in for a daily newsletter?
    • Are you intending to bring an additional information source on-line?

    We're focusing most of our time and revenue now in bringing in a new original article each day for the site. It's about to get more interesting when Yukon's NDA lifts as well. In other words, I think we'll have enough content for a daily. The 2x weekly ones are getting large again. 3-4 articles, 40 posts, and 5 scripts are a little bulky for consumption. We're also hoping to add some new features to the site soon that will drive some extra fun.

    On your other questions, one of the partners, Steve, is looking into a networking site. I'm afraid that this is just a side-gig for the three of us and we don't have a whole lot of extra time to put out any new resources. We may consider buying one though and letting their webmaster continue to run it. Could be just a pipe dream though.

    Brian Knight

    bknight@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bknight

  • If you get enough content in an area, you could specialise some of the newletters eg DBA, T-SQL, Security. Along the same sort of lines as the forums.

    Steven

  • quote:


    Could I bounce an idea by you guys since this is a smaller group? We're looking at a few different new newsletter formats. One of the formats that I drafted last night can be seen here: http://qa.sqlservercentral.com/newsletter/newsletterdailybeta.htm


    Brian,

    The format looks good, there is a nice similarity between it and the Email news letters going out currently. I like!

    BTW, Very nice job on the clustering webinar, very helpful and well put together.

    - Vega



    - Vega

  • Thanks for brighting my day some. Great to spend some time on technical subjects even if you feel compelled to ask C2 questions! Now back to the latest developer that doesn't understand why they can't be an 'sa'.

  • I like the look of it. However, I don't always read the SQL newsletters I get now. Most of the time I get the information from the site itself. I use the newsletter to quickly give me an idea of what's available on the site. I suggest including a link/button whatever on the main site that will bring up the newsletter.

    -SQLBill

  • I also got nailed by the UDP question, assumed it was TCP/IP. The location of the C2 output files caught me out too. We don't use C2 auditing and the last time I looked at it was when I was writing the MS SQL exam.

    The test made me realise that I'm getting "rusty" and its time to refresh my memory a bit. Looking forward to the next one.

    John Mac Pherson

    Database Administrator

    Optimal Information Systems Pty (Ltd)

    jmacpherson@ois.co.za


    John Mac Pherson
    Database Administrator
    Optimal Information Systems Pty (Ltd)
    jmacpherson@ois.co.za

  • Having had a quick read around the C2 auditing subject (and deciding that it is massive overkill) does this imply that the default data location for SQL should be left pointing at a standard system drive rather than the RAID array?

    I'm thinking this because logging events are serial in nature.

    Obviously I would define the database/logs as being placed on the RAID.

  • Hi David,

    quote:


    Having had a quick read around the C2 auditing subject (and deciding that it is massive overkill) does this imply that the default data location for SQL should be left pointing at a standard system drive rather than the RAID array?


    I must confess I don't even know what C2 is . BOL is not satisfying on this. Can you share a good link?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Thanks; it was a good opportunity to verify and brush up on my knowledge.

  • I believe the Trusted Computer System Evaluation Criteria (US specific) is being replaced by the Common Criteria (a joint effort between the US, Canada, and several European countries designed to come up with one standard - http://www.commoncriteria.org/ for more info). SQL Server 2000 received C2 compliance under TCSEC. Windows 2000 received EAL4 (+ Flaw Remediation) under the Common Criteria.

    Here is a link that lists the products that have certified uner TCSEC. The page also gives a high-level meaning of what each certification class is.

    http://www.radium.ncsc.mil/tpep/epl/epl-by-class.html

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    Edited by - bkelley on 05/29/2003 07:54:18 AM

    K. Brian Kelley
    @kbriankelley

  • This is really a good test. I liked it. The permissions question makes more scenes to me, as it perfectly describes one of my clients company. We used to spend hours of time to figure out where it’s going wrong and finally decided to design a new security plan instead of going through the mess.

  • I liked the test...I'm disappointed in what I don't know...but I keep learning everyday.

    ON the question 14 about changing your SQL Server login's password, I chose the wrong answer because there wasn't a (') after MYLogin and so I figured it wasn't the correct answer.

    Otherwise, Thanks and keep them coming!



    Michelle

  • The TEST:

    I liked the test but wonder why is was so short?

    The new daily newsletter:

    The new format for a daily newsletter looks easy to prepare and read for both HTML and ASCII but maybe you want to look at columns like a newspaper. The first column would be the entire contents(links of course) and the rest of the articles would look exactly like you have them.

    I would like to see more Questions of the day both from a technical viewpoint (call it interviewing your consultant) and a

    How would you solve this from a architectural view.

Viewing 15 posts - 31 through 45 (of 45 total)

You must be logged in to reply to this topic. Login to reply