Minutes on BI

This is my Business Intelligence centric blog.

Zero Milli Seconds Disk Latentcy

Lately I done a performance lab where finding the limits of an existing SQL Server 2012 based...

Author: Lars Zimmermann Date: 04/23/2014

Visual Studio Evolution 2013 – die Fachkonferenz zu Visual Studio und .NET

Visual Studio Evolution 2013 – die Fachkonferenz zu Visual Studio und .NET Nach dem Erscheinen...

Author: Lars Zimmermann Date: 10/09/2013

Performance Guidance for SQL Server in Windows Azure Virtual Machines

Authors: Silvano Coriani, Jasraj Dange, Ewan Fairweather, Xin Jin, Alexei Khalyako, Sanjay Mishra,...

Author: Anonymous Date: 05/31/2013

SSIS Tips Tricks and Best Practices: SSIS Operational and Tuning Guide

SSIS Operational and Tuning Guide SQL Server Technical Article Writer: Alexei Khalyako, Carla...

Author: Anonymous Date: 01/02/2013

SSIS Tips Tricks and Best Practices: SSIS for Azure and Hybrid Data Movement

SSIS for Azure and Hybrid Data Movement SQL Server Technical Article Writer: Alexei Khalyako, Carla...

Author: Anonymous Date: 01/02/2013

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups

Authors: Joseph Sack (SQLskills.com), Sanjay Mishra (Microsoft) Technical Reviewers: Min He...

Author: Anonymous Date: 06/22/2012

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

Authors: Joseph Sack (SQLskills.com), Sanjay Mishra (Microsoft) Technical Reviewers: Lindsey Allen...

Author: Anonymous Date: 06/22/2012

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

Writer: Cephas Lin (Microsoft) Contributors: Sanjay Mishra (Microsoft), David Smith (ServiceU...

Author: Anonymous Date: 04/04/2012

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Writer: LeRoy Tuttle, Jr. (Microsoft). Contributors: Cephas Lin (Microsoft), Justin Erickson...

Author: Anonymous Date: 02/25/2012

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

Writers: Mike Weiner, Sanjay Mishra, Min He Contributors: Lingwei Li, Mike Anderson (EMC...

Author: Anonymous Date: 12/22/2011

Analysis Services 2008 R2 Performance Guide

Writers: Thomas Kejser and Denny Lee Editor: Beth Inghram Contributors and Technical Reviewers:...

Author: Anonymous Date: 10/10/2011

Optimizing SQL Query for Select Max(Column) from ...

To get the maximum, minimum or other aggregate value value out of a table a simple query is written:...

Author: Lars Zimmermann Date: 09/06/2011

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3

Writers: Ed Katibah (Microsoft) and Milan Stojic (Microsoft)Technical Reviewers: Marko Tintor...

Author: Anonymous Date: 08/08/2011

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

Authors: Mike Ruthruff, Xin Jin, Serdar Sutay Contributors: Tom Brown (DBBest Technologies), Guy...

Author: Anonymous Date: 08/01/2011

Slipstreaming SQL 2008 with SP2

Though there are lot of articles on how to slipstream a SQL 2008 Setup with a Service Pack for...

Author: Lars Zimmermann Date: 07/14/2011

Server Performance Analysis

A colleague just asked me about how to diagnose performance issues of a system. And as always when...

Author: Lars Zimmermann Date: 07/12/2011

Diagnosing and Resolving Spinlock Contention on SQL Server

Authors: Mike Ruthruff, Ewan Fairweather Contributors: Fabricio Voznika, Jack Richins, Thomas Kejser...

Author: Anonymous Date: 07/05/2011

Diagnosing and Resolving Latch Contention on SQL Server

Authors: Ewan Fairweather, Mike Ruthruff Contributors: Thomas Kejser, Steve Howard Technical...

Author: Anonymous Date: 07/05/2011

SQL Server 2008R2 Analysis Services Operations Guide

Authors: Thomas Kejser, John Sirmon, and Denny Lee Contributors:Bilal Obeidat, John...

Author: Anonymous Date: 06/01/2011

Microsoft iSCSI Software Target 3.3

You can use Microsoft iSCSI Software Target 3.3 especially if you build Failover Cluster on HyperV...

Author: Lars Zimmermann Date: 06/01/2011

Working with BigInt DateTimeID effectivly

In many cases the fact table of a data warehouse has to be queried for a specific date range using...

Author: Lars Zimmermann Date: 05/20/2011

Working with DateTime Dimension in SSAS

Using the DateTime Dimension as created in my previous post here come a description on how to use...

Author: Lars Zimmermann Date: 05/20/2011

SSAS - Creating and filling the DateTime Dimension

The following describe how to create a DateTime Dimension Data Warehouse table, and prefill it with...

Author: Lars Zimmermann Date: 05/20/2011

SQL Server Replication: Providing High Availability using Database Mirroring

Writer: Gopal Ashok (Microsoft Corporation), Paul S. Randal (SQLskills.com)Technical Reviewers:...

Author: Anonymous Date: 04/07/2011

REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter

Authors: Michael Anderson, Denny Lee, Dennis Dewitt Contributors:Bilal Obeidat, John...

Author: Anonymous Date: 03/14/2011

FILESTREAM Design and Implementation Considerations

Writer: Shaun Tinline-Jones Technical Reviewer: Prem Mehra, Chuck Heinzelman, Nicholas Dritsas,...

Author: Anonymous Date: 02/22/2011

Using SQL Server PowerPivot for Excel to Analyze SAP Data

Writers: Scott Cameron (Hitachi Consulting), Chunhui Zhu, Denny LeeTechnical Reviewers: John...

Author: Anonymous Date: 01/26/2011

Using SQL Server Integration Services and StreamInsight Together

Writer: Ping Wang, Wee Hyong Tok, Alexei Khalyako, Xiaoyan Zhao, Renhe Li, Igor GrinevTechnical...

Author: Anonymous Date: 01/11/2011

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1

Writers: Ed Katibah (Microsoft) and Milan Stojic (Microsoft) Technical Reviewers: Michael Kallay...

Author: Anonymous Date: 11/09/2010

Failure Is Not an Option: Zero Data Loss and High Availability

Author: Thomas H. Grohser, SQL Server MVP Contributors: Lindsey Allen, Sanjay Mishra Published:...

Author: Anonymous Date: 11/02/2010

High Availability and Disaster Recovery for Microsoft’s SAP Data Tier: A SQL Server 2008 Technical Case Study

Writers: Joseph Sack, Eric Holling, Sanjay Mishra Contributors: Juergen Thomas, Elke Bregler...

Author: Anonymous Date: 10/29/2010

Edgenet Realizes the Power of Dynamic IT and Self-Service BI

Author: Carl Rabeler Contributor: Steve Hord Reviewers: Robert Bruckner, Kevin Cox Dynamic IT and...

Author: Anonymous Date: 10/15/2010

SQL Server High Availability and Disaster Recovery for SAP Deployment at QR: A Technical Case Study

Writer: Danny Tambs Contributors: Sanjay Mishra Technical Reviewers: Prem Mehra, Juergen Thomas, Tim...

Author: Anonymous Date: 09/20/2010

PowerPivot for SharePoint - Existing Farm Installation

Writers: Leon Cyril, Dave Wickert, Denny Lee Technical Reviewers: Lee Graber, Jennifer Chu, Kathy...

Author: Anonymous Date: 09/07/2010

PowerPivot for SharePoint: Single Server Installation

Writers: Leon Cyril, Dave Wickert, Denny Lee Technical Reviewers: Lee Graber, Jennifer Chu, Kathy...

Author: Anonymous Date: 08/30/2010

Analysis Services ROLAP for SQL Server Data Warehouses

SQL Server Technical Case Study Writers: Denny Lee, Kay Unkroth Investigators: Denny Lee, Thomas...

Author: Anonymous Date: 08/23/2010

PowerPivot Technical Diagram: PowerPivot Security Architecture

Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL...

Author: Anonymous Date: 08/17/2010