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”

Example of Encrypting and Decrypting a String into a SQL Table Using ASP.NET

I’ve put together this article because even after a lot of searching, I wasn’t able to find a simple, working example of how to encrypt and then decrypt a string that you are saving in your database in ASP.Net. Sure, there are some partial examples, but partial code usually doesn’t answer the question properly. Added to that, a lot of examples are out there that plain don’t work, confusing the issue and wasting a lot of time. So in this article I’ll give an example of a fully working test Web page that saves an encrypted string to a SQL Server database table, and that also shows the decrypted field back to the user.

Continue reading “Example of Encrypting and Decrypting a String into a SQL Table Using ASP.NET”

T-SQL to Enforce Proper Case Capitalization

Capitalize the First Letter of Each Word
Capitalize the First Letter of Each Word

This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make sure that the first letter of each word is capitalized. Continue reading “T-SQL to Enforce Proper Case Capitalization”