Tested on server version: SQL Server 2016 Developer Edition Reference info accurate on: January, 2018 was wanting to make THIS stored procedure:
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
SQL Server for Dummies Series
This book is incredibly well laid out and exceptionally easy to read and follow. Whereas other books seem to try to make the author appear smart and are therefore hard to read, this book is different.
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
You Might Have Ordered from the Wrong Place When…
About a month ago, I saw someone post about a website called TMART.com. It's kinda like KMart, except it has a ton more tech. Maybe that's what the T is for, but I digress. I was instantly attracted to it like an insect to a porch light... drawn in by amazing prices on practically everything...
My Pick for 2018 Best App to Download Videos from Any Website
First off, let me say that I'm never paid to promote anything, so what I say is the gospel according to Rick. Sometimes I join an affiliate program so that maybe someday I'll see some green, but so far, I haven't seen a dime so please, know that you can rely on what I'm telling you. Now... I've had a love-hate relationship with my pick for the 2018 Best App For Downloading VIdeos from Websites and it is...