SQL

Date and Time Date Types

In this demonstration we will see how to work with the various datetime data types within in SQL Server. Prior to SQL Server 2008 we…


Integer Data Types

Here is some examples of the integer data types. When deciding on a integer for a column, variable, parameter or expression it is a wise…


Character Data Types

Regular Character Data Types – Both the char and varchar data types are considered regular or non-Unicode character data types where each alphanumeric character uses…


Guest Speaker – Brazil

Due to a cancellation, I was asked to be the Guest Speaker for the SQL Server User group in Recife, Brazil. As always I have attached…


Fast and Furious Dynamic SQL

Fast and Furious Dynamic SQL (Tuesday March 17th 2015) Presenter: Jay Robinson We all appreciate a well-defined and well-tuned stored procedure. But sometimes the problem…


SQL Saturday Pre-Conference Events

It’s Official we will have Four Pre-Conference Events on Friday August 7th the day before SQL Saturday.  New Horizons of Indianapolis host this all day event. Click…


SQL Server Exam Prep

Studying for your SQL Server certifications can be a daunting task, but Microsoft has just made it easier for you by offering a complete portfolio…


Call for Speakers

Dear SQLSaturday Speakers, SQLSaturday #402 is coming to you on Aug 08, 2015 at Indiana Wesleyan University North , 3777 Priority Way South Drive, Indianapolis,…


Working with Data Types

This is my Working with Data Types presentation for the SQL Saturday in Cleveland on February 7th, 2015. Some helpful links. Sample Code from Presentation…