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...

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...

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...

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...

Some days ago I visit a client on Puerto Rico that was having some performance problems on a transactional application and after resolving the issue the client express interested on learning about Column Store Index, this kind of indexes is a new functionality on SQL Server 2012, as we will see his kind...

Hello Community, After many time of abscense I'm back to continue providing you with more information that can be valuable or useful, this time for SharePoint 2010 beginners that would like to know the new OOB Backup/Restore features and how to schedule backups using Windows scheduled tasks. First...

A new feature in SQL Server 2012 is the tabular models in Analysis Services, and after facing some issues when I was preparing a demo for a recent event I decided to finish some tests to compare the performance of Tabular Models vs multidimensional models. First, what it is Analysis Services Tabular...

Dear members of the PFE LATAM community and SQL community, last Friday, June 22, 2012 we had our first Latin American Symposium of SQL Server in the Microsoft Mexico Auditorium. The agenda for this evens was create by a people with diverse roles like: developers and It Pros. We have speakers like...

Hello everybody, this time I’m going to talk about a problem that it’s not related to SQL specifically, it’s an issue that I found related with Windows Server 2003 Failover Clustering The problem it’s that after installing a shared disk to the cluster nodes they didn’t...

Hello there community Recently was released a note about Microsoft Support Lifecycle policy in which we were adviced that SharePoint Server 2010 (any version before SP1) won't be supported anymore after July 10,2012. SharePoint LATAM PFE team suggests you to update to Service Pack 1 plus June CU Refresh...

Hi Technet community. Today I have the privilege to start write in this blog (and a little reward the knowledge I've gained in Technet and MSDN). A few weeks ago it was the launch of SQL 2012 ( http://www.microsoft.com/es-es/sqlserver/default.aspx ) and I would like to make a brief reference to the...

Hey there community, Today we will learn how to create and use WMA or MP3 files as ringtones in our powerfull Windows Phone 7. Since Microsoft released its Mobile operating system we wished to use our old ringtones from other companies or inclusive from our Windows Mobile phone, today is official...

One of the clients that I worked for has a fully transactional core database. This database is accessed by a web application, which has an intermediate layer of application servers which connect directly to databases. Here we can distinguish 3 different levels: web, application and database. The right...

During a chat with friends about getting a better performance of SQL Server, the following question emerge... which other optimization apply to SQL server, apart from Best Practices at the Operating System and Application level? Optimizations at the hardware level are also necessary, especially at the...

What is Integration Services? SQL Server Integration Services (SSIS) is a tool to allow for gathering of data from diverse sources, scrubbing and homogenizing the data into a format for unified use, and loading that data into databases, spreadsheets, text files, or any other OLE-DB compliant destination...

In the last 6 months I have faced two cases of linked servers between a SQL Server 2008 R2 Instance running on Windows Server 2008 R2 and a SQL Server 2000 instance running on Windows 2003 were distributed transactions were not working correctly. The root cause of the problem is still under investigation...

This article explains how to move overrides from the Default Management Pack to any other unsealed management pack in System Center Operations Manager 2007 R2 or 2012. This is a very common problem I see when visiting customers. Most of people, right after installing OpsMgr, start to create overrides...

After testing many times and configuring FBA in many Virtual environments, finally I think I wrote the easiest and clearest procedure and hope what I'm saying is true, please read carefully and do not skip any step. To configure FBA using SQL Server with Windows Integrated Authentication (recommended...

Last week we had an internal event called GeekReady, where PFE’s all over LATAM (Latin America) could get together to hear from the management team the latest updates, acquire and share knowledge, meet with new-hires and reunite with old friends (which in our case is great, as we usually are constantly...

Hi there community, First of all wishing you a successfull 2012, today we'll talk about a known issue related to "Datasheet View" option for SharePoint 2010 lists. What is Datasheet View in SharePoint 2010 for? You can export a SharePoint list from Datasheet view to Microsoft Access or Microsoft...

Hello there, We are closing the year and we would like to know if our job over the PFE LATAM Blog has been useful for you, please tell us if posted articles helped to fix or guide you through the issues or challenges you have faced off with Microsoft technologies. Do not hesitate if you have suggestions...

Hi there SharePoint community, This time let's talk about a particular topic that in my experience is not well known and SharePoint Administrators or SharePoint tem in general is not aware of the issues they can face. I was working recently in a SharePoint RAP where a customer wanted to discuss a...

Introduction Hello, a few days ago I was think that even the high usage that I personally use of the xp_readerrorlog (or sp_readererrorlog) stored procedure to review the SQL Error Log, if do an internet search about it you will not find any official references to it. Like this stored procedure there...

From SQL Server 2005 the SQLOS was implemented don SQL Server. We can see the SQLOS as a layer used by SQL Server to interact with the Operating System. The need to have the SQLOS on SQL Server is given by the need to adapt to changes at the hardware and architecture levels. Windows is defined as...

This week while I was working on Bolivia, I overheard the security staff discussing about options they can use to audit transactions done on the database tables. I interrupted and asked them if they knew about the SQL Audit configuration on SQL 2008, and they told me they didn’t. So wrote this...