Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Friday Followup For November 15, 2013

lazy_superman

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

Comments That Were Posted This Week

  • Bill on Building The Redneck Treadmill Desk:
    I plan to make the same thing, only on a pool float.
  • DBAndrew on Building The Redneck Treadmill Desk:
    That is very creative.

    I use a Gold Gyms exercise stay ball as a chair. If you maintain good posture it is amazing how much core this works to keep balanced. In 2 years I went from a 36″ waist to a 31″ waist losing my gut and handles. You can get these in different sizes and inflate depending on how high you need to sit at your workstation.

  • Rob Sewell on Automated Permissions Auditing With Powershell and T-SQL: Part 3:
    Hi,

    I have blogged about this here

    http://sqldbawithabeard.com/2013/09/04/sql-login-object-permissions-via-powershell/

    I do it in a slightly different away by creating a function as that was what I needed but they show how to get role membership and object permissions with SMO via Powershell

    http://sqldbawithabeard.com/2013/09/02/checking-sql-server-user-role-membership-with-powershell/

    I hope that helps your PowerShell knowledge as you have helped my T-SQL knowledge

    Rob

This Week In History

Comments

Leave a comment on the original post [realsqlguy.com, opens in a new window]

Loading comments...