Leveraging SQL Server Database Schema
I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th. My session is on how to leverage predictive analytics to reduce customer churn. I will be going over how I leveraged a decision tree model to create a customer risk score for active customers.… Read more
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… Read more
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… Read more
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… Read more
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… Read more
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same result set. EXCEPT returns the records from the query on the left that are not found in the right query. INTERSECT returns the distinct rows that are in… Read more
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… Read more
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… Read more
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression. For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if it exists or the SellStartDate if the SellEndDate is null. Read more
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number() function. You can use this function to return a sequential number in your result set that begins at 1.
There are 2 arguments that can be passed into the… Read more
SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have never used the Azure portal it can be a bit challenging to get started. This post will show you how the steps required to create an Azure SQL Server… Read more
SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within your database is critical to the performance of your applications. One tool you can leverage to see what is happening are the built in reports in SSMS. SQL Server… Read more
Why Use a SQL Server Table Partition
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making the most… Read more
Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a query. For example, the AdventureWorks [sales].[salesorderdetail] table has 121,317 rows loaded in sequential order starting with SalesOrderDetailID 1. By Using a top 1000 clause I can limit the results… Read more
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the data in the warehouse is different from the incoming source data. One method to do this is to create a SQL Server CHECKSUM column in the data warehouse table…
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the duration of the query. CTE’s can be used for recursive queries, creating a view on demand and referencing the same table multiple times in the same query. CTE’s make… Read more