command line
-
Quickly open the command line to a specific path from Windows Explorer
Today's tip is an easy one to use and a very handy tip for quickly opening the command prompt to the location you're currently in on Windows Explorer. All you have to do is type 'cmd' into the Windows Explorer address bar and it will open the command prompt for you with the path already prefilled in.
-
How to auto update your Windows programs using Chocolatey
If you're sick of manually updating your Windows programs it turns out that there's a package manager that can automate it all for you: https://chocolatey.org - and best of all, it comes with silent installations! No more "next, next, finish".
-
Import a large .sql file into SQL Server using the command line
A lot of the time we deal with small databases with small data. Importing a backup database is usually ok for these databases using the SQL Server Management Studio. We would normally just open the .sql file we want to import in Management Studio and then click on the Execute button to import it into a new or existing database. Sometimes this just isn't possible. Large databases or big tables mean that the overhead required for SQL to parse and run the scripts just isn't possible.