Share via


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

<Previous Next>