Steps Restore a SQL Server Database into a New Database and Rename it

If you want to create a working backup of one of your production databases that you can use without jeopardizing the production data, you’ll need to copy the database in its entirety to a new name. In this article I’ll review the steps you need to use to do this (in SQL Server Management Studio 2014).
Also, if you find this article helpful, feel free to check out the other articles on my site covering various SQL examples at: https://jwcooney.com/category/sql/

Continue reading “Steps Restore a SQL Server Database into a New Database and Rename it”

ClosedXML Nicely Formatted Header Row

Nice Header Row in Excel
Nice Header Row in Excel

In this article I’ll show a simple example of nicely formatting a header row in a generated Excel document (using the open source ClosedXML library).

If you would first like some background into setting up and calling functions using .Net and the ClosedXML library, have a look at a previous article I wrote, or visit my site (jwcooney.com) and browse the available categories. Continue reading “ClosedXML Nicely Formatted Header Row”

Thoughts About Desktop Shortcuts to Web Sites in Windows 10

MS Windows 10
MS Windows 10

If you have sites that you access routinely (like my site: http://jwcooney.com), then you’ll likely want a quicker solution to opening up the browser of your choice and then¬†searching through your bookmarks for the site you want to go to. It’s often easier just to directly type the URL into your browser than using awkward bookmarks. Luckily you have a few options in Windows 10. Continue reading “Thoughts About Desktop Shortcuts to Web Sites in Windows 10”