Using DQS with SQL Server AlwaysOn AG

Hi everyone, A couple of weeks ago I presented a session on cloud IT Pro Airlift: Infrastructure & Data Platform event in Portugal and did a demonstration about Enterprise Information Management (EIM) session using SQL Server 2012 AlwaysOn feature.   If you search for the text “Building an AlwaysOn HADR solution for DQS”, you will…


Master Data Services Operations Guide released

Hi everyone, A new Master Data Services whitepaper is now published:http://msdn.microsoft.com/en-us/library/dn520800   Summary:SQL Server Master Data Services (MDS) provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications. With MDS, you can implement a master data management (MDM) hub to manage the master data that…


Programmatically find MS Shipped Databases

Hello, Have you ever needed to programmatically find what databases in you server are part of Microsoft products? Maybe to use that information in your own piece of code? In my case, I needed that information to exclude Sharepoint and Biztalk databases from the AdaptiveIndexDefrag cycles that are part of the maintenance operations we deploy…


SQL Swiss Army Knife #13 – Exploring the plan cache – Part 1

Hello all, In the last few months I’ve been creating a few snippets of code to extract as much useful information from the plan cache as possible. Why to do this? We at Microsoft GBS PFE deliver a type of service called a SQL Performance Tuning and Optimization Clinic, which is directed at finding and…


PAGELATCH_EX waits and heavy inserts

Hello all, Recently I came across an issue over a table that was being inserted into quite intensively, by concurrent operations. The issue, which is not that uncommon, is dealing with PAGELATCH_EX contention, namely when a table has a clustering key that conforms with the concept of a small and monotonically increasing value, such as…


Microsoft BI Authentication and Identity Delegation white paper

Hi everyone! This month we released a new white paper for the newest SQL Server 2012 SP1 and Office 2013 authentication and identity delegation issues. Check this information at http://technet.microsoft.com/en-us/library/dn186184.aspx. Summary: “From straightforward client/server designs to complex architectures relying on distributed Windows services, SharePoint applications, Web services, and data sources, Microsoft BI solutions can pose…


SQL Swiss Army Knife Series is indexed

Hello all, By popular demand, I’m creating this post to serve as the central location for all past and future posts of the “SQL Swiss Army Knife” series, which should also make it easier to find and new updates. Tag Script Initial Release Latest Update Securables    #1 – Scripting Securables 26 Apr 2010 18 Nov…

4

Premier TechTracks SQL Server is Live

Hi all, Last month, Microsoft’s Premier Education Services has released an ongoing series of online, on-demand trainings available to all Premier customers called the Premier TechTracks, of which there is a dedicated SQL Server track HERE. These online trainings focus on Level 300 to 400 sessions. To help clear what is each session level, here…

0

Ezequiel will be in the next SQL Saturday #188

Hi all, Just to share with the community that Ezequiel will be represented with several speakers at the upcoming SQL Saturday #188, which will be hosted at the Microsoft Lx Experience building in Lisbon, Portugal.   Find more about the sessions in the schedule page. Hope to see you there! Disclaimer: I hope that the…

0

The Kerberos, SharePoint, Reporting Services and Internet Explorer case

Hello everyone,   Last week I had a situation that was tricky to solve and involved Kerberos! At this time you are thinking: “Oh no, here comes big trouble!”. And you are right, it was difficult to understand what was happening but the solution was simple. Let’s get started! The environment setup was the following:…