Microsoft SQL Server troubleshooting
Windows Small Business Server 2011 Premium includes SQL Server 2008 R2...
Date: 07/11/2011
SQLPort is a community without any economical interest of affiliation with Microsoft that main goal...
Date: 05/03/2010
Summary: -SQL Server 2008/2008 R2 patching and upgrade -Introduction to High Availability and...
Date: 04/23/2010
Summary: - SQL Server 32 bits vs 64 bits - SQL Server IO considerations - Troubleshooting using...
Date: 04/23/2010
We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install...
Date: 01/05/2010
SQL Server 2008 Technical Overview High Availability and Performance Optimization From 12 to 13...
Date: 11/18/2009
If admin shares are disable on both nodes of the cluster task scheduler might be visible remotely...
Date: 10/19/2009
In case you have just deployed SQL Server 2008 SP1 on a IA64 machine and SQL Server doesn’t start...
Date: 09/30/2009
Summary: – Higher Availability and scalability (Fail-over clustering, mirroring) – Manageability and...
Date: 09/11/2009
TokenAndPermUserStore is one of the many caches present in the SQL Server 2005 memory architecture....
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...
Date: 07/14/2009
When SQL Server is deployed on cluster environment there is an associated IsAlive that is...
Date: 04/20/2009
Session Summary •SQL Server 2000 Performance Troubleshooting •SQL Server 2005 Performance...
Date: 04/20/2009
- Install your virtual clients running Windows 2008 Enterprise and make sure they have basic...
Date: 03/20/2009
This guide will demonstrate how to create new source media that will slipstream the original source...
Date: 03/20/2009
Session Summary •SQL Server 2008 Scalability •SQL Server 2008 Top Features •Resource Governor •Data...
Date: 03/05/2009
Session Summary •Challenges for using unstructured data •The Filestream Feature - An Overview...
Date: 02/25/2009
Imagine the scenario that you application has just been deployed into production environment and SQL...
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,...
Date: 12/18/2008
Trying to install SQL Server 2008 on a standalone environment using an administrator account and...
Date: 12/02/2008
Did you ever tried to use bulk insert with unicode instead of ansi data files using a format...
Date: 11/27/2008
This change has been implemented due a problem/limitation on non SQL OLEDB that generated invalid...
Date: 11/27/2008
On high end performance servers with a huge amount of memory you might notice some spikes on I/O...
Date: 11/20/2008
When using a query notification enabled application that is using SqlDependency, if Stop()method is...
Date: 09/29/2008
General info, best practices 907284 - Changes to the readme file for SQL Server 2005 910229 - SQL...
Date: 09/05/2008
Imagine we are running a 32bit .NET app in a x64 machine. This app is failing so we have taken a...
Date: 09/03/2008
In SQL Server 2005, we introduced a different method than in previous versions to rebuild system...
Date: 08/29/2008
(greetings to Bob Ward) PLEASE NOTE: This blog post has been updated from its original posting to...
Date: 08/29/2008
The wait is over. SQL Server 2008 has been released and is ready to deliver a rich set of integrated...
Date: 08/09/2008
This week (Tuesday 11th/Friday 14th), you cannot miss it! See you at Microsoft TechDays {For a World...
Date: 03/13/2008
SQL Server 2000 (64 bits) versus SQL Server 2000 (32 bits) SQL Server 2000 (64-bit) and SQL Server...
Date: 02/05/2008
Depending on fragmentation index level appropriated action will be taken (no action, rebuild or...
Date: 01/28/2008