Have you ever received an email like below and then got a big pain in your stomach? Disk E: is running out of room and you need to move one of your user database files before you totally fill the disk. Yes, your VM admin might be able to add disk space but they are out sick or this is a physical machine and you need to order bigger disks and you need to make this change right now.
When you look at your data, do you see a mish mash of formats? Do some people use camel case, some all lowercase, some upper? Here is a quick script that you can use to capitalize the first letter in your single word strings.
On 2/4/2017 I went to my third SQLSaturday hosted at Hyland Software in Westlake, OH. What is SQLSaturday? From their site: “SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.” http://www.sqlsaturday.com/