SQL

SQL Server 2016 preview

Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world.  The next major release of Microsoft’s…


Data Type Conversion

When combining Data Types it is important to note that there is a data type precedence used to determine how they are converted and combined….


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…