T-SQL HOST_ID and HOST_NAME

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...

2015-04-20

3,066 reads

SQL Server 2014 Deprecated Features

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...

2015-03-19

1,440 reads

SQL Saturday #408 Houston – June 13th 2015

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Call for speakers is now open for SQL Saturday #408 in Houston, TX.  If you are interested in presenting please...

2015-03-13

891 reads

Azure Data Factory

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing.  It allows...

2015-03-10

1,375 reads

T-SQL EXCEPT and INTERSECT

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...

2015-03-03 (first published: 2015-02-23)

8,779 reads

T-SQL UNION Set Operator

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

T-SQL UNION
Set operators allow you to combine data from two or more queries and return the results in a single...

2015-02-13 (first published: 2015-02-04)

8,531 reads

SSRS Farm to Scale-Out Performance

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

SSRS Farm Overview
Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and...

2015-01-26

1,237 reads

T-SQL Random Numbers using RAND() for Test Data

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...

2015-01-12

1,231 reads

T-SQL COALESCE Example

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...

2014-12-30 (first published: 2014-12-26)

8,850 reads

ROW_NUMBER SQL Server

• by Derek Wilson

• Business Intelligence and Enterprise Architecture

Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number()...

2014-12-22 (first published: 2014-12-16)

8,818 reads