Paste your Google Webmaster Tools verification code here
BI and Predictive Analytics
  • About
    • About Me – Consulting Services
  • Keynote Speaking
  • Training
    • Recommended References
  • Community
  • Contact Derek Wilson

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Menu
  • Azure
  • Data Management
  • Data Mining References
    • Data Mining
    • RapidMiner
  • BIG Data
  • SQL Server References
    • BI
    • SQL Server
    • SQL Server Scripts
  • Enterprise Architecture

SQL Scripts

T-SQL EXCEPT and INTERSECT

February 23, 2015 by Derek Leave a Comment

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 both the right and left queries. … [Read more…]

Posted in: SQL Scripts, SQL Server On Premise Tagged: SQL Script, SQL Server, T-SQL

T-SQL UNION Set Operator

February 4, 2015 by Derek 1 Comment

T-SQL UNION Set operators allow you to combine data from two or more queries and return the results in a single set.  There are 3 set operators available T-SQL EXCEPT, INTERSECT and UNION. This article is focused on the UNION operator.  UNION is used when you need to combine data from multiple queries into a … [Read more…]

Posted in: SQL Scripts, SQL Server On Premise Tagged: SQL Script, SQL Server, T-SQL

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

January 12, 2015 by Derek 1 Comment

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

Posted in: SQL Scripts, SQL Server On Premise Tagged: SQL Script, SQL Server, T-SQL

ROW_NUMBER SQL Server

December 16, 2014 by Derek 1 Comment

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 function that determines how the … [Read more…]

Posted in: SQL Scripts Tagged: SQL Script, SQL Server

SQL Server Table Partition Example

November 3, 2014 by Derek Leave a Comment

Why Use a SQL Server Table Partition Data warehouses and data repositories often have tables that store millions of records and each day adding thousands more.  As the data ages, the older records generally require fewer updates.  If all of these records are kept in a single physical table.  Queries and maintenance on the table … [Read more…]

Posted in: Business Intelligence, SQL Scripts Tagged: SQL Script, SQL Server

SQL Server TABLESAMPLE

October 20, 2014 by Derek 1 Comment

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 to the first 1000 rows … [Read more…]

Posted in: Business Intelligence, SQL Scripts, SQL Server On Premise Tagged: SQL Script, SQL Server

SQL Server Checksum

October 14, 2014 by Derek Leave a Comment

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 and another on the incoming … [Read more…]

Posted in: Business Intelligence, SQL Scripts Tagged: SQL Script, SQL Server

Common Table Expressions (CTE)

October 3, 2014 by Derek Leave a Comment

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 your code more readable and … [Read more…]

Posted in: SQL Scripts Tagged: SQL Script, SQL Server

RSS CDO Advisors Blog

  • Enable Self Service Analytics in 8 Hours or Less
    Self Service Analytics in Bite Size Projects Executives today need answers quickly with data they can trust.  After working in companies and seeing the challenges of getting funding for business intelligence or data projects.  CDO Advisors has setup a new type of BI and Self Service Analytics solution, BI as a Service. Get projects done
  • How to Use Power BI Gradient Colors and Legend
    Enhance Power BI Gradient Colors and Legend in Your Reporting The July Power BI update included a gradient legend for visualizations using gradient colors.  Conditionally format your visuals to scale the color from light to dark to highlight important values with Power BI gradient colors.  In addition, you can add a third color to highlight
  • Why Power BI Healthcare Dashboards Improve Operations
    [fusion_builder_container hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” hundred_percent_height_center_content=”yes” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” margin_top=”” margin_bottom=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=””][fusion_builder_row][fusion_builder_column type=”2_3″ layout=”2_3″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none”

Recent Posts

  • Data Governance Policy
  • Text Mining Loch Ness Monster Sightings
  • What is RapidMiner
  • Azure Data Catalog
  • SQL Server 2016 Stretch Database

Categories

  • Azure (5)
  • Big Data (6)
  • Business Intelligence (24)
  • Community (4)
  • Data Management (1)
  • Data Mining (2)
  • Enterprise Architecture (22)
  • RapidMiner (2)
  • SQL Scripts (8)
  • SQL Server On Premise (26)
  • Training (8)
  • Uncategorized (2)

Archives

  • September 2016 (1)
  • February 2016 (1)
  • January 2016 (1)
  • September 2015 (1)
  • August 2015 (2)
  • July 2015 (2)
  • June 2015 (1)
  • May 2015 (1)
  • April 2015 (1)
  • March 2015 (3)
  • February 2015 (2)
  • January 2015 (2)
  • December 2014 (3)
  • November 2014 (2)
  • October 2014 (4)
  • September 2014 (3)
  • August 2014 (2)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (4)
  • April 2014 (3)
  • March 2014 (4)
  • February 2014 (4)
  • January 2014 (6)
  • December 2013 (5)
  • November 2013 (10)
  • October 2013 (11)

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Copyright © 2021 BI and Predictive Analytics.

Magazine WordPress Theme by themehall.com.