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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice Date: 05/19/2009

Troubleshooting Performance Problems in SQL Server 2008

A new great whitepaper to bookmark amongst your favourites: Troubleshooting Performance Problems in...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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,...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice Date: 11/05/2008

I'm at TechEd ItPro - Barcelona!

This week I'm presenting on SQL Server 2008 Resource Governor @TechEd Barcelona...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice Date: 10/01/2008

Latest Microsoft Security Bulletin (MS08-052 - Vulnerabilities in GDI+ Could Allow Remote Code...

Author: beatrice 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...

Author: beatrice Date: 08/29/2008

Full Backups & Transaction Logs Backup

A general misconception when it comes to transaction log management, is that the transaction log...

Author: beatrice 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...

Author: beatrice Date: 07/23/2008

I've posted a blog entry some time ago about Microsoft recommendation for SQL Server SP2 builds: SQL...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice 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...

Author: beatrice Date: 06/04/2008

As you might (or might not?) know, since SQL Server 2005 the SQL Server team has moved away from the...

Author: beatrice Date: 05/27/2008

SQL Nexus

I blogged some time ago about PAL (Performance Analysis of Logs (PAL) Tool), a great tool from...

Author: beatrice 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...

Author: beatrice Date: 04/29/2008

Self-Service Hotfixes

Microsoft has recently introduced a new process to receive Hotfixes which I thought useful for...

Author: beatrice 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...

Author: beatrice Date: 04/21/2008

SQL 2005 SP3 Announced!

Yesterday, Francois Ajenstat, Microsoft 's director of SQL Server marketing, announced that...

Author: beatrice Date: 04/16/2008

Next>