Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Johan Åhlén

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2016/10/18 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 1,865 reads

Generate a SSIS-package that reads from Twitter using Biml

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.  Read more...
Rating: |  Discuss |   Briefcase | 2,295 reads

Autogenerating SSIS file import packages using Biml

Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.  Read more...
Rating: |  Discuss |   Briefcase | 5,063 reads

Pulling real-time data from Twitter using StreamInsight

An example of building a StreamInsight input adapter for retrieving Twitter data in real-time.  Read more...
By Johan Åhlén 2010/09/29 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 8,644 reads

Getting started with StreamInsight

A quick-start to SQL Server StreamInsight and Complex Event Processing with a step-by-step example on stock quotes.  Read more...
By Johan Åhlén 2010/03/17 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 8,005 reads

What is StreamInsight and why does it matter?

An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.  Read more...
By Johan Åhlén 2010/01/25 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 7,960 reads

Building a Yahoo Finance input adapter for SQL Server StreamInsight

Step by step guide to building and debugging a SQL Server StreamInsight input adapter.  Read more...
By Johan Åhlén 2009/11/25 | Source: SQLServerCentral.com | Category: streaminsight
Rating: |  Discuss |   Briefcase | 6,653 reads

Improving Cube Performance with Precalculated Aggregations

A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.  Read more...
By Johan Åhlén 2009/11/04 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 6,032 reads
   Items 1 to 8 of 8