Browse by Tags
All Tags »
SQL Server 2008 (RSS)
On May 19th, Microsoft has updated the Support Policy for Microsoft SQL Server products that are running in a hardware virtualization environment , which you can find at the following link: http://support.microsoft.com/kb/956893/en-us The main update
Read More...
I've blogged some time ago about Microsoft recommendations for maximizing the performances of your disks subsystem for a SQL Server implementation : SQL Server - Speed up your Disks! http://blogs.technet.com/beatrice/archive/2008/06/09/sql-server-speed-up-your-disks.aspx
Read More...
A new version of MPS Reports has been released late April, at the following link: Microsoft Product Support Reports http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en Amongst the main differences:
Read More...
A new great whitepaper to bookmark amongst your favourites: Troubleshooting Performance Problems in SQL Server 2008 http://msdn.microsoft.com/en-us/library/dd672789.aspx This documentation provides step-by-step guidelines for diagnosing and troubleshooting
Read More...
SQL Server 2008 SP1 final version has been released. It contains all the announced great new features that we were all looking forward to, especially the slipstream and uninstall ones, which could save a lot of time (and headhackes) at installation time.
Read More...
Just woke up ready to celebrate my birthday (do not try to ask a woman how old she is :-P) and discovered the CTP version of SQL Server 2008 Service Pack 1 (SP1) is now available. Hum, well, I will check it out but definitely not today I am afraid as
Read More...
A great opportunity to download (for FREE :-)) Introducing Microsoft SQL Server 2008 by Peter DeBetta, Greg Low, and Mark Whitehorn Learn about major new features in SQL Server 2008 including security, administration, and performance. Chapter 1: Security
Read More...
Service Pack 3 for Microsoft SQL Server 2005 (build number 9.00.4035 ) is now available and ready to download at http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en . A complete List of the
Read More...
If you are looking for some demos to play and learn about Resource Governor, you should have a look to the SQL Server SQLOS team blog , which has posted a couple of interesting ones. 1) Anatomy of SQL Server 2008 Resource Governor CPU Demo http://blogs.technet.com/sqlos/archive/2007/12/14/part-1-anatomy-of-sql-server-2008-resource-governor-cpu-demo.aspx
Read More...
One of the most common question I've received regarding data and backup compression in SQL Server 2008 is related to achievable results in terms of performance and compressio-ratio on very large databases. I've just found some interesting data published
Read More...
This is a nice section in 2008 Books On Line which I just found and wanted to blog about - mainly for my reference so that I can quickly find it when needed ;-) I've found it whilst looking for recommendations to troubleshoot Resource Governor, but there
Read More...
The SQL Server 2008 Upgrade Technical Reference Guide is now Live and available to download. It is a 490-page white paper (hold on, do not get scared, you don't need to read it all :-)) which covers the essential phases and steps to upgrade existing instances
Read More...
For those which live or work close to Reading - there will be a UserGroup on the 20th Evening held in TVP - Microsoft Offices. Agenda: 6pm – 6:30 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:30pm – 7 Round Table discussion
Read More...
Here we are, as promised, with some rumblings on SQL Server 2008 Resource Governor . I've played a lot with the various options which this features provides, especially in preparation of my TechEd presentation last week! Did I ever mention how much I
Read More...
Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in a hardware virtualization environment are not much known as yet to the majority of the public. Therefore the PFE in me :-) wants to be sure that when
Read More...
