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 &

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. 

Database Growth Events in SQL Server
February 23, 2019
Database Growth Events in SQL Server

When a database file gets full and it needs more space, a growth event will happen. The size of said database growth can be set within the database options, or can be done using the ALTER DATABASE statement as shown below.