SQLOS & Cloud Infrastructure Team Blog

Notes from the SQL Server Cloud Infrastructure team.

MSA accounts used with SQL

Here's a note from Anne Labbe, a premier field engineer in Charlotte who's been looking into managed...

Author: G Bowerman (MSFT) Date: 02/19/2014

Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell

Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell Blog This...

Author: Madhan Arumugam Date: 06/25/2013

Exciting news - At TechEd Europe 2013 keynote today, we announced that SQL Server 2014 CTP1 is now...

Author: Madhan Arumugam Date: 06/25/2013

SQL Server in Windows Azure Infrastructure Services: Performance Guidance Whitepaper and other TechEd NA 2013 updates

Greetings, We are excited to announce the release of our new whitepaper, Performance Guidance for...

Author: Madhan Arumugam Date: 06/03/2013

Enhancements to SQL Server Backup to Cloud in SQL Server 2012 SP1 CU4

Cumulative Update 4 for SQL Server 2012 Service Pack 1 includes enhancements to improve the SQL...

Author: Karthika [MSFT] Date: 05/31/2013

SQL Server in Windows Azure Infrastructure Services – Updated Documentation and Best Practices for GA, Upcoming Blogs

It’s been just over a week since Windows Azure announced the GA of Infrastructure Services,...

Author: G Bowerman (MSFT) Date: 04/24/2013

SQL Server Backup to Cloud – Managing Interrupted backups

Writer: Karthika Raman Technical Reviewers: Guy Bowerman, Pat Schaefer, Andrew Cherry On January 24,...

Author: Karthika [MSFT] Date: 03/12/2013

When will my SQL Server Evaluation Edition expire?

The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL...

Author: G Bowerman (MSFT) Date: 02/17/2013

Backup and Restore to Cloud Simplified in SQL Server 2012 SP1 CU2

SQL Server 2012 SP1 Cumulative Update 2 includes new functionality that simplifies the backup and...

Author: G Bowerman (MSFT) Date: 01/24/2013

SQLOS and Cloud Infrastructure sessions at PASS Summit 2012

The SQL Pass Summit 2012, the largest yet, is in full swing. Here's a summary of the sessions this...

Author: G Bowerman (MSFT) Date: 11/07/2012

Resource Governor in SQL Server 2012 technical article published

The SQL Server Technical article entitled Resource Governor in SQL Server 2012 has just been...

Author: G Bowerman (MSFT) Date: 07/30/2012

Memory Manager Configuration changes in SQL Server 2012

Continuing from yesterday's article about Memory Manager surface area changes in SQL Server 2012,...

Author: G Bowerman (MSFT) Date: 07/12/2012

Memory Manager surface area changes in SQL Server 2012

There were various changes to memory related DMVs, DBCC memory status, and Perfmon counters in SQL...

Author: G Bowerman (MSFT) Date: 07/11/2012

SQL Server 2012 Memory Manager KB articles

Since the release of SQL Server 2012 with a redesigned memory manager, a steady stream of KB...

Author: G Bowerman (MSFT) Date: 06/20/2012

Lock Pages in Memory - not deprecated in Denali

Please note an error in the SQL 2012 documentation for Lock Pages in Memory which indicates that...

Author: G Bowerman (MSFT) Date: 03/22/2012

When was sys.dm_os_wait_stats last cleared?

The sys.dm_os_wait_stats DMV provides essential metrics for diagnosing SQL Server performance...

Author: G Bowerman (MSFT) Date: 11/12/2011

New SQLOS features in SQL Server 2012

Here's a quick summary of SQLOS feature enhancements going into SQL Server 2012. Most of these are...

Author: G Bowerman (MSFT) Date: 11/10/2011

SQL Server with Hyper-V Dynamic Memory - Best Practices white paper

A new Microsoft white paper has been published entitled Running SQL Server with Hyper-V Dynamic...

Author: G Bowerman (MSFT) Date: 08/02/2011

SQL Server Virtualization, Consolidation and Private Cloud Resources

We've been seeing a lot of interest in optimizing SQL Server for virtualization private cloud...

Author: G Bowerman (MSFT) Date: 06/08/2011

More on DMV changes in SQL 2008 R2 SP1

Following our last post by Mehmet about new support and troubleshooting DMV’s, here are...

Author: Xin Jin [MSFT] Date: 05/11/2011

New DMVs in Denali

This article is about some of the new DMV’s that are newly added to next version of SQL...

Author: Mehmet Safak Albayrak Date: 05/05/2011

SQL Server and Hyper-V Dynamic Memory Part 3

In parts 1 and 2 of this series we looked at the basics of Hyper-V Dynamic Memory and SQL Server...

Author: G Bowerman (MSFT) Date: 03/09/2011

SQL Server and Hyper-V Dynamic Memory Part 2

Part 1 of this series was an introduction and overview of Hyper-V Dynamic Memory. This part looks at...

Author: G Bowerman (MSFT) Date: 02/27/2011

SQL Server and Hyper-V Dynamic Memory - Part 1

SQL and Dynamic Memory Blog Post Series Hyper-V Dynamic Memory is a new feature in Windows Server...

Author: G Bowerman (MSFT) Date: 01/31/2011

What causes Multi-Page allocations?

Writing about changes in the Denali Memory Manager In his last post Rusi mentioned: " In previous...

Author: G Bowerman (MSFT) Date: 01/26/2011

SQL Server Memory Manager Changes in Denali

The next version of SQL Server will contain significant changes to the memory manager component. The...

Author: Rusi_H - MSFT Date: 01/04/2011

Is this real? The Metaphysics of Hardware Virtualization

One of the philosophical principles of hardware virtualization is that the hardware should appear...

Author: G Bowerman (MSFT) Date: 10/30/2010

Mapping Virtual Address Space in T-SQL

The Dynamic Management Views (DMVs) introduced in SQL Server 2005 provide a comprehensive window...

Author: G Bowerman (MSFT) Date: 10/24/2010

New SQL Server Virtualization white paper published

A new white paper has been published on TechNet today: Planning, Implementing and Supporting SQL...

Author: G Bowerman (MSFT) Date: 07/30/2010

Solid State Memory and TPC-E benchmarks

Violin Memory have published an interesting TPC-E benchmark which illustrates the kind of cost and...

Author: G Bowerman (MSFT) Date: 06/30/2010

SQLOS Resources

Hello, I recently joined the SQLOS team as a program manager. As it has been a year or so since the...

Author: G Bowerman (MSFT) Date: 06/23/2010

Using XEVENT in SQL Server

Xevent related system catalog views and DMVs Some one asked me how to use xevent. There are lot of...

Author: WhiteCloud Date: 06/04/2009

How to RPC to transfer data from native c++ to managed object

My Experience on using RPC in mixed mode assembly I was assigned a project which use RPC cross...

Author: WhiteCloud Date: 06/04/2009

We add extended event (short for XEVENT) to SQL Server 2008. Along with this feature, we provide a...

Author: WhiteCloud Date: 06/10/2008

The basics of basics

[Copied over from my original blog https://ssinghal.spaces.live.com to have everything under one...

Author: Saurabh Date: 04/18/2007

Sql Server Memory 101

[Copied over from my original blog https://ssinghal.spaces.live.com to have everything under one...

Author: Saurabh Date: 04/18/2007

Hello World!

We work in Microsoft Sql Server team for one of the core components called SQLOS. Thats the place...

Author: Saurabh Date: 04/13/2007