THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 7 (70 total posts) < 1 second(s)
  • re: Data Mining Algorithms – Association Rules

    Kevin, First of all, thank you for your kind comment. In SQL, you typically search for distinct combinations of items in the same transaction with either join or apply operator. I prefer apply. Bellow is an example that finds itemsets of size 1, 2, and 3. However, I would not recommend doing this in SQL - why would you reinvent the wheel? You ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 25, 2015
  • Data Mining Algorithms – Association Rules

    The Association Rules algorithm is specifically designed for use in market basket analyses. This knowledge can additionally help in identifying cross-selling opportunities and in arranging attractive packages of products. This is the most popular algorithm used in web sales. You can even include additional discrete input variables and predict ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 10, 2015
  • re: SQL Server 2014 Upgrade Technical Guide

    When I click the link from the post, it drives me directly to the 2014 guide and opens a PDF. Are you using the same link?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 2, 2015
  • re: Conferences 2015 Q1 and Q2

    And we started in Vienna:-)
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 1, 2015
  • Conferences 2015 Q1 and Q2

    In two days, I am starting my first conference trip for this year. Therefore, it seems to me it is high time to write down my plan for the first semester of this year. Of course, I m adding my food plan for each event:-) SQL Saturday #374 Vienna. On Friday, February 27th, I am having a full-day seminar Advanced Data Modeling Topics in ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 24, 2015
  • re: Data Mining Algorithms – an Introduction

    Thank you! Dejan
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 20, 2015
  • Data Mining Algorithms – an Introduction

    Data mining is the most advanced part of business intelligence. With statistical and other mathematical algorithms, you can automatically discover patterns and rules in your data that are hard to notice with on-line analytical processing and reporting. However, you need to thoroughly understand how the data mining algorithms work in order to ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 19, 2015
  • T-SQL Querying

    We are close to the publishing day of the T-SQL Querying book. Of course, like always in this series, the main author of the book is Itzik Ben-Gan. This time, besides me, Adam Machanic and Kevin Farlee are the coauthors. The information I want to share now is that you can get a substantial discount if you preorder the book today, Monday, February ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 16, 2015
  • re: Data Modeling Resources

    Thank you for an interesting resource!
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 2, 2015
  • SQL Server 2014 Upgrade Technical Guide

    If you plan to upgrade to SQL Server 2014, then this technical guide is a must. With 429 pages, it is a complete book, yet still available as a free download here. It covers all products and features in the SQL Server suite, and upgrades from versions 2005, 2008, 2008 R2, and 2012. It supplements the information available in Books Online. Besides ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on January 13, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement