In case you need to run SQL Server scripts from your Mac, do the following to install (NOTE: I use HomeBrew.):
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
ACCEPT_EULA=y brew install --no-sandbox msodbcsql mssql-toolssqlcmd
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/
Archiving this link as I will definitely use need this in the future.
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 to view this page
You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept.
Please try the following:
Contact the Web site administrator if you believe you should be able to view this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.2 – Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Authentication, and About Custom Error Messages.
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 Integer
‘Count and select rows to process
Last = Range("A" & Rows.Count).End(xlUp).row
’17 is the last row to process (at the top)
For oRow = Last To 17 Step -1
If Not Cells(oRow, 1).Value = "" Then
‘Copy the line below to as many row insert you need
‘in this case, it was 3 row inserts
Cells(oRow, 1).EntireRow.Insert
Cells(oRow, 1).EntireRow.Insert
Cells(oRow, 1).EntireRow.Insert
End If
Next oRow
End Sub