T-SQL HOST_ID and HOST_NAME

HOST_ID and HOST_NAME Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement.  You can use this to record what workstation the transaction came from in your application or business intelligence processes. HOST_ID will return the Process ID from the client  machine that is running the … [Read more…]

SQL Server 2014 Deprecated Features

SQL Server 2014 Deprecated Features – Database Engine Everyone looks at the new features when trying to determine when to upgrade from an older version of SQL Server to a newer release.  There are many factors to consider and for every environment certain features have a higher priority and need for implementation than others.  However, … [Read more…]

SQL Saturday #408 Houston – June 13th 2015

Call for speakers is now open for SQL Saturday #408 in Houston, TX.  If you are interested in presenting please fill out the form – https://www.sqlsaturday.com/408/callforspeakers.aspx.  The call for speakers ends on 4/14/2015. For complete details on the event see – https://www.sqlsaturday.com/408/eventhome.aspx. SQLSaturday is a training event for SQL Server professionals and those wanting to … [Read more…]

Azure Data Factory

What is the Azure Data Factory? The Azure Data Factory is a managed service for data storage and processing.  It allows you to build cloud based solutions to move and store your data in a centralized managed environment.  Source data can be pulled from on premise or cloud environments consisting of structured, unstructured or semi-structured … [Read more…]

SSRS Farm to Scale-Out Performance

SSRS Farm Overview Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and 2014.  SQL Server allows for the deployment of 2 or more servers running SQL Server Reporting Services to increase the performance of your reporting environment. SSRS stores its data in 2 databases (reportserver and … [Read more…]

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

T-SQL Random Numbers using RAND() SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1 of float datatype.  To create a random number execute Select Rand(), in my example it returned .0131039082850364.  If I wanted to always return the same number I can include a seed value, such as … [Read more…]