See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
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";
Microsoft Business Intelligence
SQL Server 2008
Browse by Tags
There's Something about SQL!
Script to Create SQL Snapshots
I recently came across the need to automate the creation of snapshots in SQL Server 2005, and thought might be useful to share the script I've used, which is the following: CREATE PROC dbo . spCreateSnapshot ( @Database sysname , @Snapshot sysname , @Path nvarchar ( max )) AS CREATE...
12 May 2009
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. When you raise a case with Microsoft Support in...
4 Apr 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 (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...
2 Jul 2008
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 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 DBREINDEX (aka INDEX REBUILD in 2005), can...
13 Feb 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 Support Reports http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en Amongst the main differences: With the new MPS reports...
19 May 2009
SQL Server - Speed up your Disks!
I've already blogged some time ago about Microsoft recommendation for SQL Server Storage Best Practices . Is there anything else you should be aware in order to maximise the performances of your disk subsystem ? Oh yeah. Volume Alignment (Or Sector Alignment) and NTFS Allocation Unit Size...
9 Jun 2008
SQLIOSim is a great utility to perform tests on disk subsystems. These tests simulate read, write, checkpoint, backup, sort, and read-ahead activities for Microsoft SQL Server. The SQLIOSim utility has been upgraded from the SQLIOStress utility and more accurately simulates the I/O patterns of Microsoft...
20 Apr 2007
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 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 of SQL Server 2000 and 2005 to SQL...
27 Nov 2008
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. Looking outside the Microsoft...
29 Apr 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 automating the process of assessing your systems : - MBSA (Microsoft Baseline Security Analyzer) - SQL BPA (Best Practice Analyzer) for SQL 2000 and 2005 - Policy Management (automatically included...
12 Jun 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 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 are actually many other troubleshooting...
2 Dec 2008
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 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, if anybody out there had missed me, here...
13 Jan 2009
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 and Software NUMA - and some useful...
21 Apr 2008
Resource Governor Demos
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...
5 Dec 2008
How to: Run MPS Reports (SQL) on SQL Server 2000 SP4
MPS Report is one of the standard tools used by Microsoft Support to facilitate the gathering of critical system and logging information ( view ). If you run it on Microsoft SQL Server 2000 Service Pack 4 though, you'll receive a Buffer Overrun check dialog box, as in the following image: ...
26 Feb 2007
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 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 known issues page... You might...
19 Feb 2009
SQL Server and Virtualization - can we help?
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 you opt for virtualization you are in a safe...
6 Nov 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 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 away (some) confusion http://blogs...
26 Nov 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 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 , so we should try first to clarify these...
29 Aug 2008
I blogged some time ago about PAL ( Performance Analysis of Logs (PAL) Tool ), a great tool from CodePlex which allows you to quickly and automatically analyze a set of Performance Monitor logs and to easily spot which counters are "misbehaving" in your environment. This week I want to post about...
6 May 2008
Troubleshooting Performance Problems in SQL Server 2008
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 common performance problems by...
15 Apr 2009
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 2008 in TVP - Reading. We've received great feedback on the content of the day, and I really hope everybody went back home (for some of you I heard it was quite a long way) sure that SQL Server...
6 Jun 2008
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 figured out that we've had the registry corrupted...
11 Apr 2008
Resource Governor - How to get started?
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 loved it :-)? Yeah, I guess too much already...
10 Nov 2008
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 practices on installing Service Packs, Cumulative Updates, Hotfixes on SQL Server installation. ...well till today really :-) This is nothing official from Microsoft but still the following...
10 Feb 2009
© 2014 Microsoft Corporation.
Privacy & Cookies