SQL

SQL Server Categories

The Transact-SQL language is split up into four SQL Categories Data Manipulation Language (DML) – These statements allow you to manipulate the data within your tables….


SQL Server 2016 Public Preview

SQL Server 2016 public preview now available! Three weeks ago at Microsoft Ignite the next major release of Microsoft’s flagship database and analytics platform was announced….


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…