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
- 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
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