Mike Wilmot

mwilmot

Check me out on the web at Wall Street Stock Market Desktop and Financial News or at my blog.

Niner since 2009

SQL Server Technical Specialist, MSFT

Posts
Comments

20 minutes, 25 seconds

SQL 2012 AlwaysOn Availability Groups
Apr 03, 2013 at 4:24 AM 1 Mike Wilmot

Avg Rating: 1

(1)

What are SQL Server 2012 AlwaysOn Availability Groups and how can they help you with a HA/DR Strategy.
33 minutes, 23 seconds

SQLShorts: Big Data and Twitter
Dec 17, 2012 at 9:46 PM 0 Mike Wilmot

Avg Rating: 5

(1)

StreamInsight is a SQL Server Complex Event Processing Engine (.NET) that can be leveraged for manufacturing or financial applications. It can manage and mine data for different trend, conditions virtually instantaneously. A practical application is to stream Twitter data to StreamInsight and analyze...
14 minutes, 19 seconds

SharePoint 2013 BI
Sep 25, 2012 at 7:24 AM 2 Mike Wilmot

Avg Rating: 0

How to create modern BI solutions using Microsoft SharePoint 2013, PowerPivot and Power View in Excel 2013.
26 minutes, 10 seconds

StreamInsight
Jun 08, 2012 at 9:50 AM 1 Mike Wilmot

Avg Rating: 4

(1)

Microsoft StreamInsight™ is a powerful platform that you can use to develop and deploy complex event processing (CEP) applications. Its high-throughput stream processing architecture and the Microsoft .NET Framework-based development platform enable you to quickly implement robust and highly efficient...
10 minutes, 39 seconds

SQLShorts: SQL 2012 Power View on SharePoint 2010
Jan 16, 2012 at 9:30 PM 0 Mike Wilmot

Avg Rating: 0

Overview of the Power View feature of SharePoint 2010 SP1.
Here is a brief description from :
http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx
Power View, a feature of Microsoft SQL Server 2012 Release Candidate 0 (RC 0) Reporting Services Add-in for Microsoft...
48 minutes, 51 seconds

SQLShorts: Installing and Configuring PowerPivot, Power View, and the BI Semantic Model ( BISM )…
Jan 14, 2012 at 6:51 PM 13 Mike Wilmot

Avg Rating: 3.5

(2)

This video covers the main issues that you face in installing PowerPivot and Power View on SharePoint 2010 SP1. There are many nuances to address such as software needed for the install, configuration options, installation order, etc... This video covers installation using SharePoint 2010 SP1,...
15 minutes, 10 seconds

SQLShorts : AlwaysOn Availability Group Configuration for SQL 2012
Dec 13, 2011 at 10:51 AM 1 Mike Wilmot

Avg Rating: 5

(1)

Today's SQLShort is on how to configure SQL 2012 Availability Groups and some gotchas.
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one...
4 minutes, 6 seconds

SQLShorts: SQL 2012 Apollo Column Store
Dec 10, 2011 at 12:23 PM 0 Mike Wilmot

Avg Rating: 0

The SQL Server columnstore index feature, code-named Apollo, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012, code-named "Denali", in many cases by a factor of 10 to 100.

http://social.technet.microsoft.com/wiki/contents/articles/sql-server-columnstore-index-faq.aspx
...
11 minutes, 0 seconds

SQLShorts: PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview
Dec 10, 2011 at 12:23 PM 0 Mike Wilmot

Avg Rating: 5

(1)

This video is a demo of a full lifecycle of the BI Semantic Model (BISM) starting with PowerPivot and ending with Power View in SQL Server 2012.
4 minutes, 46 seconds

SQLShorts : AlwaysOn Availability Groups for SQL 2012
Dec 09, 2011 at 11:52 AM 0 Mike Wilmot

Avg Rating: 0

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to four sets of corresponding secondary databases. An availability group fails over at...