Saturday, January 20, 2018
Updates from SQLOS (SQL Operating System) @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

MSA accounts used with SQL

Wednesday, February 19, 2014

Here's a note from Anne Labbe, a premier field engineer in Charlotte who's been looking into managed service accounts.. After painstaking research and tracking this down to the product team this is what I found: 1. Managed Service Accounts (MSA) are different from Group Managed Service Accounts (gMSA).  The reason I’m calling this out is because...

Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell

Tuesday, June 25, 2013

Manage SQL Server Connectivity through Windows Azure Virtual Machines Remote PowerShell Blog This blog post comes from Khalid Mouss, Senior Program Manager in Microsoft SQL Server. Overview The goal of this blog is to demonstrate how we can automate through PowerShell connecting multiple SQL Server deployments in Windows Azure Virtual Machines. We would configure TCP...

SQL Server 2014 CTP1 now available for download as well as in Windows Azure Image Gallery

Monday, June 24, 2013

Exciting news - At TechEd Europe 2013 keynote today, we announced that SQL Server 2014 CTP1 is now available for download as well as in Windows Azure Image Gallery. Try it out now and give us feedback. - Watch the Keynote again   thanks, Madhan    

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

Monday, June 03, 2013

Greetings, We are excited to announce the release of our new whitepaper, Performance Guidance for SQL Server in Windows Azure Virtual Machines. This paper provides you guidance to optimize your SQL Server workloads running in Windows Azure Infrastructure Services. Additionally, if you are attending TechEd North America 2013 in New Orleans this week, be sure to...

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

Friday, May 31, 2013

Cumulative Update 4 for SQL Server 2012 Service Pack 1 includes enhancements to improve the SQL Server Backup and Restore to Cloud user experience.  The enhancements include performance improvements, cleaning up invalid blobs when backups fail or are interrupted, and PowerShell support.   To request this update, see this knowledgebase article. Performance Improvements: Performance improvements include...

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

Wednesday, April 24, 2013

It’s been just over a week since Windows Azure announced the GA of Infrastructure Services, marking the beginning of a fully supported Infrastructure as a Service in Windows Azure, with SQL Server as a major component. Pre-installed SQL Server VMs are available for pay-per-hour usage in the Windows Azure gallery. Currently Enterprise, Standard and Web...

SQL Server Backup to Cloud – Managing Interrupted backups

Tuesday, March 12, 2013

Writer: Karthika Raman Technical Reviewers: Guy Bowerman, Pat Schaefer, Andrew Cherry   On January 24, 2013, the SQL Server engineering team released new functionality in SQL Server 2012 SP1 CU2, enabling SQL Server native backup to cloud. The steps to creating a SQL Server backup to Windows Azure Blob storage are simple, but if a...

When will my SQL Server Evaluation Edition expire?

Sunday, February 17, 2013

 The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and developing solutions. The edition has a built in expiry of 6 months from the time that you install it. I often install an Eval edition on a machine to set up a test or...

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

Thursday, January 24, 2013

SQL Server 2012 SP1 Cumulative Update 2 includes new functionality that simplifies the backup and restore capability of an on-premises SQL Server database to Windows Azure.   You can now directly create a backup to Windows Azure Storage using SQL Server Native Backup functionality. Read the information below to get a brief introduction to the new...

SQLOS and Cloud Infrastructure sessions at PASS Summit 2012

Wednesday, November 07, 2012

The SQL Pass Summit 2012, the largest yet, is in full swing. Here's a summary of the sessions this week on cloud infrastructure and SQLOS topics. Some of these were today, and you can catch the recordings. One more session takes place on Friday covering SQL Server solution patterns in Windows Azure VMs... Also, catch Thursday's keynote with...

SQLOS Team blog updates

Friday, June 25, 2010

Please note that to save the need to check two different sites, future SQLOS team blog posts will be appearing on the MSDN site here: SQLOS Team Blog. Thanks, Guy.

How to configure Soft-NUMA on a system with > 32 processors?

Friday, May 15, 2009

  I recently answered this customer question and was looking forward to post the solution here. So here you go! There is already a lot of information about how Soft NUMA works and how to configure Soft NUMA on your system. So without delving into the basics, I am jumping right ahead to the topic.  ...

Debugging slow response times in SQL Server 2008

Friday, July 18, 2008

Introduction The other day I came across a nice article written by Mario Broodbakker called "SQL Server Wait Events: Taking the Guesswork out of Performance Profiling" (see references) on how to troubleshoot slow response times in SQL Server 2000 and 2005 using the YAPP Method. According to the author, one of the biggest challenges to apply...

Part 2: Resource Governor CPU Demo on multiple CPUs

Friday, January 18, 2008

In some cases CPU demo described in the previous post may behave not as expected. One such case is doing the demo on multiple CPUs. Even though it appears as Resource Governor is "not working", it is "by design". Let's take a look at what happens in this case. What is our promise about CPU...

Part 1: Anatomy of SQL Server 2008 Resource Governor CPU Demo

Friday, December 14, 2007

First, a quick introduction. My name is Boris Baryshnikov and I'm a program manager in SQL Server Database Engine group. As of today, Resource Governor is the most recent large project I worked on. Not surprisingly, I will talk about the Resource Governor here. While Resource Governor spans multiple components of SQL Server Engine, it...

Copyright [2014] by SQLCOMMUNITY.COM