Month: May 2017

How to import,start,stop Perfmon Data collector set from command line

Jacques DALBERA's IT world

 It’s possible to export Windows Performance Monitor Data Collector Sets from perfmon.exe and then reopen the template on a different machine.

If you have many performance data collector templates or many machines or both, you need an automated way to import the data collector templates.

An easier way is to use logman.exe to import the performance monitor data collector set.

Here’s the syntax: logman import -name “MyCustomMonitorName” -xml “MyCustomMonitorTemplate.xml” 

Create a batch file or Powershell script with that command for each data collector set and you can deploy multiple performance monitors to multiple machines quickly.

Then

to start the data collector set from the command line: logman start “MyCustomMonitorName”

and to stop the data collector set: logman stop “MyCustomMonitorName”

Normally, if you have checked the box: Enable Data Management and Report generation (on DataManager tab of the DCS), you can access the REPORT.HTML report located by default on…

View original post 16 more words

Advertisements

SQL Server Latest Updates (May. 2017)

SQL Server Latest Updates (May. 2017)

by suxstellino (Alessandro Alpi)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2012 sP3 and 2016:

Cumulative Update #9 for SQL Server 2012 SP3

Cumulative Update #6 for SQL Server 2016 RTM

Cumulative Update #3 for SQL Server 2016 SP1

Also, you can download the Microsoft Azure Database Management Pack (6.7.28.0) here.

Stay Tuned! 🙂

 Posted by Sheikvara
+919840688822, +919003270444

Windows Azure AppFabric Caching Service – It’s Alive!!

Michael S. Collier's Blog

The Windows Azure AppFabric Caching Service was released yesterday as a production service.  Previously this service has been available as a CTP service only.  I’m thrilled to see this service being made available now as a production level service.  I think the caching service is a huge feature for those doing scalable, robust services on the Windows Azure platform.  No longer do you need to implement your own “caching service invented here” solution, or go through the steps to implement another caching solution for your Windows Azure hosted solutions.

As a CTP service, Windows Azure AppFabric Caching was free.  Now that as a production service you would expect that to change, right?  Not so fast my friend!  The service is being made available for free until August 1, 2011.  After the free promo period ends in August, pricing for the service will vary based on the size of the…

View original post 170 more words

Creating My First Windows Azure AppFabric Application

Michael S. Collier's Blog

Microsoft recently made available the Windows Azure AppFabric June CTP to get started developing Windows Azure AppFabric applications.  Read the announcement post from the AppFabric Team for a good overview of the Azure AppFabric application model.  Be sure to download the CTP SDK too.  You can also get a FREE 30-day Windows Azure pass at http://bit.ly/MikeOnAzure, using the promo code “MikeOnAzure”.

Once you have the SDK installed, you’ll want to get started creating your first Azure AppFabric application.  Launch Visual Studio 2010 and create a new project.  In the New Project Template wizard, you’ll see a new “AppFabric” section.  You might have expected the Azure AppFabric projects to be located under the “Cloud” area, as that is where the other Azure project templates are.  I did too.  My assumption here is that this is CTP and the location of the templates are likely to change before final, or that…

View original post 1,079 more words

Connect to Azure SQL Database by Using Azure AD Authentication

Michael S. Collier's Blog

One of the great features recently added to Azure SQL Database is the ability to authenticate to Azure SQL Database using Azure Active Directory. This provides an alternative to exclusively using SQL credentials. By leveraging Azure AD authentication, you can greatly simplify management of database permissions by continuing to use existing identities, as well as leveraging AD groups.

The article here does a decent job of explaining the basics of how Azure AD authentication with SQL Database works, and the steps needed to do so. One area that it doesn’t yet cover is obtaining an Azure AD authentication token and using that token to authenticate with SQL Database.  Actually  . . . it does, sort of. The article assumes a certificate will be used. That isn’t always the case. In the following sections, I will show you how to obtain an Azure AD authentication token for a user (in Azure…

View original post 1,151 more words

Creating a Custom SQL Server VM Image in Azure

Michael S. Collier's Blog

Recently I had the opportunity to work on a project were I needed to create a custom SQL Server image for use with Azure VMs.  The process was a little more challenging than I initially anticipated.  I think this is mostly because I was not familiar with the process of preparing a SQL Server image.  Perhaps this isn’t much of a challenge for an experienced SQL Server DBA or IT Pro.  For me, it was a great learning experience.

Why a Custom SQL Server Image?

The Azure VM image gallery already contains a SQL Server image.  It’s very easy to create a new SQL Server VM using this image.  However, doing so has a few important trade-offs to consider:

  • Unable to fully customize the base install of SQL Server.  This is a template/image after all – you get a VM configured the way the image was configured.
  • Unable to use your own SQL…

View original post 1,149 more words

Copy Managed Images

Awesome

Michael S. Collier's Blog

Introduction

Azure Managed Disks were made generally available (GA) in February 2017. Managed Disks greatly simplify working with Azure Virtual Machines (VM) and Virtual Machine Scale Sets (VMSS). They effectively eliminate the need for you to have to worry about Azure Storage accounts and related VHD constraints/limits. When using managed disks for VMs or VMSS, you select the type of disk storage (SSD or HDD) and the size of disk needed. The Azure platform takes care of the rest. Besides the simplified management aspect, managed disks bring several additional benefits, but I’ll not reiterate those here, as there is a lot of good info already available (here, here and here).

While managed disks simplify management of Azure VMs, they also simplify working with VM images. Prior to managed disks, an image would need to be copied to the Storage account where the derived VM would be created…

View original post 1,255 more words