SQL Server Content

Introduction to Microsoft SQL Server T-SQL

- 8 min read-Brian Alderman
Some businesspeople want to learn basic T-SQL to simply do their work better without having to get a developer involved. Brian thought a primer on the basics would serve this group well.

Managing and Optimizing SQL Server

- 10 min read-Brian Alderman
You can improve SQL Server performance and maintenance by paying attention and tweaking five key settings after the default installation is finished: system and database file locations, memory allocation, database default settings, the alias, and scheduled backups, including transaction log backups.