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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
Date: 12/22/2011
Analysis Services 2008 R2 Performance Guide
Writers: Thomas Kejser and Denny Lee Editor: Beth Inghram Contributors and Technical Reviewers:...
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:...
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...
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...
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...
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...
Date: 07/12/2011
Diagnosing and Resolving Spinlock Contention on SQL Server
Authors: Mike Ruthruff, Ewan Fairweather Contributors: Fabricio Voznika, Jack Richins, Thomas Kejser...
Date: 07/05/2011
Diagnosing and Resolving Latch Contention on SQL Server
Authors: Ewan Fairweather, Mike Ruthruff Contributors: Thomas Kejser, Steve Howard Technical...
Date: 07/05/2011
SQL Server 2008R2 Analysis Services Operations Guide
Authors: Thomas Kejser, John Sirmon, and Denny Lee Contributors:Bilal Obeidat, John...
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...
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...
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...
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...
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:...
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...
Date: 03/14/2011
FILESTREAM Design and Implementation Considerations
Writer: Shaun Tinline-Jones Technical Reviewer: Prem Mehra, Chuck Heinzelman, Nicholas Dritsas,...
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...
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...
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...
Date: 11/09/2010
Failure Is Not an Option: Zero Data Loss and High Availability
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...
Date: 10/29/2010
Edgenet Realizes the Power of Dynamic IT and Self-Service BI
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...
Date: 09/20/2010
PowerPivot for SharePoint - Existing Farm Installation
Writers: Leon Cyril, Dave Wickert, Denny Lee Technical Reviewers: Lee Graber, Jennifer Chu, Kathy...
Date: 09/07/2010
PowerPivot for SharePoint: Single Server Installation
Writers: Leon Cyril, Dave Wickert, Denny Lee Technical Reviewers: Lee Graber, Jennifer Chu, Kathy...
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...
Date: 08/23/2010
PowerPivot Technical Diagram: PowerPivot Security Architecture
Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL...
Date: 08/17/2010