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
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 only hotfixes that were released in Cumulative Update 10 for SQL Server 2005 Service Pack 2 and Cumulative Update 11 for SQL Server 2005 Service Pack 2. These hotfixes are not included in SQL Server...
20 Dec 2008
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
Full Backups & Transaction Logs Backup
A general misconception when it comes to transaction log management, is that the transaction log gets automatically TRUNCATED (underlined, as I am not saying SHRINKED!!!) when a full database backup is performed. This is completely untrue , and if you just don't believe it, just open Management...
24 Jul 2008
New: TechNet Virtual Labs on SQL Server 2005
New TechNet Virtual Labs on SQL Server 2005 have been uploaded! They require no setup or installation, and they are completely for free! Choose the ones that you need to improve your skills today: • SQL Server Business Intelligence: Report Builder • SQL...
8 Jan 2007
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
Webcasts on SQL Server 2005 - New Entries!
Just a quick update on the next webcasts available for SQL Server 2005 (and Sharepoint Services v3)! SQL Server 2005 SP2 Tools and Improvements (Level 200) Event Overview: In this webcast, we discuss the broad range of tools available for Microsoft SQL Server 2005 Service Pack 2 (SP2)...
7 Mar 2007
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
Are you Vista_Ready? Remember to Upgrade your MSDE!
Microsoft SQL Server 2000 Desktop Engine (MSDE) will not be supported on Windows Vista. If Vista compatibility is essential for your business, the solution is to upgrade your MSDE applications to SQL Server 2005 Express Edition (SQL Express), the new version of MSDE . Here are the reasons behind...
3 Jan 2007
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
September’s the month for SQL Server 2005 Upgrades!
WEBCAST not to Miss Starting September 7 th , Microsoft gives you the opportunity to register and watch a series of webcasts dedicated to delivering valuable information and tools to help businesses upgrade their current SQL Server environment. Don't miss the chance to watch them and start from...
30 Aug 2006
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 2005 Standard Reports, SQL 2005 Performance Dashboard Reports and... DMVStats
SQL Server 2005 introduced dynamic management views (DMV) and functions (DMF) , a mechanism to allow you to look at the internal workings of SQL Server using TSQL. They allow you an easy method for monitoring what SQL Server is doing and how it is performing. They replace the need to query the system...
26 Jul 2007
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
Microsoft Security Bulletin MS09-004 – Important
For your joy (and especially for the joy of my customer :)) yesterday Microsoft has released a new Security Bulletin for SQL Server: Microsoft Security Bulletin MS09-004 – Important http://www.microsoft.com/technet/security/bulletin/MS09-004.mspx This update is marked as important, which...
11 Feb 2009
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 in TVP - Microsoft Offices. Agenda: 6pm – 6:30 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:30pm – 7 Round Table discussion - ALL Take stock and...
12 Nov 2008
SQL Server Support FAQ
On the Microsoft SQL Server Support Blog , it has been published a really interesting article concerting SQL Server Support. Working with Premier customers on a day-to-day basis, I know that some of these questions are very common, therefore I recommend to have a look to this post and hear directly...
3 Sep 2007
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
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 of different customers, which work with SQL Server every day, and being able to share my experience on the field with the new great features included with SQL 2008 had been fantastic, and a great...
5 Nov 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
Live Meeting: SQL Server 2005 Certifications
When: January 23rd 7:30 AM PST and 5:00 PM PST On January the 23rd you'll have the chance to participate to this Live Meeting with the Microsoft Certification team for a detailed explanation of the MCTS and MCITP certifications released last year for SQL Server 2005 DB developers, DBAs, and Business...
4 Jan 2007
SQL Server Monitor Gadget for Windows Vista Sidebar
Have you ever thought about monitoring your SQL Server installation from Windows Vista Sidebar? Well, you can install and download it for free at http://blogs.conchango.com/jamiethomson/archive/2007/08/09/Announcing-SQL-Server-Monitor-Gadget-for-Windows-Vista-Sidebar.aspx . The gadget monitors...
22 Aug 2007
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
© 2014 Microsoft Corporation.
Privacy & Cookies