Category: Tip
-
Search through stored procedures in SQL Server for a specific string of characters
While I have experience in designing and programming SQL databases, I don’t often deal with databases or SQL directly at work. Every so often, I find I need a nice query for doing something very specific within the SQL Server environment. Today I needed to find a specific column that was being used in our…
-
Seagate hard drive format capacity fix
Recently, I’ve just built a nice little media server with loads of storage. Six Seagate Barracuda (7200.11 ST31500341AS) 1.5TB hard drives and one Western Digital Green (WD15EADS) 1.5TB drive as a hot spare. I’ll divulge more information on the media server another time. Unfortunately, one of the Seagate drives was only able to format 465GB,…