Blog do Ezequiel
  SQL Server Insights
 

 


Latest Updates
06/02/2015 - Latest update on the AdaptiveIndexDefrag procedure v1.6.1. Look for it in the "Ezequiel shortcuts" section on the right or just click HERE.

11/03/2015 - Updates to Maintenance plan deployment scripts available HERE

17/05/2015 - The SQL Swiss Army Knife Series Index
  • 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

    • 6 Comments

    EDIT (11-01-2013):  Fixed issue with generating all logins even when single database was chosen.
    EDIT (17-05-2015): Fixed duplicate permissions scripted with Procedures/Functions/CLR; Extended object coverage.

    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...
  • Blog do Ezequiel

    TechDays 2010

    • 0 Comments
    Hi all, TechDays 2010 will be happening next week (20-22 of April) at Lagoas Park – Building 14, see more details on the official website - http://www.techdays2010.com/ . With this great new about the official launch of SQL Server 2008 R2 that is going...
  • Blog do Ezequiel

    Microsoft SQL Azure

    • 0 Comments
    The CTP 2 of SQL Azure was released last week at PASS event. http://www.microsoft.com/windowsazure/sqlazure/ But what is SQL Azure? – To get a quick answer for this question check this video . Check this document that have an overview about SQL Azure...
  • Blog do Ezequiel

    SQL Server 2008 R2 – November CTP

    • 0 Comments
    Hi all, At PASS Event, last week, it was released the latest CTP of SQL Server 2008 R2, the November CTP: http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx http://www.microsoft.com/sqlserver/2008/en/us/R2-Next.aspx This CTP is available for download...
  • Blog do Ezequiel

    Latest Cumulative Updates for SQL Server

    • 0 Comments
    Hi all, These are the latest Cumulative Updates available for SQL Server – based on the actual date 18/11/2009: SQL Server 2008 Supported Build Latest Cumulative Update Link RTM(*) 8 http://support.microsoft.com/kb/975976 SP1 5 http://support.microsoft...
  • Blog do Ezequiel

    Project “Gemini” or just PowerPivot 2010

    • 0 Comments
    Hello, Some weeks ago, Microsoft, announced the official name of the project with codename “Gemini” – PowerPivot for Excel 2010 – www.powerpivot.com . PowerPivot for Excel 2010 http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini...
  • Blog do Ezequiel

    Information about the SNAC package and Cumulative Updates

    • 0 Comments
    Hello, When you follow the steps to download a SQL Server 2005 (SP2/SP3) or SQL Server 2008 (RTM/SP1) cumulative update, you see a list of packages where you need to chose which ones you want to download and, normally, you have doubts about which one...
  • Blog do Ezequiel

    Security Update – MS09-062

    • 0 Comments
    Hello, Normally, two releases of a SQL security update are released: GDR (General Distribution Release) QFE (Quick Fix Engineering) The GDR release must be applied to all the SQL Server instances that keeps the RTM build or for the cases where only a...
  • Blog do Ezequiel

    New white papers for SQL Server were released

    • 0 Comments
    Hello, New white papers where published for SQL Server 2008: Consolidation Using SQL Server 2008 High Availability with SQL Server 2008 Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services Using the Microsoft...
  • Blog do Ezequiel

    SQL Server 2008 Failover Clustering White Paper

    • 0 Comments
      Hello SQL Nation, A new white paper is available for SQL Server 2008. This time about the SQL Server 2008 Failover Clustering feature. Look at the SQL CAT Team web site:   http://sqlcat.com/whitepapers/archive/2009/07/08/sql-server-2008-failover...
  • Blog do Ezequiel

    SQL Server 2005 – Performance Dashboard installation steps

    • 0 Comments
    Hi, To get the Performance Dashboard for SQL Server 2005 installed you must follow these steps: 1. Download the installation package from Microsoft Web Site: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang...
  • Blog do Ezequiel

    SQL Server 2008 - Slipstream

    • 0 Comments
    Hi, To build a slipstreamed version of the SQL Server 2008 setup, please, take a look in the following links: How to update or slipstream an installation of SQL Server 2008 http://support.microsoft.com/kb/955392 SQL Server 2008 Slipstream Frequently Asked...
  • Blog do Ezequiel

    SQL Server 2005/2008 – How to know which are the latest builds available?

    • 0 Comments
    Hi, It is very common to have doubts about the last build or the latest Cumulative Update available for SQL Server 2005 and 2008. These two tables represent the actual situation (1/7/2009): SQL Server 2005   Supported Build Last Cumulative Update...
  • Blog do Ezequiel

    SQL Server 2008 - Cumulative Update 4

    • 3 Comments
    Hi, Yesterday, it was released the Cumulative Update 4, for SQL Server 2008 (RTM), build number 10.00.1798: http://blogs.msdn.com/sqlreleaseservices/archive/2009/03/16/cumulative-update-4-for-sql-server-2008-rtm.aspx This is the KB article link, where...
Page 4 of 5 (121 items) 12345