SQL Server Appendix Z

Digging into the fringe cases that didn't get a chapter in the SQL Server books...

SQL Server: Variables, Parameters or Literals? Or... Constants?

The age-old question "Should I use Variables, Parameters, or Literals in my code?" We've all seen...

Author: Jared Ko Date: 09/16/2013

SQLCMD and PowerShell: Generate 450 Million Names With 20 Lines of Code

(It's actually 487,861,706 names but it didn't seem like a good title). Skip to the solution. Note...

Author: Jared Ko Date: 03/03/2013

Hacking SQLCMD Mode: Introducing PowerShell

Disclaimer and a heartfelt thanks: Whenever possible, I will endeavor to give credit to people that...

Author: Jared Ko Date: 02/27/2013

SQL Server Management Studio: Hacking SQLCMD Mode

Notice: This article is geared toward people already familiar with SQLCMD mode in SQL Server...

Author: Jared Ko Date: 02/23/2013