SQLChicken.com

SQL Server DBA Tips & Tricks

By

SQL University: Basic Tools Pt. II

In Tuesday’s class we covered the different authentication methods as well as did a quick walk-through of the SQL Management Studio interface. In today’s lecture we’ll continue looking at SSMS. Some of the things we look at include how to create a query against a database, brief intro to the Profiler tool as well as a brief intro to the Database Engine Tuning Advisor.

Warning: Video is hosted by YouTube. If you cannot see it your company might be blocking that site. My apologies, I will have an alternative method available in future.

In addition to watching the video you guys have a little bit of homework. Don’t worry, it’s not hard. Just try a few of the things on this list to help you get accustomed to the environment.

  • Connect to your local database using SSMS using Windows authentication
  • Browse to the AdventureWorks Database, Open up the Tables folder and select the TOP 1000 Rows from Person.Address table. In comments below, post the AddressLine1 for AddressID 17.
  • [Extra Credit] Browse to the Security folder, Open up the Logins folder. Create a new login called testlogin. Make it SQL Server authentication, give it password of ‘P@$$w0rd’ (NOTE: Thanks to Brian Kelley for pointing this out. Do NOT use your production servers/databases for this excercise. Also NEVER use password this simple in your production environment…ever. Security will be covered in a few weeks.), make its default database AdventureWorks.

Next week we’ll be covering Backup and Restore with Argenis Fernandez (Blog | Twitter). The full syllabus for the semester will be posted shortly.

Share
  • http://dyfhid.blogspot.com/ David (dyfhid) Taylor

    And the answer is…

    6696 Anchor Drive

    It’s kinda lonely here in teh comments list, seeing that line up there that says “No comments yet.”

    Well Professor, I have done my homework, *and* my extra credit. Learning, learning.

    • http://sqlchicken.blogspot.com Jorge Segarra

      Ha thank you David! It’s good to see feedback and I’d like to encourage and ALL students to please comment on any of the SQL University pages. Let’s make this project as interactive as possible!

  • Melanie Arnold

    6696 Anchor Drive

  • Tom Lannen

    6696 Anchor Drive

    • http://emailtoid.net/i/79a23b74/bec3ed36/ Jorge Segarra

      Nice, good job Tom and thanks for following along!