Browse by Tags
All Tags »
How To »
SQL Server (RSS)
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...
If you recently found yourself in installing latest SQL Server 2005 Security Update (you did installed it right?): Microsoft Security Bulletin MS09-004 – Important http://www.microsoft.com/technet/security/bulletin/MS09-004.mspx ..and had a look to the
Read More...
So - today I've been made this question. "I have a DB, AUTO_UPDATE_STATISTICS option OFF (very bad idea, anyway :-)), I rebuild my indexes every week. I do not have major changes in my database. As update statistics with fullscan is a side effect of DBCC
Read More...
There isn't much information around ( other than the readme for service packs ) on which are the best practices on installing Service Packs, Cumulative Updates, Hotfixes on SQL Server installation. ...well till today really :-) This is nothing official
Read More...
Umh, it has been a long time since my last post. I must admit, I've had brilliant holidays (relax and skiing) followed by a very bad flue, which summed up with all the XMas parties of 2008 makes 3 weeks without any post on my professional blog :-). Well,
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...
I've heard this question thousands of times so I've thought to try to summarize some recommendation in this blog post. For 32 bits , things are pretty straight-forward. If they are not, I've posted some comments some time ago: \3GB \PAE and AWE - Taking
Read More...
Whilst surfing on the web last week, I've found this very nice blog from Vipul Shah, which happens to be a Microsoft colleague, which explains which are the key performance counters to monitor for your SQL Server instances and most importantly summarizes
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...
It's a long time since I wanted to post some info concerning memory on this blog, but I always been confused on where to start from. To take away any doubt, let's start from scratch. Even amongst the most seasoned DBAs there is some confusion about memory
Read More...
As a second tool to assess your system configuration, today I am going to post about SQL Server BPA (another acronym!) aka SQL Server Best Practices Analyser (better). We have 2 versions available: - one for SQL Server 2000 ( http://www.microsoft.com/downloads/details.aspx?familyid=b352eb1f-d3ca-44ee-893e-9e07339c1f22&displaylang=en
Read More...
Today I want to post about three very useful free tools from Microsoft which can assist you in automating the process of assessing your systems : - MBSA (Microsoft Baseline Security Analyzer) - SQL BPA (Best Practice Analyzer) for SQL 2000 and 2005 -
Read More...
