There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

April, 2008

  • SQL Server Default Trace

    I've just realized how poorly documented is this great functionality that has been introduced in SQL Server 2005 . On the Microsoft Website, all you can find is this article ( http://technet.microsoft.com/en-us/library/ms175513.aspx ) and few more...
  • Self-Service Hotfixes

    Microsoft has recently introduced a new process to receive Hotfixes which I thought useful for everybody to know about. Up to now, customers had to call CSS to obtain any of these fixes, while Premier customers were already able to download them...
  • To NUMA or not to NUMA

    There is always some confusion when it comes to NUMA and few information on which are Microsoft recommended best practices especially when dealing with SQL Server. In this post I've tried to summarize the main considerations you should do concerning...
  • SQL 2005 SP3 Announced!

    Yesterday, Francois Ajenstat, Microsoft 's director of SQL Server marketing, announced that Microsoft will deliver SQL Server 2005 SP3 after the release to manufacturing of SQL Server 2008, which is currently slated for Q3. The service pack will...
  • Visual Studio and SQL Server 2008 Certifications - Save 40%

    I've already blogged some time ago about Microsoft Second Shot Offer - which allows you to take a second shot at any IT professional, developer, or Microsoft Dynamics certification exam and has been extended until June 30th, 2008: Microsoft Certifications...
  • Missing SQL OLE DB Providers?

    Just came across an issue on installing Litespeed from Quest http://www.quest.com/litespeed-for-sql-server/ on a Windows 2003 64 Bit environment . Litespeed in fact requires Microsoft OLE DB Provider for SQL Server, and after some troubleshooting we've...
  • Microsoft Product Team Blog Directory

    Daniel, a colleague and friend of mine, has put together an incredibly comprehensive li st of Microsoft Product Team Blogs which is very useful for every IT Professional working with Microsoft technologies. I've already uploaded the SQL Server ones...
  • Collection of SQL Server Storage Best Practices

    When installing your SQL Server, 2000 or 2005, do never forget to check the recommended configuration of your storage space. I’ve collected over time a series of useful information regarding SQL Server Storage Best Practices , which are as follows...
  • Save time when contacting Microsoft Support for a SQL-Related issue!

    Something I should have blogged about some time ago, to save time to myself to send out information when I help my customer to raise a case with Microsoft Support (or to have a review of the system done by me) and to save time to the customer himself...
  • Performance Analysis of Logs (PAL) Tool

    I’ve just tried out this tool that is fantastic! It automatically analyzes a performance monitor output log and generates a HTML based report which graphically charts important performance counters and throws alerts when thresholds are exceeded . ...
  • UK SQL UG April Events – London and Edinburgh

    A new series of events is coming soon in London and Edinburgh, from the UK SQL Server User Group . Amongst the speakers there will be my friend and ex-colleague Christian Bolton ( http://sqlblogcasts.com/blogs/christian/ ), which will present on...