Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server 2008 R2 setup failing on Windows 2008 R2 SBS
Windows Small Business Server 2011 Premium includes SQL Server 2008 R2...
Date: 07/11/2011
SQLPORT – SQL Server Portuguese Community
SQLPort is a community without any economical interest of affiliation with Microsoft that main goal...
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...
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...
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...
Date: 01/05/2010
SQL Server 2008 Premier Workshop (Porto)
SQL Server 2008 Technical Overview High Availability and Performance Optimization From 12 to 13...
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...
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...
Date: 09/30/2009
SQL Server 2008 Deep Dive Session
Summary: – Higher Availability and scalability (Fail-over clustering, mirroring) – Manageability and...
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....
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
SQL Server Resource IsAlive Troubleshooting
When SQL Server is deployed on cluster environment there is an associated IsAlive that is...
Date: 04/20/2009
Exclusive Session – SQL Server Performance Troubleshooting
Session Summary •SQL Server 2000 Performance Troubleshooting •SQL Server 2005 Performance...
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...
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...
Date: 03/20/2009
SQL Server 2008 Premier Session
Session Summary •SQL Server 2008 Scalability •SQL Server 2008 Top Features •Resource Governor •Data...
Date: 03/05/2009
SQL Server 2008 FilesStream – DevDays 2009
Session Summary •Challenges for using unstructured data •The Filestream Feature - An Overview...
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...
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
SQL Server 2008 installation aborts due an access denied
Trying to install SQL Server 2008 on a standalone environment using an administrator account and...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 01/28/2008