SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Friday Followup For November 15, 2013


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

  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Do You Need A Log Recovery Tool?
  • The Cloud Is Scary – #TSQL2sDay #49
  • SYS.PARTITIONS: Better Than X-Ray Vision
  • Building The Redneck Treadmill Desk
  • Automated Permissions Auditing With Powershell and T-SQL: Part 2
  • Transparent Data Encryption’s Dirty Little Secret
  • Automated Permissions Auditing With Powershell and T-SQL: Part 3
  • SQL Query Formatting – Putting Lipstick On A Pig
  • No, Simple Mode Doesn’t Disable The Transaction Log

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:

    I have blogged about this here


    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


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


This Week In History

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.


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

Loading comments...