SQL Server Edit All Rows in SQL Server Management Studio
Change the default Select 1000 and Edit 200 rows in SQL Server to Select All Rows and Edit All Rows.
Windows 8 Tips Part 3 – Reduce your clicks
Windows 8 has definitely changed the way I interact with the OS. I find myself using more keyboard shortcuts than in the past. There are the usual suspects such as WinKey+D to take you to your desktop, WinKey+L to lock your PC, Alt+Tab to switch between open apps and WinKey+, to make all windows transparent so you can see your desktop. There are a ton of other keyboard shortcuts you can use to get around Windows 8 more easily.
The next nugget I stumbled across quite by accident, and I have since then seen a few blog posts about this quick menu. How can you access Programs and Features, System, Control Panel, Task Manager and many other often used locations in a snap? Move your mouse into the bottom left corner of your screen (you know, where your start menu used to be). You will see the following pop up:
Windows 8 Tips Part 2 – Shut down with one click
I love Windows 8. There, I said it. Right, now that that’s over with, lets get to the nitty gritty of the shut down sequence. WinKey+C -> Settings -> Power -> Select Shut down. Doesn’t that seem a bit drawn out?