THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » business intelligence   (RSS)
Showing page 1 of 8 (73 total posts)
  • 24 Hours of PASS (June 2014): Recordings Now Available!

    Sessions of the event 24 Hours of PASS: SQL Server 2014 (which was held on last June at 25th and 26th) were recorded and now they are available for online streaming!   If you have missed one session (in particular) or the entire live event, you can view it or review your preferred sessions here. What could you aspect from the next PASS ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on July 8, 2014
  • Updateable Column Store Indexes in SQL Server 2014

    Introduction Column store indexes had been released with SQL Server 2012 to optimize data warehouse workloads that have specific patterns, data are loaded through T-SQL scripts or through SSIS packages, several times a day, in any case the frequency is not important, only that the available data is loaded in the same execution. At the end of ETL ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 16, 2014
  • 24 hours of PASS is back!

    The most important free on-line event on SQL Server and Business Intelligence is back! The 24 Hours of PASS is coming back with a great edition fully based on the new features of SQL Server 2014. Register now at this link. No matter from what part of the world you will follow the event, the important thing is to know that it will be 24 ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 5, 2014
  • Indexing, Querying and Analyzing Text with SQL Server 2012-2014

    It is hard to imagine searching for something on the Web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 7, 2014
  • Fraud Detection with the SQL Server Suite Part 5

    This is the fifth, the final part of the fraud detection whitepaper. You can find the first part, the second part, the third part, and the fourth part in my previous blog posts about this topic. The Results In my original fraud detection whitepaper I wrote for SolidQ, I was advised by my friends to include some concrete and simple numbers to ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on January 6, 2014
  • Fraud Detection with the SQL Server Suite Part 4

    This is the fourth part of the fraud detection whitepaper. You can find the first part, the second part, and the third part in my previous blog posts about this topic. Data Mining Models We create multiple mining models by using different algorithms, different input data sets, and different algorithm parameters. Then we evaluate the models in ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on December 10, 2013
  • PASS DW/BI Virtual Chapter Upcoming Sessions (December 2013)

    Let me point out the upcoming live events scheduled for December 2013 organized by PASS Business Intelligence Virtual Chapter.   Create and Load a Staging Environment from Scratch in an Hour with Biml Date: Thursday 12 December Noon PST / 3 PM EST / 8 PM GMTSpeaker: Scott CurrieURL: ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 6, 2013
  • PASS Business Intelligence Virtual Chapter Upcoming Sessions (November 2013)

    Let me point out the upcoming live events, dedicated to Business Intelligence with SQL Server, that PASS Business Intelligence Virtual Chapter has scheduled for November 2013.   The ''Accidental Business Intelligence Project Manager'' Date: Thursday 7th November - 8:00 PM GMT / 3:00 PM EST / Noon PSTSpeaker: Jen StirrupURL: ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 2, 2013
  • Data Mining Resources

    There are many different types of analyses, each one with its own pros and cons. Relational reports have a predefined structure, and end users cannot change it. They are simple to use for end users. Reports can use real-time data and snapshots of data to show the state of a report at specific points in time. One of the drawbacks is that report ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on October 10, 2013
  • SQL Rally Pre-Con: Data Warehouse Modeling – Making the Right Choices

    As you may have already learned from my old post or Adam’s or Kalen’s posts, there will be two SQL Rally in North Europe. In the Stockholm SQL Rally, with my friend Thomas Kejser, I’ll be delivering a pre-con on Data Warehouse Modeling: Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to ...
    Posted to Davide Mauri (Weblog) by manowar on October 9, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement