SQL Server: Date and Time Data Types (Size and Ranges)

hnrsj

Thank you for this reference, whomever made this chart!

Tip: DateTime2(3) has the same number of digits as DateTime but uses 7 bytes of storage instead of 8 bytes (SQLHINTS- DateTime Vs DateTime2).

Advertisements

How to Send an Email from PowerShell

via How to Send Email From the Command Line in Windows (Without Extra Software)

Thanks! Handy little script!

$EmailFrom = "yourgmailadress@gmail.com"
$EmailTo = "destination@somedomain.com"
$Subject = "The subject of your email"
$Body = "What do you want your email to say"
$SMTPServer = "smtp.gmail.com"
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
$SMTPClient.EnableSsl = $true
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential("user", "password");
$SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body)

Windows 10 Gets a Cloud Reset Feature, Here’s How it Works

via Windows 10 Gets a Cloud Reset Feature, Here’s How it Works

Um.. no. That’s too much control out of the user’s hands.

“With Cloud Recovery, Microsoft wants to make the process of recovering a corrupted installation of Windows 10 much easier by downloading a fresh copy of Windows files directly from Microsoft, without the need of Windows media.”

It would be a nice OPTIONAL feature to refresh your computer via streaming download, but it should be only the system files, and no personal files.. such as the Documents folder.

Thoughts?

The Ten Commandments of Logic

  1. Thou shalt not attack the person’s character, but the argument. (Ad hominem)
  2. Thou shalt not misrepresent or exaggerate a person’s argument in order to make it easier to attack. (Straw man fallacy)
  3. Thou shalt not use small numbers to represent the all. (Hasty generalization)
  4. Thou shalt not argue thy position by assuming one of its premises is true. (Begging the question)
  5. Thou shalt not claim that because something occurred before, it must be the cause. (Post hoc/False cause)
  6. That shalt not reduce the argument down to two possibilities. (false dichotomy)
  7. That shalt not argue that because of our ignorance, a claim must be true or false. (Ad ignorantum)
  8. That shalt not lay the burden of proof onto him that is questioning the claim. (Burden of proof reversal)
  9. Thou shalt not assume “this” follows “that” when there is no logical connection. (Non sequitur)
  10. That shalt not argue that because is premise is popular, therefore it must be true. (Bandwagon fallacy)

Use Verbose Boot Messages to Troubleshoot Windows Startup Problems

Info gleaned from Use Verbose Boot Messages to Troubleshoot Windows Startup Problems by Lowell Heddings.

sshot-2

Afterwards open “notepad.exe %SystemRoot%\ntbtlog.txt”.


Enable Verbose Service Startup/Shutdown Messages

  1. Open up regedit.exe
  2. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
  3. create a new 32-bit DWORD on the right-hand side named VerboseStatus, giving it a value of 1.
  4. Reboot.

Experimental demonstration of energy harvesting from the sky using the negative illumination effect of a semiconductor photodiode: Applied Physics Letters: Vol 114, No 16

This is some seriously cool technology!

via Experimental demonstration of energy harvesting from the sky using the negative illumination effect of a semiconductor photodiode: Applied Physics Letters: Vol 114, No 16