The following logic allows you to delete old backup files with TSQL where the Powershell delete script is built. Here’s how it works… First; you supply the backup drive letter. Second; you […]
Here’s another example of the Dark SSMS Monokai theme using the ssms.pkgundef mod. The file can be found here: C:Program Files (x86)Microsoft SQL Server130ToolsBinnManagementStudio Here’s my ssms.pkgundef file with mods included. If […]
If you’re like me and do any amount of web work; you’ll find lots of useful tools out there for the Mac or PC so you can carry out your work. In […]
Quickly view ALL your SSMS Tabs with CTRL+ALT+L It’s hard to find all your tabs whenever you need them. Here’s a quick short-cut key to find what you need quickly.
Here’ s some SQL logic to give you all database info such as Server Name, Database Name, Size, Age, Recovery Model, including data and log file information. This isn’t that difficult to […]
Here’s some quick SQL logic that shows the Compatibility_Level with the type of support from the different SQL Versions out there. Feel free to check Microsoft Documentation to verify found here: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level
To skip directly to the download… The Download is available as .doc All you need to do is drop the .doc extension, and load up the .vssettings file. Here you go: https://mikesdatawork.wordpress.com/2017/07/07/dark-ssms-theme-ssms-2017/