Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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