DBPedias

Your Database Knowledge Community

Andy Lohn

  1. Book Review – "Windows Powershell 3.0 Step By Step" by Ed Wilson, O’Reilly Media, Inc.

    I’ve as I’ve mentioned many times on twitter, I’ve become quite obsessed with Powershell over the last year and a half.  I recently joined the O’Reilly Blogger Review Program and here is my first review.

    Book Summary

    Microsoft Certified Trainer, Ed Wilson, covers all of the facets of Powershell 3.0.  Not only does he teach the reader how to use Powershell, he also teaches them to teach themselves Powershell.  The book starts with the basics and builds to expert levels on many topics in Powershell.  There is a section in the introduction on what chapters to read based on your background and ability and hopes/wants/needs for Powershell.  This helped me pick and choose what to read and focus on.  At the end of each chapter, there are exercises that really test your knowledge and drill the information into your brain.  Also, throughout the book, there are Tips and Notes that help find the important information quickly.  Finally, each chapter has a Quick Reference at the end that summarizes the main points which is extremely helpful in getting the information you need.

    My Reactions

    Since I got this book, I have used it as a reference everyday.  In fact, I added a snippet to my $profile to open it when I open Powershell.  I’ve seen a few videos and demonstrations of the Get-Command and Get-Member functions, but having the hands on exercises along with the the full explanations helped me finally understand how to use these – and that was in the first chapter!  I love the "Hey, Scripting Guy! Blog" and this book uses a similar approach.  It keeps things simple and builds upon the simple things.  Due to the fact that this book uses a straightforward approach and makes the finding of information very easy, I recommend it to anyone interested in learning and/or improving their Powershell skills.

    I review for the O'Reilly Blogger Review Program

  2. May 2013 PASSMN Meeting

    Sponsor: C2IT Consulting

    C2IT Logo

    Date: May 21st, 2013

    Time: 4:00 PM – 6:00 PM

    Location: 3601 West 76th Street, Suite 600 Edina, MN  55437

    Live Meeting:

    Agenda:

    • 4:00-4:15 : Registration / hospitality / networking
    • 4:15-4:30 : SSMS 2012 – Tips, Tricks and New Features, by Rizwan Hassan
    • 4:30-5:30 : SQL Server Security and Data Security, by Ross McNeely
    • 5:30-6:00 : Announcements and prize giveaways

    Click here for all the details and to RSVP

    Presentation:

    SQL Server Security and Data Security, by Ross McNeely

    The presentation will walk through the requirements to secure SQL Server, and how to implement data security requirements. Ross decided to discuss both SQL Server Security and Data Security due to the amount of confusion that often occurs during the security phase of a project. Some of the topics included are SQL Server configuration, table/execution permissions, OLAP security, and using a security data model. The presentation will cover a large amount of material in a short time span, but hopefully you will find it informative.

    Ross McNeely is a BI Practice Manager at C2 IT Solutions. As a Business Intelligence consultant Ross have installed and secured SQL Server instances for various customers. Ross has presented at several SQL Saturday in Minnesota, Wisconsin, and Iowa. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic. Please join Ross McNeely for a fun and informative meeting.

    Presentation:

    SSMS 2012 – Tips, Tricks and New Features, by Rizwan Hassan

    There are certain features in SSMS 2012 that we are unaware of and new features that learned while using SSMS 2012. I would like to share those features with you!!!

    Rizwan Hassan started as System Administrator and evolved into SQL DBA Administrator. Rizwan have worked at Virteva and Kroll Ontrack. He is currently working at General Mills as SQL DBA. Responsible for 600 SQL instances with 3000 databases

  3. March PASSMN Meeting

    The official details of this meeting are located here – (old habits die hard).  I’m no longer on the PASSMN board, but they are doing a top notch job and this promises to be be a great free training session.

    Sponsor: True Source

    Date: March 19th, 2013

    Time: 4:00 PM – 6:00 PM

    Location: 3601 West 76th Street, Suite 600 Edina, MN  55437

    Live Meeting:

    Agenda:

    • 4:00-4:15 : Registration / hospitality / networking
    • 4:15-4:45 : Problematic Restore Scenarios, by Jeff Joy
    • 4:45-5:45 : An Optimistic Approach, Snapshot Isolation in SQL by Paul Timmerman
    • 5:45-6:00 : Announcements and prize giveaways

    Presentation:

    Problematic Restore Scenarios, by Jeff Joy

    Jeff Joy, UnitedHealth Group

    You know the drill – Restore the last full backup, last differential backup and all subsequent transaction log backups up until the desired point in time of recovery…..but not always! There are situations many DBAs are unaware of that can confuse, complicate, and even prevent a successful point-in-time restore.

    Jeff Joy is a Sr. Database Consultant performing SQL Server Engineering at UnitedHealth Group. He has been working with SQL Server for eleven years and has a varied background including – 9 years as a Cryptologic Linguist (Russian) for the USAF, 13 long years in Retail Management that inspired a career change, 5 years as a Software Developer and 6 years as a SQL Server DBA.

    Presentation:

    An Optimistic Approach, Snapshot Isolation in SQL

    Paul Timmerman, Hennepin County Medical Center

    Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case. After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate. Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!

    Paul Timmerman is the lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has over a decade of experience in enterprise database administration and is currently the Chapter Leader of the Minnesota SQL Server User Group,PASSMN.

  4. December PASSMN Meeting–Today!!!

    Meeting Details

    Please click here for meeting details and to RSVP

    Extended Events:  Work Smarter Not Harder

    Jason Straight, Pragmatic Works

    Of the many ways to monitor your SQL Server environment, Extended Events is one of the newer platforms that can help you investigate and resolve performance problems. In this special 90-minute session, we’ll review Extended Events and learn the ins and outs of how to get and analyze detailed information on the errors and events that occur within SQL Server. With a few T-SQL statements, you can research in minutes issues that used to take weeks to investigate.

    Jason Strate, Pragmatic Works, is a SQL Server database architect and Microsoft SQL Server MVP. He has over 15 years of experience developing, architecting, and managing data platforms. He is a highly-skilled database administrator with a strong background in database/data warehouse architecture and best practices, business analysis, mentoring and leadership. He works with clients to review and analyze their SQL Server environments and make recommendations related to performance improvement and reliability in their data platforms.

  5. SQLQuill – Link Round Up – December 2012 Edition

    Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.

    SQL

    Tools

    • Good reading from Google Reader – Use the “Embarrassment Test” to Help Make Difficult Decisions http://bit.ly/TjmeqT

    News

    Entertainment

    Sports Humor

    • Good reading from Google Reader – We found the clipboard Mark Sanchez was drawing on http://bit.ly/SKFrmT
    • Good reading from Google Reader – Friday Funny 433: Who’s Beating You In Your Marathon? http://bit.ly/11bOBhb

    Running/Workouts

  6. December Special PASSMN Meeting

    Sponsor: Microsoft Technical Communities

    Date: December 5th, 2012

    Time: 5:30 PM – 7:00 PM

    Location: 3601 West 76th Street, Suite 600 Edina, MN  55437

    Live Meeting:

    Please click here for meeting details and to RSVP

    Agenda:

    • 5:30-5:45 : Registration / hospitality / networking
    • 5:45-6:45 : Jim Walker talks Hadoop, Big Data and Microsoft Tools
    • 6:45-7:00 : Closing comments/prize giveaways

    Presentation:

    Jim Walker talks Hadoop, Big Data and Microsoft Tools

    Jim Walker, Hortonworks, is a recovering developer, professional marketer and amateur photographer with nearly twenty years experience building products and developing emerging technologies. During his career, he has brought multiple products to market in a variety of fields, including data loss prevention, master data management and now big data. At Hortonworks, Jim is focused on accelerating the development and adoption of Apache Hadoop.

  7. October PASSMN Meeting

    Meeting Details

    Please click here for meeting details and to RSVP

    Data Quality Services

    Jeff Prom, Magenic

    As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using Data Quality Services! DQS is the new data quality tool provided with SQL Server 2012. In this session we will cover topics such as creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, the Excel Add-in, and how to integrate DQS into your SSIS packages.

    Jeff Prom is a Senior Consultant with Magenic Technologies in Minneapolis. He holds a bachelor’s degree, three SQL Server certifications, and is an active PASS member. Jeff has been working in the IT industry for over 14 years and currently specializes in data and business intelligence.

    Ola Hallengren’s SQL Server Maintenance Solution

    DBAs are inconstantly using SQL Server standard maintenance and custom maintenance plans to maintain SQL environments. Ola Hallengren has been generous enough to contribute his maintenance plans which are not only effective, but also can be customized to meet small to large SQL environments.  These plans have won SQL Server Magazine 2011 Gold Community Choice and Silver Editors’ Best awards.  The Ola’s maintenance plans cover:

    • SQL Server Backups
    • SQL Server Integrity Checks
    • SQL Server index and Statistics Maintenance

    Rizwan Hassan is a Database Administrator with Kroll Ontrack in Eden Prarie. He has been working with SQL Server since 2010.  Rizwan was introduced to SQL Server and mentored by, PASSMN’s Director of Program Development, Tim Plas.

     

    Magenic

  8. SQL Saturday #149 – Wrap up

    The Highlights:

    I was very impressed with the entire event.  Paul Timmerman (T) did an excellent job planning and organizing the entire thing.  Many thanks to all the volunteers who helped as well – too many to list out and I know I would feel bad when I remembered someone I forgot to mention.

    I finally got to meet and talk to grrl_geek, SQLMD, WIDBA, DataOgre, and IngeniousSQL.  That was the best part of the day for me.  My one regret is that missed meeting SQLSoldier.

    I was also very inspired by meeting Andy Yeager (LinkedIn) – the guy is looking to change careers and he wants to get into the SQL server game, so in his spare time he’s been studying, reading and attending events like this.  In my spare time, I watch football.

    My Session:
    TSQL Tips and Tricks

    Thanks for everyone who attended my session.  It was fun and I was much more comfortable presenting than I have been in the past.  I honestly had fun doing it.  Next time I will project my voice more or use a microphone – that was the most commented on aspect of my talk in the evals. 

    Click here to download the presentation with the demos.

    Here are the links I mentioned during the session that I would post:

     

  9. SQLSaturday #149–this weekend!

    SQL Saturday #149 is coming this Saturday to the U of M campus.  The official site for all the information is here.  Normally I would be supporting Dabo and the Clemson Tigers, GAC or Coach Kill if I were to be on a campus on a Saturday afternoon, but this promises to be as good or better.

    I will be presenting my “Beginning TSQL Tips and Tricks” as well as doing “Topics On A Stick: Networking & Mock Interviewing” at lunch time.

    Tomorrow I will be checking out the twitter buzz (#SQLSat149) and making sure I’m following all the attendees by using this powershell script.

  10. SQLQuill – Link Round Up – September 2012 Edition

    Here’s the links I’ve tweeted in the last month – hope it is useful/entertaining/etc.

    SQL

    Tools

    News

    Entertainment

    Sports

    Sports Humor

    Running/Workouts

  1. 1
  2. Next ›
  3. Last »