Case sensitive strings in SQL Server
99 times out of 100, I’ve wanted case-insensitive strings in SQL Server. […]
Category: sql server
SQL Server GUID as Primary Key
There are a few use cases for using a GUID as a […]
Base 64 in SQL Server
Base 64 encoding is the process of converting bytes (8 bits) to […]
SQL Server Table Valued Parameters with .NET
private static SqlDataRecord CreatePersonRecord(int id, string name) { var metaData = new[] […]
Drop SQL Server Database
If you’re working locally, building a new app from scratch, you might […]
SQL Reseed Identity
If you need to manually insert a value into an identity column, […]