Announcing New Upcoming Material

This is to let you all know about the new posts that will be available in the coming weeks. Any kind of blog on TSQL would have to cover the basics of table creation. In addition, we will be covering simple TSQL queries as well as related TSQL queries and then finally stored procedures and functions:

1. Table Creation
2. Related Data
3. Simple TSQL queries
4. Related TSQL queries
5. Stored Procedures
6. Functions

The first four sections will really be in anticipation of the last two, Stored Procedures and Functions.

Stored Procedures are the most important part of database programming in my opinion. The reason why is this: If you have an app (phone/web/EXE) that is compiled and references a stored procedure in a database, you can always altered the stored procedure without having to re-compile your application. This is a huge benefit, but the import can be lost on even the sharpest of developers if they have not had a lot of experience with using stored procedures.

SQL SERVER COURSE - 95% OFF FOR OUR READERS

For those of you that would like to broaden your understanding of SQL Server, or if you work with someone who needs a little (or a lot of) help :), We are offering a huge discount to one of our most popular online courses. It is the lead off course which discusses tables - what to do and not do. It is very instructional, practical and straightforward.

Normally this course is $199.00, but for a limited time it is available through this offer for only $3.00!   Click the link below to get started:

SQL Server FAST TRACK - Course 101 - Tables