SQL Server useful but less known features
-
Checking who is connected to the database
sp_who
sp_who
Inspired by spring cleaning of a collection of "New Text Document (n).txt" files on my desktop I decided to prepare a collection of git useful scripts, yet another. Here is the list:
To fix:
Get-AppXPackage -AllUsers | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register "$($_.InstallLocation)\AppXManifest.xml"}
Having a home media centre PC (categorised as such because it's connected to a TV instead of a monitor) which is always on, from time to time I need to remote in to it and only Server editions of Windows allow a user to be logged in both locally and remotely at the same time.
As far as I know there are 2 ways to correct this:
After a clean install of Windows 7 for the sole purpose of upgrading it soon after to Windows 10 I've encountered an interesting Windows Update issue: Windows Update screen became stuck on "Checking for updates..." message.
Issue was already reported in many places, for many different Windows versions but none of the solutions worked for me except the following:
Recently I received my PS4 which I sniped on eBay as being for spares and repair. Sometimes, just sometimes spares means power cable is not working due to a blown fuse or there is a software failure which after hard reset returns back to life.
Not this time.
Today I finished a Drupal commerce online store I worked on for some time. Not really finished - no website can be fully finished as either it's data security will deteriorate over time or content value will decrease or will become irrelevant technologically and the way information is presented will become obsolete (language evolution? augmented reality? mind melt?).
For now it's all right, check it out: gift & art.
All it takes is to create the following PowerShell script (text file with .ps1 extension) and changing $server and $db variables to match the server's host and instance name (SERVER\INSTANCE) and a database name.
Here is a short list of steps involved.