Hello all, We would like to ask for your attention for the fact that there was a good refresh on the KB article related with Antivirus Guidelines for SQL Server (KB 309422 ).  Take some minutes to read it and to proceed according to the recommendations...

  Hi, Recently, SQLAzure Labs released two projects that could help, in different aspects, on the move, of our databases from the On-Premise stack to the SQLAzure world. The first project has the main purpose of helping on this move, performing a...

  Hello All, There are out there lots of information, already, about the SQL Server 2012 AlwaysOn feature. In resume, this feature is related with the enhancement of High Availability and Disaster Recovery capabilities available in SQL Server, at...

  Hello all, Don’t lose the opportunity to attend the SQL Server 2012 launch event! It will be online and to attend you just need to register yourself following the instructions available on the web address: http://www.sqlserverlaunch.com Cheers...

Hi all, Today I was looking for some information about PowerPivot configuration in SharePoint 2010 and found out this old post of Denny Lee from SQL CAT Team that explains the Security Architecture for PowerPivot. Sometimes is quite difficult to...

Hello all, Last week while I was onsite, I was discussing with a customer about some T-SQL querying misconceptions, one particularly caught his interest. In the subject of JOINs , I was asked if there are there any known issues using search arguments...

Have you ever felt the need to check how your reporting services instances are in terms of health? I’m going to give some tips that can start helping you on this subject, but first let’s understand how Reporting Services Logs are structured...

Hello, We are looking for professionals with passion for customers and technology that possess strong interpersonal skills with an enthusiastic and collaborative attitude, initiative and a results driven approach. These professionals should have a deep...

Hello all, Just to share with you a summary with the news, publicly available, about SQL Server 2012 RC:   Technorati Tags: SQL Server 2012 RC0 , What's new   Official Release Information            ...

Hi again, Do you know you can add interactive features to your dashboard in PerformancePoint with SSAS actions? It’s really easy, fast and it can give your business analysis the 5 stars user experience. PerformancePoint can use Bing . Add...

Hello, In the past I posted the new SharePoint SP1 features for PerformancePoint Services which included the new cascading filters option. In this post, I’m going to show you the basic steps to achieve this goal with Dashboard Designer in SharePoint...

Hello all, If you follow this blog, you know I blogged on VLFs several times before and if you want to read more about it just click here . I decided to investigate a bit on something Kalen Delaney mentioned today in a SQL PASS session. She heard...

  Hi, Last week, it was released the SP3 of SQL Server 2008: SQL Server 2008 Service Pack 3 Microsoft SQL Server 2008 SP3 Express Edition Microsoft SQL Server 2008 Service Pack 3 Feature Pack Release Notes Readme The following article includes the...

Hello all, Here is another post on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". I’ve been using and tweaking this script for years now, and I’ve been asked to share it several times, because I can get a quick...

Hello all, It’s been awhile since I’ve updated the blog from my part. It’s been a rough month, and I’ve been on vacation prior to that, but I’m back. What I want to get your attention in this post is to the “Auto Update Statistics Asynchronously” database...

Hi, In the continuation of our Business Intelligence series in our Ezequiel Blog, I’m making this post to announce the release of SharePoint 2010 SP1 and the new features that have been included. From a BI perspective there are several functionalities...

Hello all, Here is another post on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife", this time on the topic of VLFs again. If you follow this blog, you know I blogged on this subject several times before and if you want to read...

Hi, The purpose of this post is to share some notes (links) about the recent release of SQL Server 2008 R2 SP1: SQL Server 2008 R2 SP1 Technorati Tags: SQL Server 2008 R2 SP1 , Service Pack Download http://www.microsoft.com/download/en/details.aspx?id...

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

The purpose for this procedure to to perform an intelligent defrag on one or more indexes for one or more databases. The 1st release was inspired by an earlier release of Michelle Ufford’s code in SQLFOOL.com site, and has since evolved to suit different and added needs. In a nutshell, this procedure automatically chooses whether to rebuild or reorganize an index according to its fragmentation level, amongst other parameters, like if page locks are allowed or the existence of LOBs.
All within a specified time frame you choose, defaulting to 8 hours. The defrag priority can also be set, either on size, fragmentation level or index usage (based on range scan count), which is the default.
It also handles partitioned indexes, optional statistics update (table-wide or only those related to indexes), rebuilding with the original fill factor or index padding and online operations, to name a few options.

...

Hello all, Sorry for the inconvenience, but the content of this post moved to the Adaptive Index Defrag post .

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

Hello all, Here is another post on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife", this time revisiting the topic of VLFs. I blogged on this subject several times before and if you want to read more about it just click here...

  Hello all, SQLPort , Portuguese chapter of SQLPass , is organizing one more event, the XI one and this time the presenter will be Kalen Delaney , so please register yourself at: http://www.sqlport.com/sql-server/eventos/xi-encontro-da-comunidade...

Hello all, A while back I blogged on how log files can affect DML performance , depending on their structure and growth ratio. It recently came to my attention (thanks Paul Randal) that a fix was published late last February, in KB2455009 , aimed at...