SQL Server Hyper-V Virtual Machines, Where do I put the Cluster?

I remember the old days, when I wasn’t a fan of Installing SQL Server on Virtual Machines, but in todays world thanks to Hyper-V 2012 (and I guess VMWARE too), a lot of the resource bottlenecks for virtual machines has disappear. However still it’s not for every workload. Recently I was on one of my…


Sysprep and SQL Server

Duración: 30 min.   Tema: SQL Server Sysprep.  Descripción del tema: En este tea tocaremos los pasos que debemos seguir para crear una imagen de SQL Server y Windows Server.  Objetivo: Dar a conocer cómo funcionan la caracteristica de sysprep en SQL Server y como la podemos usar para automatizar a creacion de maquinas con una…


Error loading Project Center page in SP 2010 CU April 2013 or SP2

During June and October 2013, I was supporting two customers in Venezuela, in order to update their SharePoint 2010 and Project Server 2010 production environments. Customers did not have testing environments, neither a formal patch management strategy, therefore, they decided update directly in Production: Customer 1 required apply Cumulative Update April 2013 for its SharePoint…

0

Tips and Tricks from the Field on the new Distributed Cache Service in SharePoint 2013

Originally posted at http://blogs.technet.com/b/mspfe/archive/2013/12/11/tips-and-tricks-from-the-field-on-the-new-distributed-cache-service-in-sharepoint-2013.aspx  Author:  Vladimir Medina , SharePoint PFE, LATAM   If you, like me, are playing with SharePoint 2013 or if you have plans to migrate/deploy SharePoint 2013, you may have already heard about Distributed Cache (a.k.a. Velocity or AppFabric).  In this post, I’d like to make you aware of some tips from…

1

Identifying Cell by Cell Computation Mode in MDX queries

Some weeks ago I was asked to help with a performance issue with some MDX Queries. I was shown what the customer wanted to achieve, they needed to calculate some metrics including sampling errors using the method of “Conglomerados Últimos” (This can be translated to “Conglomerates Last” Method), this method was created by a Spanish…


Windows Aware updating and SQL Server 2012 (Part II) – Step by Step

At this point we already know the concepts for Windows Aware Updating (CAU), on this post we will check how to use the plug-in Windows.HotfixPlugin to install LDR updates, cumulative updates and Service Packs, and the options that provides to obtain a better control of the process. NOTE: CAU can only be used from SQL…


Windows Aware Updating and SQL Server 2012 (Part I) – Introduction to Windows Aware Updating

Windows Server 2012 has incorporated a new functionality called Windows-Aware Updating (CAU) that allows the automatic orchestration of the installation of updates for the operating system and other applications that are executed on the Cluster nodes. This functionality is really well integrated with applications like Hyper-V, however, can be used to update any Microsoft Application…


¿Privileges on the Service SID or on the SQL Service Account?

On SQL Server 2008 the concept of Service SID was introduced to be used when installing on Windows 2008 or later. The concept of Service SID (also known as Virtual Account) allows assigning the required permission needed for the correct functioning of the SQL Instance without using Local Groups or Domain Groups (in a cluster…


Missing updates listed on Server Farm Products and Farm Patch status page

Hello community,   This time I was working on a customer in Jamaica and faced an issue installing updates in a SharePoint 2010 farm, basically we were installing a CU and when we try to start the PsconfigGUI we got an error screen preventing us to update SharePoint properly: At first sight I though reinstalling the…

0