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";
SQL Server Support, Failover Clustering and Virtualization
On May 19th, Microsoft has updated the Support Policy for Microsoft SQL Server products that are...
Date: 05/22/2009
Whitepaper - Disk Partition Alignment Best Practices for SQL Server
I've blogged some time ago about Microsoft recommendations for maximizing the performances of your...
Date: 05/20/2009
Old MPS Reports Dismissed - New Version Ready!
A new version of MPS Reports has been released late April, at the following link: Microsoft Product...
Date: 05/19/2009
Troubleshooting Performance Problems in SQL Server 2008
A new great whitepaper to bookmark amongst your favourites: Troubleshooting Performance Problems in...
Date: 04/15/2009
Download SQL Server 2008 SP1
SQL Server 2008 SP1 final version has been released. It contains all the announced great new...
Date: 04/11/2009
I' back to Italy... and I'm loving IT!
Well well, long time without posting once again. This time I have a good enough reason… which is my...
Date: 04/11/2009
SQL Server 2008 Service Pack 1 (SP1) CTP
Just woke up ready to celebrate my birthday (do not try to ask a woman how old she is :-P) and...
Date: 02/24/2009
SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update
If you recently found yourself in installing latest SQL Server 2005 Security Update (you did...
Date: 02/19/2009
DBCC DBREINDEX (aka INDEX REBUILD in 2005) and Statistics Update
So - today I've been made this question. "I have a DB, AUTO_UPDATE_STATISTICS option OFF (very bad...
Date: 02/13/2009
Microsoft Security Bulletin MS09-004 – Important
For your joy (and especially for the joy of my customer :)) yesterday Microsoft has released a new...
Date: 02/11/2009
Best Practices for installing SQL Server service packs, hotfixes, cumulative updates
There isn't much information around (other than the readme for service packs) on which are the best...
Date: 02/10/2009
W-Tech 2009 - London, 3rd February 2009!
Next week I am going to present at this year's W-Tech event, which is due to be in London next week,...
Date: 01/28/2009
Are you based in Manchester? Two upcoming FREE SQL events for your agenda!
If you are based in Manchester or nearby, there are two interesting FREE SQL Server events planned...
Date: 01/22/2009
FREE e-book: Introducing Microsoft SQL Server 2008
A great opportunity to download (for FREE :-)) Introducing Microsoft SQL Server 2008 by Peter...
Date: 01/15/2009
How To - Proactively Know Upcoming SQL Server CUs and SPs
Umh, it has been a long time since my last post. I must admit, I've had brilliant holidays (relax...
Date: 01/13/2009
Released - Cumulative Update Package 1 for SQL Server 2005 Service Pack 3
Microsoft has just shipped the first Cumulative Update for SQL Server 2005 SP3. This CU contains...
Date: 12/20/2008
SQL Server 2005 SP3 is out!
Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035) is now available and ready to...
Date: 12/16/2008
Resource Governor Demos
If you are looking for some demos to play and learn about Resource Governor, you should have a look...
Date: 12/05/2008
Data & Backup Compression (Part 3) - Tests, Numbers and Tuning Tips
One of the most common question I've received regarding data and backup compression in SQL Server...
Date: 12/03/2008
How to: Troubleshoot SQL Server 2008 Features
This is a nice section in 2008 Books On Line which I just found and wanted to blog about - mainly...
Date: 12/02/2008
SQL Server 2008 Upgrade Technical Reference Guide
The SQL Server 2008 Upgrade Technical Reference Guide is now Live and available to download. It is a...
Date: 11/27/2008
X64, Lock Pages in Memory and AWE - Should I or Should I Not?
I've heard this question thousands of times so I've thought to try to summarize some recommendation...
Date: 11/26/2008
The Hidden Database in SQL Server 2005 and 2008
Have you ever had to move your master database? Or have you ever opened the folder which contains...
Date: 11/19/2008
Performance Monitor, SQL Counters and Tresholds
Whilst surfing on the web last week, I've found this very nice blog from Vipul Shah, which happens...
Date: 11/17/2008
Reading User Group Meeting - 20th Nov
For those which live or work close to Reading - there will be a UserGroup on the 20th Evening held...
Date: 11/12/2008
PPT Plex add on for Power Point - Cool!
PPT Plex is a new tool - or more precisely - a new add on for Microsoft Power Point - which will...
Date: 11/11/2008
SQL Server and Virtualization - can we help?
Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in...
Date: 11/06/2008
TechEd ItPro - SQL Server 2008 Resource Governor!
Wow! Presenting at TechEd yesterday had been one of the best experiences of my life! Being in front...
Date: 11/05/2008
I'm at TechEd ItPro - Barcelona!
This week I'm presenting on SQL Server 2008 Resource Governor @TechEd Barcelona...
Date: 11/02/2008
Announcing SQL 2005 SP3 Beta
SQL Server 2005 Service Pack 3 (SP3) is now available for public testing; a final release version...
Date: 10/30/2008
SQL Server 2008, Cumulative Updates and... Slipstream
I've posted some time ago about Slipstream of Service Packs on SQL Server 2005 - which was and is...
Date: 10/01/2008
SQL Server 2000 and 2005 - Recommended Builds - (another) update
Latest Microsoft Security Bulletin (MS08-052 - Vulnerabilities in GDI+ Could Allow Remote Code...
Date: 09/18/2008
3GB PAE and AWE - Taking away (some) confusion...
It's a long time since I wanted to post some info concerning memory on this blog, but I always been...
Date: 08/29/2008
Full Backups & Transaction Logs Backup
A general misconception when it comes to transaction log management, is that the transaction log...
Date: 07/24/2008
BackupRestore & Corruption – What is worth to know
Just being discussing recently the Backup\Restore best practices (related to corruption) and wanted...
Date: 07/23/2008
SQL Server 2005 SP2 - Recommended Build - Update
I've posted a blog entry some time ago about Microsoft recommendation for SQL Server SP2 builds: SQL...
Date: 07/18/2008
Assess your System (Part 2of3) - SQL BPA
As a second tool to assess your system configuration, today I am going to post about SQL Server BPA...
Date: 07/02/2008
Assess your System (Part 1of3) Microsoft Baseline Security Analyzer
Today I want to post about three very useful free tools from Microsoft which can assist you in...
Date: 06/12/2008
Data and Backup Compression in SQL 2008 (Part 2)
After my follow-up post about our SQL Server 2008 event in TVP, where I've presented about SQL...
Date: 06/11/2008
SQL Server - Speed up your Disks!
I've already blogged some time ago about Microsoft recommendation for SQL Server Storage Best...
Date: 06/09/2008
SQL 2008 OpsDay - Data and Backup Compression
Hi all, Just wanted to thank all the attendees that participated to yesterday's event on SQL Server...
Date: 06/06/2008
Ms Store Launches in UK!
On the 2nd June 2008 Microsoft announced the launch of Microsoft Store in the UK. Microsoft Store...
Date: 06/04/2008
SQL Server 2005 SP2 - Recommended Build?
As you might (or might not?) know, since SQL Server 2005 the SQL Server team has moved away from the...
Date: 05/27/2008
SQL Nexus
I blogged some time ago about PAL (Performance Analysis of Logs (PAL) Tool), a great tool from...
Date: 05/06/2008
SQL Server Default Trace
I've just realized how poorly documented is this great functionality that has been introduced in SQL...
Date: 04/29/2008
Self-Service Hotfixes
Microsoft has recently introduced a new process to receive Hotfixes which I thought useful for...
Date: 04/25/2008
To NUMA or not to NUMA
There is always some confusion when it comes to NUMA and few information on which are Microsoft...
Date: 04/21/2008
SQL 2005 SP3 Announced!
Yesterday, Francois Ajenstat, Microsoft 's director of SQL Server marketing, announced that...
Date: 04/16/2008