Showing posts from November, 2010

Installing SQL Server Denali CTP 1 – A step by step guide

SQL Server Denali should support SQL 2000 compatibility level (80)

Rule “Windows PowerShell” failed while installation SQL Server Denali

Denali Setup fails reporting NoRebootPackageDownLevel is found on “Vista/Windows Server 2008” failed

Microsoft® SQL Server 2008 R2 Best Practices Analyzer

Hosting Management Data Warehouse (MDW) reports on a reporting service

When and why to use SQL Server’s backup compression feature?

Service pack for SQL 2008 R2?

Why sometimes only sp_spaceused may not reflect latest information?

Find space utilization by SQL Server objects (sp_spaceused)

Project Lucy – A new project from Quest

Finding exact compression ratio of a SQL 2008 backup

How to fix (bring online) snapshot if original database becomes suspect or unavailable?

Collect all information for all databases from a single script using sys.databases

Microsoft Atlanta – Review of a new Microsoft product to monitor SQL Server Environment based on cloud

Find current location of all data and log files of all databases of the server

Future of SQL Server as of 2010 – Denali

Clearing entire procedure cache from SQL Server (DBCC FREEPROCCACHE)