Common Tasks

A collection of code that I run on a semi-regular basis to troubleshoot or get an overal status of machines and or code. Most of these will be for SQL Server and Powershell

Categories

• SQL Server
• Powershell

---

SQLServer

1. Concatenate values as comma delimited list
2. Getting file size, space used and space free information for a SQL Server database
3. How much longer will the database restore take
4. List all tables that are truly partitioned
5. List all tables with identity columns
6. Listing all RESTORE and BACKUP operations currently going on your SQL Server
7. Renaming a Table
8. Return a range of dates minus weekends and holidays
9. Return all stored procedures that contain certain text
10. Return columns for a user defined table type
11. Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column
12. Running count with windowing functions
13. Index Fragmentation
14. Who is connected to my server
15. When were the databases backed up?
16. What is currently running on the server
17. Using sp_send_dbmail to email query result
18. List the existing Extended Events sessions
19. Simple Extended Event Session to check when procs were called

Powershell

• Export SQL Server query results into a csv file
• List the 10 biggest files in a directory
• Get your powershell version