Welcome to TechNet Blogs Sign in | Join | Help

There's Something about SQL!

...SQL Server, BI and other Cool Technology...

April 2008 - Posts

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 information. Read 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 through Read More...
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 Hardware Read More...
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 contain Read More...
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 Read More...
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 Read More...
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 (most Read More...
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: · Read More...
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. Read More...
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 . The Read More...
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 the evening Read More...
Page view tracker