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
How To Delete Old Backup Files With TSQL And Powershell
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 […]
Mikes SSMS 2016 Dark Theme (Updated to SSMS 2017)
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/
Automatically Add FireWall Rule For SQL Server
Here’s some SQL logic that checks for the most recent SQL instance created, and automatically adds a port firewall rule. This isn’t too terribly hard to do on it’s own, but anything […]
Automatically Install And Create SQL Instances
The following logic will produce an SQL Server 2014 unattended installation configs file (.ini). Then it will execute the installation using the config file. Remember to change the following lines accordingly. 1. […]
How to install SQL Server 2016 Developer Edition
How to install SQL Server 2016 Step 1: Mount the SQL Server 2016 ISO. Step 2: Right-click and select ‘Run as Administrator’. Step 3: Select ‘Installation’ on the left pane, and click […]
Automatically Generate SQL Instance Name For Unattended Config File
If you’re looking to create an unattended installation process, and want to concatenate your own parameters into the configuration file; then here is one way you can do it. There are a […]
How To Download SQL Server 2016
How To Download The SQL Server 2016 Eval Edition Go to Microsoft, and download the evaluation edition for SQL Server 2016. Note: You must first register before you can get to the […]
Add All SQL Instance Ports To Firewall
Here’s some SQL logic that extrapolates all instances ports, and creates a nifty netsh command so you can add those ports to the firewall with a display name of "SQL Instance MyInstanceName". […]
Get All Instance Ports In SQL Server
Save a bunch of clicks with this SQL logic. This will find all the ports for each SQL Server instance installed on your multi-instance SQL Server. This logic assumes the default port […]
Get Number Of Cores In SQL Server
From time to time you’ll need to visit your license costs, and to do so you’ll need to run some queries against sys.dm_os_sys_info so you can get the number of cores for […]
Automatically Create Instance Names
Here’s some SQL Logic to get a list of all instance names, and automatically create the next instance name. In this environment I have several installations of SQL Server. I want to […]
Get List Of SQL Instances Installed
Here’s some quick SQL logic to show you all the instances that are installed on a server. This is simple enough, but still super helpful when creating more automatic processes around a […]
View .bak Files Like Sys.Master_Files
Here’s some SQL logic that takes a folder path (filled with .bak files), and produces a result set similar to sys.master_files. Ok; so what does this do. This creates a few variable/temp […]
Recent Comments