HASSUG BI Developer Presentation on 7/14/2015

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG).  This session resulted from feedback we received in the user group on differences between database developers and BI developers.  If you are interested in seeing the presentation content it is uploaded here: Becoming a bi developer from … [Read more…]

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…]