Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: About Maintenance Plans – grooming SQL Server

    Hello all, I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I wrote and keep updating the AdaptiveIndexDefrag procedure. Good maintenance (or lack thereof) may be the difference...
  • Blog Post: MOSS, BizTalk, SCOM and SQL Server Collations

    Hello all, The topic today is database and server collations. As part of pre-installation tasks for SQL Server, we should always take into account what is the collation required by the user databases. Why is that? Collation is a subject many times overlooked when installing SQL Server, and many just...
  • Blog Post: How to integrate SSRS Reports with PerformancePoint Dashboards in SharePoint 2010

    Hello all, Probably a few of you have heard about PerformancePoint in Microsoft’s BI stack. PerformancePoint Services is set of tools and services that allow you to create and publish Business Intelligence Dashboards in SharePoint 2010. PerformancePoint tools are the start point to create...
  • Blog Post: SQL Best Practices for MOSS

    Hello all, One question that arises often is how can we correctly configure SQL Server to work with MOSS?. Although the majority of best practices for SQL does apply, there are some diferences that it is important to be aware of. 1 - Architecture recommendation 1.1 - Limit content database size...
Page 1 of 1 (6 items)