sqlcmd in SQL Server
October 1, 2019
sqlcmd in SQL Server

The sqlcmd utility allows SQL to be run at the command prompt over ODBC (Version 17.3+ allows Azure connectivity). This tool comes with SSMS, or separate Windows &

Read More
Changing Schemas SQL Server
September 30, 2019
Changing Schemas in SQL Server

This is a post on moving tables from one schema to another in SQL Server. A semi-rare task for myself, although it could be more frequent for those who use schemas for things like staging tables/versioning. 

Read More