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