Blog do Ezequiel
SQL Server Insights
Master Data Services Operations Guide released
Hi everyone, A new Master Data Services whitepaper is now...
Author: Alexandre Mendeiros Date: 10/30/2013
Programmatically find MS Shipped Databases
Hello, Have you ever needed to programmatically find what databases in you server are part of...
Author: Pedro Lopes (PL) Date: 10/27/2013
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...
Author: Pedro Lopes (PL) Date: 08/01/2013
PAGELATCH_EX waits and heavy inserts
Hello all, Recently I came across an issue over a table that was being inserted into quite...
Author: Pedro Lopes (PL) Date: 05/23/2013
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...
Author: Alexandre Mendeiros Date: 03/20/2013
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...
Author: Pedro Lopes (PL) Date: 02/19/2013
Premier TechTracks SQL Server is Live
Hi all, Last month, Microsoft’s Premier Education Services has released an ongoing series of...
Author: Pedro Lopes (PL) Date: 02/15/2013
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...
Author: Pedro Lopes (PL) Date: 02/15/2013
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...
Author: Alexandre Mendeiros Date: 02/11/2013
Table variables and row estimations – Part 2
Hello again, On my previous post, we covered how the Query Optimizer handles row estimation when...
Author: Pedro Lopes (PL) Date: 12/09/2012
Table variables and row estimations – Part 1
Hello all, The subject of estimated rows vs. actual rows in plan execution has a lot of impact in...
Author: Pedro Lopes (PL) Date: 11/30/2012
Upgrading Data Quality Services (DQS) from RTM to SQL Server 2012 SP1
Hello everyone, Today Data Quality Services (DQS) team release a post about upgrading DQS RTM to SQL...
Author: Alexandre Mendeiros Date: 11/29/2012
About Maintenance Plans – grooming SQL Server
Latest update: 10/24/2016 (Check change log) Download scripts on GitHub. Hello all, I admit I’m not...
Author: Pedro Lopes (PL) Date: 09/18/2012
SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions
Latest update: 12/2/2016 (Check change log) Download on GitHub Hello all, Following the series "SQL...
Author: Pedro Lopes (PL) Date: 09/18/2012
Take most of Reporting Services Logs with Excel 2013
Hi everybody. It’s been a while since I have posted in this blog about Reporting Services Logs...
Author: Alexandre Mendeiros Date: 09/16/2012
A practical example on missing a filtered index
Hello all, Last week I did a brief presentation on SQLPort about hinting the database engine. What’s...
Author: Pedro Lopes (PL) Date: 05/27/2012
SQL Swiss Army Knife #12 - Index information galore!
Download scripts here: view_IndexInformation.sql (for all DBs at once),...
Author: Pedro Lopes (PL) Date: 04/07/2012
SQL Server 2012 new high VLFs warning: Important update
Hello all, If you follow this blog, this is another post on VLFs, a topic I’ve covered several...
Author: Pedro Lopes (PL) Date: 03/25/2012
Free SQL Server 2012 eBook giveaway
Hello all, Just to give you the heads-up that Microsoft has made available a new free eBook entitled...
Author: Pedro Lopes (PL) Date: 03/18/2012
Ezequiel will be at the next SQLSaturday #115
Hi all, That’s right, Ezequiel will be presenting 3 sessions in the upcoming SQLSaturday in...
Author: Pedro Lopes (PL) Date: 03/13/2012
The SQL Swiss Army Knife #3 - View I/O per file - Updated
Hello all, Here is another one focusing on SQL scripts that may help on everyday DBA tasks,...
Author: Pedro Lopes (PL) Date: 03/08/2012
A case of seeks and scans
Hello all, A couple weeks ago while I was onsite, I was looking at some queries that had performance...
Author: Pedro Lopes (PL) Date: 02/18/2012
Antivirus Guidelines for SQL Server - KB 309422– It was Updated !
Hello all, We would like to ask for your attention for the fact that there was a good refresh...
Author: Luis Canastreiro [MSFT] Date: 02/10/2012
SQLAzure – “SQL Azure Compatibility Assessment” and “SQL Azure Security Services” Services
Hi, Recently, SQLAzure Labs released two projects that could help, in different aspects, on...
Author: Luis Canastreiro [MSFT] Date: 02/02/2012
SQL Server 2012 – AlwaysOn (HA/DR)
Hello All, There are out there lots of information, already, about the SQL Server 2012...
Author: Luis Canastreiro [MSFT] Date: 02/02/2012
SQL Server 2012 – Online Launch Event
Hello all, Don’t lose the opportunity to attend the SQL Server 2012 launch event! It will be...
Author: Luis Canastreiro [MSFT] Date: 02/01/2012
PowerPivot Security Architecture
Hi all, Today I was looking for some information about PowerPivot configuration in SharePoint 2010...
Author: Alexandre Mendeiros Date: 01/22/2012
T-SQL Misconceptions - JOIN ON vs. WHERE
Hello all, Last week while I was onsite, I was discussing with a customer about some T-SQL querying...
Author: Pedro Lopes (PL) Date: 01/15/2012
Three effective tips for Reporting Services management
Have you ever felt the need to check how your reporting services instances are in terms of health?...
Author: Alexandre Mendeiros Date: 01/15/2012
SQL Server 2012 RC0 Released
Hello all, Just to share with you a summary with the news, publicly available, about SQL Server 2012...
Author: Luis Canastreiro [MSFT] Date: 11/18/2011
Can PerformancePoint have interactive features?
Hi again, Do you know you can add interactive features to your dashboard in PerformancePoint with...
Author: Alexandre Mendeiros Date: 11/01/2011
How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)
Hello, In the past I posted the new SharePoint SP1 features for PerformancePoint Services which...
Author: Alexandre Mendeiros Date: 11/01/2011
The “rumor” is true: SQL Server 2012 has a new high VLFs warning (Edited).
Hello all, If you follow this blog, you know I blogged on VLFs several times before and if you want...
Author: Pedro Lopes (PL) Date: 10/12/2011
SQL Server 2008 SP3 RTM
Hi, Last week, it was released the SP3 of SQL Server 2008: SQL Server 2008 Service Pack 3...
Author: Luis Canastreiro [MSFT] Date: 10/10/2011
Auto Update Statistics Asynch - Are you really, really using it?
Hello all, It’s been awhile since I’ve updated the blog from my part. It’s been a...
Author: Pedro Lopes (PL) Date: 09/25/2011
What's new in Performance Point Services (SharePoint 2010 SP1)
Hi, In the continuation of our Business Intelligence series in our Ezequiel Blog, I’m making...
Author: Alexandre Mendeiros Date: 07/22/2011
SQL Swiss Army Knife #10 - VLFs again. What’s your current status?
EDIT (11-01-2011): A parenthesis was missing making the log_size_MB value skewed. Thanks Luis! EDIT...
Author: Pedro Lopes (PL) Date: 07/21/2011
Notes about SQL Server 2008 R2 SP1
Hi, The purpose of this post is to share some notes (links) about the recent release of SQL Server...
Author: Luis Canastreiro [MSFT] Date: 07/13/2011
MOSS, BizTalk, SCOM and SQL Server Collations
Hello all, The topic today is database and server collations. As part of pre-installation tasks for...
Author: Pedro Lopes (PL) Date: 07/07/2011
Adaptive Index Defrag
Latest update: 1/20/2017 (Check change log) Download on GitHub NOTE: if using SQL Server 2012 or SQL...
Author: Pedro Lopes (PL) Date: 07/03/2011
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....
Author: Alexandre Mendeiros Date: 05/26/2011
SQL Swiss Army Knife #9 - Fixing VLFs
Download script here: Fix_VLFs.sql Hello all, Here is another post on SQL scripts that may help...
Author: Pedro Lopes (PL) Date: 05/24/2011
SQLPort – XI Event – Don’t Miss it !!!
Hello all, SQLPort, Portuguese chapter of SQLPass, is organizing one more event, the XI one...
Author: Luis Canastreiro [MSFT] Date: 05/12/2011
Can log files growth affect DML? Post-CU Update
Hello all, A while back I blogged on how log files can affect DML performance, depending on their...
Author: Pedro Lopes (PL) Date: 04/25/2011
Metro Early Adopter Program for SQL Server Code Name “Denali”
Hello all, Review the new video about the Metro Early Adopter Program for SQL Server Code...
Author: Luis Canastreiro [MSFT] Date: 04/05/2011
SQL Swiss Army Knife #8 - Find a Maintenance Window
Hello all, So this another post on SQL scripts for DBAs, following the series "SQL Swiss Army...
Author: Pedro Lopes (PL) Date: 03/22/2011
SQL Swiss Army Knife #7 - Adaptive Index Defrag
Hello all, Sorry for the inconvenience, but the content of this post moved to the Adaptive Index...
Author: Pedro Lopes (PL) Date: 03/10/2011
Loose notes on FILESTREAM…
Hello all, Following a previous post on the subject, here are a few things you should be attentive...
Author: Pedro Lopes (PL) Date: 02/15/2011
Best Practices on FILESTREAM implementations
Hello all, Recently I was asked to advise a customer on a FILESTREAM implementation he was devising,...
Author: Pedro Lopes (PL) Date: 02/11/2011
Latest updates available are…
Hello all, Because in the last 30 days some major updates were released for several versions of SQL...
Author: Pedro Lopes (PL) Date: 01/18/2011