Often times you’ll need to check server or database server start times. In this example; there is a quick script that will show you 4 valid types of date types that can […]
Run this SQL Logic to determine if database ownership chaining is enabled. It checks both the engine configuration, and each database. Remember; some system databases cannot have the configuration set so I […]
If you have need to check if a column exists under System Tables (In this example we’ll look for the [containment] column which shows support for contained databases) here’s a quick bit […]
Want to quickly check to see if your Database Server has Replication configured? Try this little bit of SQL Logic.
If you’re a DBA like me you’ll probably have a local database instance on your workstation so that you can run a variety of tests quickly on whatever project you’re working on. […]
Here’s some simple logic to get you the database name, data, log, size, and file path for all your data files. [end]
This is dark theme I created for SSMS 2017 Once you download it; you’ll need to remove the .doc Mikes Dark SSMS Theme (SSMS 2017) https://mikesdatawork.files.wordpress.com/2017/07/mikes_2017_ssms_fonts_and_colors-vssettings.doc
This little bit of SQL Logic will allow you to search for a value across all tables and columns. This is serves as an expansion on Vyaskn’s search script (http://vyaskn.tripod.com). This will […]
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 […]
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/