Microsoft SQL Server troubleshooting

SQL Server 2008 R2 setup failing on Windows 2008 R2 SBS

Windows Small Business Server 2011 Premium includes SQL Server 2008 R2...

Author: Joao Loureirot_ Date: 07/11/2011

SQLPORT – SQL Server Portuguese Community

SQLPort is a community without any economical interest of affiliation with Microsoft that main goal...

Author: Joao Loureirot_ Date: 05/03/2010

TechDays 2010 – SQL Server High Availability and Disaster Recovery

Summary: -SQL Server 2008/2008 R2 patching and upgrade -Introduction to High Availability and...

Author: Joao Loureirot_ Date: 04/23/2010

TechDays 2010 – SQL Server Engine Internals – Deep Dive Session

Summary: - SQL Server 32 bits vs 64 bits - SQL Server IO considerations - Troubleshooting using...

Author: Joao Loureirot_ Date: 04/23/2010

SQL Server 2005 Patch Fails to install with an error "Unable to install Windows Installer MSP file"

  We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install...

Author: Joao Loureirot_ Date: 01/05/2010

SQL Server 2008 Premier Workshop (Porto)

SQL Server 2008 Technical Overview High Availability and Performance Optimization From 12 to 13...

Author: Joao Loureirot_ Date: 11/18/2009

SQL Server 2005 RTM/SP Setup hangs when displaying patching passive node message

If admin shares are disable on both nodes of the cluster task scheduler might be visible remotely...

Author: Joao Loureirot_ Date: 10/19/2009

SQL Server 2008 does not start after SP1 with ETW enabled

In case you have just deployed SQL Server 2008 SP1 on a IA64 machine and SQL Server doesn’t start...

Author: Joao Loureirot_ Date: 09/30/2009

SQL Server 2008 Deep Dive Session

Summary: – Higher Availability and scalability (Fail-over clustering, mirroring) – Manageability and...

Author: Joao Loureirot_ Date: 09/11/2009

SQL Server 2005 performance problems due grow of TokenAndPermUserStore cache

TokenAndPermUserStore is one of the many caches present in the SQL Server 2005 memory architecture....

Author: Joao Loureirot_ Date: 07/20/2009

How to reduce paging of buffer pool memory in the 64-bit SQL Server 2005 Standard version of SQL Server

SQL Server 2005 SP2 introduces a new warning message that indicate that working set (RAM resident...

Author: Joao Loureirot_ Date: 07/14/2009

SQL Server Resource IsAlive Troubleshooting

  When SQL Server is deployed on cluster environment there is an associated IsAlive that is...

Author: Joao Loureirot_ Date: 04/20/2009

Exclusive Session – SQL Server Performance Troubleshooting

Session Summary •SQL Server 2000 Performance Troubleshooting •SQL Server 2005 Performance...

Author: Joao Loureirot_ Date: 04/20/2009

How to build a virtual SQL Server 2008 clustered environment with Hyper-V

  1. Install your virtual clients running Windows 2008 Enterprise and make sure they have basic...

Author: Joao Loureirot_ Date: 03/20/2009

How to install SQL Server 2008 with SP1 built-in (slipstream installation)

This guide will demonstrate how to create new source media that will slipstream the original source...

Author: Joao Loureirot_ Date: 03/20/2009

SQL Server 2008 Premier Session

Session Summary •SQL Server 2008 Scalability •SQL Server 2008 Top Features •Resource Governor •Data...

Author: Joao Loureirot_ Date: 03/05/2009

SQL Server 2008 FilesStream – DevDays 2009

Session Summary •Challenges for using unstructured data •The Filestream Feature - An Overview...

Author: Joao Loureirot_ Date: 02/25/2009

SQL Server profiler trace parsing tool – Build performance reports based on profiler traces only

Imagine the scenario that you application has just been deployed into production environment and SQL...

Author: Joao Loureirot_ Date: 12/31/2008

SQL Server 2008 – Performance counters registry hive consistency fails on non English Operating Systems

Trying to install SQL Server 2008 on a non English OS and setup is being blocked by this rule,...

Author: Joao Loureirot_ Date: 12/18/2008

SQL Server 2008 installation aborts due an access denied

Trying to install SQL Server 2008 on a standalone environment using an administrator account and...

Author: Joao Loureirot_ Date: 12/02/2008

Bulk insert using UNICODE data files

  Did you ever tried to use bulk insert with unicode instead of ansi data files using a format...

Author: Joao Loureirot_ Date: 11/27/2008

SSIS 2008 SCD wizard does not show non-SQL Server connections

This change has been implemented due a problem/limitation on non SQL OLEDB that generated invalid...

Author: Joao Loureirot_ Date: 11/27/2008

SQL Server checkpoint problems

On high end performance servers with a huge amount of memory you might notice some spikes on I/O...

Author: Joao Loureirot_ Date: 11/20/2008

SQL Server log growing out of control due Query subscription warning messages (SQLDependency API)

When using a query notification enabled application that is using SqlDependency, if Stop()method is...

Author: Joao Loureirot_ Date: 09/29/2008

SQL Server installation troubleshooting, interesting articles

General info, best practices 907284 - Changes to the readme file for SQL Server 2005 910229 - SQL...

Author: Joao Loureirot_ Date: 09/05/2008

How to use Windbg to debug a dump of a 32bit .NET app running on a x64 machine

Imagine we are running a 32bit .NET app in a x64 machine. This app is failing so we have taken a...

Author: Joao Loureirot_ Date: 09/03/2008

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system...

Author: Joao Loureirot_ Date: 08/29/2008

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained....

(greetings to Bob Ward) PLEASE NOTE: This blog post has been updated from its original posting to...

Author: Joao Loureirot_ Date: 08/29/2008

SQL Server 2008 RTM (build 1600.22) is out

The wait is over. SQL Server 2008 has been released and is ready to deliver a rich set of integrated...

Author: Joao Loureirot_ Date: 08/09/2008

TechDays 2008 {For a World 2.0}

This week (Tuesday 11th/Friday 14th), you cannot miss it! See you at Microsoft TechDays {For a World...

Author: Joao Loureirot_ Date: 03/13/2008

How to rebuild your master database in MSDE when it became corrupted?

This info was taken from Nacho blog (http://blogs.msdn.com/ialonso), I have only added 2 important...

Author: Joao Loureirot_ Date: 03/13/2008

SQL Server 2000 (64 bits) versus SQL Server 2000 (32 bits) - Memory management

SQL Server 2000 (64 bits) versus SQL Server 2000 (32 bits) SQL Server 2000 (64-bit) and SQL Server...

Author: Joao Loureirot_ Date: 02/05/2008

Script to appropriate rebuild/reorganize database indexes - SQL Server 2005

Depending on fragmentation index level appropriated action will be taken (no action, rebuild or...

Author: Joao Loureirot_ Date: 01/28/2008