Welcome to the final T-SQL Tuesday for 2022. My ask is, what do you have planned for end-of-year activities for your SQL environment? Do you have annual processes or procedures you run? Do you clean up documentation? Do you just take time off and hope someone else does the work?
Some Examples:
- Purge log data
- Archive databases for long term
- Look for orphaned data/log files on your SQL Servers
- Do Security analysis for no longer needed accounts
- Add new years dates to dimension tables
This is a T-SQL Tuesday, so there are rules.
- Publish your contribution on Tuesday, December 13th, 2022 between 00:00 UTC to 23:59 UTC
- Include the T-SQL Tuesday Logo and have it link to this post
- Please comment below with a link to your post
- Tweet about your post using #tsql2sday
The post T-SQL Tuesday #157 – “End of Year Activity” appeared first on GarryBargsley.com.