Blog do Ezequiel
Portuguese PFE SQL Server Team


Latest Updates
10/05/2014 - Latest update on the AdaptiveIndexDefrag procedure v1.5.8. Look for it in the "Ezequiel shortcuts" section on the right or just click HERE.

10/05/2014 - Updates to Maintenance plan deployment scripts available HERE

04/06/2014 - The SQL Swiss Army Knife Series Index
  • Blog do Ezequiel

    SQL Swiss Army Knife #8 - Find a Maintenance Window

    • 0 Comments
    Hello all, So this another post on SQL scripts for DBAs, following the series "SQL Swiss Army Knife". This time with a way to “guesstimate” (heard this a while ago) the availability window on a server. Note that this is only usable from SQL...
  • Blog do Ezequiel

    SQL Swiss Army Knife #7 - Adaptive Index Defrag

    • 2 Comments
    Hello all, Sorry for the inconvenience, but the content of this post moved to the Adaptive Index Defrag post .
  • Blog do Ezequiel

    Loose notes on FILESTREAM…

    • 0 Comments
    Hello all, Following a previous post on the subject, here are a few things you should be attentive when planning a FILESTREAM implementation. …Security There are two security requirements for using the FILESTREAM feature: SQL Server...
  • Blog do Ezequiel

    Best Practices on FILESTREAM implementations

    • 3 Comments
    Hello all, Recently I was asked to advise a customer on a FILESTREAM implementation he was devising, and part of that ended up becoming this blog post that I hope can be of some help for you. When to use FILESTREAM? In SQL Server, BLOBs can be...
  • Blog do Ezequiel

    Latest updates available are…

    • 0 Comments
    Hello all, Because in the last 30 days some major updates were released for several versions of SQL Server (from which the last two listed here were released just last night), this serves as a quick gather of the ones available. Remember that CUs...
  • Blog do Ezequiel

    SQL Server 2008 R2 – New White Papers

    • 3 Comments
    Hello all, New white-papers were released: SQL Server 2008 R2 Upgrade Technical Reference Guide – Link . SQL Server 2008 R2 Security Best Practices – Link . Cheers,
  • Blog do Ezequiel

    The SQL Swiss Army Knife #6 - Evaluating compression gains

    • 0 Comments
    Hello all, Here is another one focusing on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". This time we are evaluating table and index compression , specifically an approach on how to select the best compression method for...
  • Blog do Ezequiel

    Happy new year!

    • 0 Comments
    Still 10pm, and just in time to wish all a happy new year from all the Portuguese SQL PFE team! So just keep this snippet in mind for next year: SELECT [success] FROM tblYear2011 See you next year!
  • Blog do Ezequiel

    The SQL Swiss Army Knife #5 - Checking Autogrow times

    • 5 Comments

    Hello all,
    Here is another one focusing on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". This time we are exploring an alternative way of verifying autogrow times besides checking the ErrorLog for any recorded information, and that is when an error 5144 or 5145 occurs.

    ...
  • Blog do Ezequiel

    SQL Server vNext – Codename “Denali” and much more …

    • 1 Comments
    Hello all, This week it was announced the first CTP of the next version of SQL Server (Codename “Denali”) and the 1st Release of SQL Server Parallel Data Warehousing (PDW) at SQLPASS, Seattle. On the following table you can find a resume of the new features...
  • Blog do Ezequiel

    The SQL Swiss Army Knife #4 - Making sense of FILESTREAM containers

    • 1 Comments

    Hello all,

    Here is another one focusing on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". This time we are exploring FILESTREAM.

    ...
  • Blog do Ezequiel

    Can log files growth affect DML?

    • 8 Comments

    Hello all,

    A while back I blogged here about how a good strategy of log file growth could potentially impact ongoing operations with your SQL Server. It’s known that VLFs (number and size) impact on the performance of such actions as scanning all VLFs for transactions that are marked for replication or log backup operations. Following that blog post, I became curious as to how having a poor strategy could potentially impact some less than obvious operations within SQL Server and decided to put that to a test..

    ...
  • Blog do Ezequiel

    SQL Server 2008 SP2 is out!

    • 0 Comments
    The SQL Server 2008 SP2 has major improvements that include integration of reporting services with SharePoint products and several management improvements. This final version of the Service Pack 2 includes new compatibility features with SQL Server 2008...
  • Blog do Ezequiel

    SQL Swiss Army Knife #2.1 - Scripting Logins - Updated

    • 0 Comments

    EDIT (20-09-2012) - Added several scripting options; does not use SQL Server 2000 system tables anymore.

    EDIT (11-01-2013) - Fixed issue with permission syntax depending on version (2005 vs. 2008/2012).

    EDIT (18-03-2013) - Fixed issue with undeclared variable in cursor; Added options for access.

    Hello all,

    Here is another posting focusing on SQL scripts that may help on everyday DBA tasks, following the series "SQL Swiss Army Knife". This is another example of a script I've been using as a "local machine" bit of a wider DR strategy, in this case generating all logins and their respective server roles. Note that this does not deal with CERTIFICATE_MAPPED_LOGIN and ASYMMETRIC_KEY_MAPPED_LOGIN types.
    These are the options available:

    • All users:
      EXEC usp_logins
    • One user, All DBs:
      EXEC usp_logins '<User>'
    • One user, One DB:
      EXEC usp_logins '<User>', '<DBName>'
    • All users, One DB:
      EXEC usp_logins NULL, '<DBName>'
    ...
  • Blog do Ezequiel

    SQL Server and Log File usage

    • 1 Comments
    Hello all, I decided to talk about an issue I've recently dug a little deeper, and so i will talk about how and why Log files (and their growth strategy) affect recovery times, mirroring, replication, large data changes (batches), leads to disk fragmentation...
  • Blog do Ezequiel

    SQLPort – 1st Event – Summary

    • 0 Comments
    Hi, First of all, I would like to say thanks to everyone that had attend this 1st Event. It was a great demonstration of your interest in SQL Server and at the same time in the SQLPort initiative! Please, if you aren’t part of the community yet, go and...
  • Blog do Ezequiel

    SQL Server Setup Portal–Released Today!

    • 0 Comments
    Hello, I would like to inform you that a specialized site about the SQL Server Setup was released today: http://technet.microsoft.com/en-us/sqlserver/ff625277.aspx Including information about SQL Server 2008 and SQL Server 2008 R2. Enjoy and let us know...
  • Blog do Ezequiel

    SQLPort – 1st Event – May 11th @Microsoft, Taguspark

    • 0 Comments
    Hi all, Next week, 11th of May, the Portuguese SQL Community – www.sqlport.com – will present the 1st Event @Microsoft, Taguspark, 18:30. SQLPort Community and Blog Ezequiel Members would like to invite you, firstly to register at SQLPort web site: To...
  • Blog do Ezequiel

    Operations Day (T-26 days) – May 31 – @Microsoft

    • 0 Comments
    Hi all, We would like to announce that on the next day – 31/05/2010 the PFE team, including some Ezequiel members are going to present an event named “Operations Day” to the Portuguese Microsoft Premier Customers, @Microsoft Main Office, @Lisboa. This...
  • Blog do Ezequiel

    The SQL Swiss Army Knife #1 - Scripting Securables - Updated

    • 3 Comments

    EDIT (11-01-2013):  Fixed issue with generating all logins even when single database was chosen.

    Hello all,

    I've recently joined the PFE team in Portugal, and one part of the job i like is giving something back to the community.
    Whenever possible, i will be focusing my posts on SQL scripts that may help on everyday DBA tasks, something in the likes of a "SQL Swiss Army Knife".
    According to BOL, SQL securables "are the resources to which the SQL Server Database Engine authorization system regulates access".

    ...
  • Blog do Ezequiel

    SQLPORT – Launched Today – Registration is Open!

    • 0 Comments
    Hello all, It was launched today, @Techdays 2010 event, the Portuguese SQL Server Community – SQLPort.com . Please, go and register yourself on the website http://www.sqlport.com , lets create a strong SQL community. The first initiative of the community...
  • Blog do Ezequiel

    SQL Server 2008 R2 – RTM

    • 0 Comments
    Hello all, SQL Server 2008 R2 RTM was officially launched: http://blogs.technet.com/dataplatforminsider/archive/2010/04/21/sql-server-2008-r2-released-to-manufacturing.aspx Look at www.sqlserverlaunch.com for more details about the release of this new...
  • Blog do Ezequiel

    TechDays 2010 – Thanks

    • 0 Comments
    Good Morning, I would like to let here a BIG THANKS to everyone that had attend to my sessions, yesterday. On the next days I’ll be posting about the topics covered during those sessions. Thanks for your comprehension, Luís.
  • Blog do Ezequiel

    SQL Server 2008 R2 – Free Ebook

    • 0 Comments
    Hi all, A free Ebook, about SQL Server 2008 R2 and the new features included on the product, was released by Microsoft Press and it is available here: http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server...
  • Blog do Ezequiel

    SQLPORT – SQL Server Portuguese Community

    • 0 Comments
    Hi all, One more great initiative will be starting next week, SQLPort , the Portuguese SQL Server User Group community that is going to be member of SQL Pass , world wide well-known community. At Techdays 2010 and with the expected presence of Douglas...
Page 3 of 5 (109 items) 12345