http://www.sqlservercentral.com/blogs/realsqlguy-helping-you-to-become-a-sql-hero/2013/11/15/friday-followup-for-november-15-2013/ Printed 2016/06/27 11:21AM
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