Category: Microsoft
Install sqlcmd on Mac OS X
In case you need to run SQL Server scripts from your Mac, do the following to install (NOTE: I use HomeBrew.): From the terminal, type: brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release ACCEPT_EULA=y brew install –no-sandbox msodbcsql mssql-tools You should see something like in the screenshot. Type “YES” if prompted and be on your way. Once done, type:…
rsync: Exact copy command
I purchased a new 4 TB external hard drive and backed up about 1 TB from an older 2 TB external. I wanted to preserve the dates and permissions, so rsync was perfect. Adding the command I used, so I can look it up next time. rsync -ravh <source> <target> Ref: http://www.tecmint.com/rsync-local-remote-file-synchronization-commands/
Highlight Text In Powerpoint: 5 Creative Ideas
Archiving this link as I will definitely use need this in the future. Highlight Text In Powerpoint: 5 Creative Ideas.
Firefox: “You are not authorized to view this page” when connecting to intranet
In case you get the error below when connecting to your Windows-based intranet using Firefox, here’s the fix: 1. In your toolbar, type “about:config 2. Search for “network.negotiate-auth.allow-insecure-ntlm-v1” and set it to “true 3. That’s it. When you access the site, it will now ask you to enter your domain creds You are not authorized…
Excel: Insert multiple rows every other row
The key is to use a macro. To do so, hit Alt+F11, then create a new macro and add the code below. Once added, select the worksheet you’d like to process, change the “17” below (1 if to process all rows), then run it. That’s it. Sub Insert_Blank_Rows() Dim Last As Integer, oRow As…
Configure IIS to allow downloading .dat files
Note: This is for IIS 6.0. Open IIS Manager. Browse to the IIS Site or subfolder where the .DAT files are Right-click on that site or subfolder and select Properties Select the HTTP Headers tab Click on the MIME Types button In the extension box, type ".dat” In the MIME Type box, type "application/octet-stream" Click…