Formatting Dates in T-SQL Using CONVERT with Style Codes

CodeProject Assume you've been asked to return a date stored as a datetime2 in a specific format using Transact-SQL. For SQL Server 2012+, one option is to use T-SQL's FORMAT() function. FORMAT() is used with either a .NET format string or a custom formatting string to determine the formatting that should be applied. Starting with … Continue reading Formatting Dates in T-SQL Using CONVERT with Style Codes

The C# Programming Language (Hardcover)

ISBN: 978-0-32-115491-0 By A. Hejlsberg, S.Wiltamuth, P. Golde Addison-Wesley CodeProject Written by the Microsoft employees who literally created the C# language,  this is still by far and away the best book I've read about the C# programming language. Even though it was published way back in 2003, it still trumps everything I've read that was … Continue reading The C# Programming Language (Hardcover)

Microsoft SQL Server 2016 – A Beginners Guide

ISBN: 978-1-25-964179-4 By Dusan Petkovic McGraw Hill Education $45.00 USD CodeProject I bought this book because I wanted a definitive, hard copy reference that covers the basics of SQL Server administration, performance tuning, replication, and of course, T-SQL. I was hoping the author would tap into his real world experience to offer insight into the … Continue reading Microsoft SQL Server 2016 – A Beginners Guide