SQLPort is a community without any economical interest of affiliation with Microsoft that  main goal is to unify and support all SQL Server professionals and self training analysts. Main objective is to promote and develop knowledge on that area...

Summary: -SQL Server 2008/2008 R2 patching and upgrade -Introduction to High Availability and Disaster Recovery -SQL Server Always On Technologies -Developing your Availability solutions Session slides: Session Slides Session labs/demos: Demos Webcast...

Summary: - SQL Server 32 bits vs 64 bits - SQL Server IO considerations - Troubleshooting using Perfmon and Profiler - SSMS Tips - Visualizing Schemas - Performance troubleshooting using MDW Session slides: Session Slides Session labs/demos: Demos Webcast...

  We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install on one or more components of SQL Server 2005. In this blog , I have tried to include few troubleshooting tips and tricks for these kinds of installation...

SQL Server 2008 Technical Overview High Availability and Performance Optimization From 12 to 13 November 2009 Session summary: Day 1 SQL Server 2008 High availability and performance troubleshooting •    SQL Server 2008 Log Shipping Setup...

If admin shares are disable on both nodes of the cluster task scheduler might be visible remotely but creating a remote task using task scheduler also hangs. Check the if the following key exists and remove it or change value to 1 and reboot machine:...

In case you have just deployed SQL Server 2008 SP1 on a IA64 machine and SQL Server doesn’t start check if you have ETW tracing using MSSQLSERVER provider enabled. SQL Server error log last lines are listed below and no further info is displayed after...

Summary: – Higher Availability and scalability (Fail-over clustering, mirroring) – Manageability and Administration (Resource governor, Policy Based Management and Server Group Management) – Virtualization, Storage Savings (virtualization, Data Compression...

TokenAndPermUserStore is one of the many caches present in the SQL Server 2005 memory architecture. As the name implies, this cache stores various security related information used by the SQL Server Engine. To find out the amount of memory consumed by...

SQL Server 2005 SP2 introduces a new warning message that indicate that working set (RAM resident portion of SQL Server) has been paged out. This is a common problem that points to excessive paging that leads to potential severe performance problems....

  When SQL Server is deployed on cluster environment there is an associated IsAlive that is responsible to check if SQL Server is online accepting new connections. cluster.log: (…)[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error ...

Session Summary •SQL Server 2000 Performance Troubleshooting •SQL Server 2005 Performance Troubleshooting •SQL Server 2008 Performance Troubleshooting Session slides: Troubleshooting techniques.zip Session labs/demos: Demo 1 – Sql Server 2000 performance...

1. Install your virtual clients running Windows 2008 Enterprise and make sure they have basic connectivity to each other. I used the node names and joined them to the contoso domain. NODEV2 NODEV3 2. Install a free iSCSI SAN software to emulate a iSCSI...

This guide will demonstrate how to create new source media that will slipstream the original source media and SQL Server 2008 Service Pack 1. Once you have created this drop, you can install SQL Server 2008 SP1 in a single step! Besides that how SQL Server...

Session Summary •SQL Server 2008 Scalability •SQL Server 2008 Top Features •Resource Governor •Data Collector •SQL Server 2008 Virtualization scenarios •SQL Server 2008 High Availability •SQL Server 2008 upgrade Session slides: SQL2008Premier.zip Session...

Session Summary •Challenges for using unstructured data •The Filestream Feature - An Overview •Filestream and T-SQL •OpenSqlFilestream •System.Data.SqlTypes.SqlFileStream •Filestream access patterns •Filestream transactional semantics Session slides:...

Imagine the scenario that you application has just been deployed into production environment and SQL Server is extremely slow consuming too many resources. Sometimes a single store procedure can be easily identified by looking into DMV’s or just profiler...

Trying to install SQL Server 2008 on a non English OS and setup is being blocked by this rule, however looking to performance counters everything looks fine. On Operating Systems pt-PT (Portuguese) setups is trying to look for HKEY_LOCAL_MACHINE\SOFTWARE...

Trying to install SQL Server 2008 on a standalone environment using an administrator account and getting an access denied? The problem could happen in case you have removed Local Administrator from ‘Debug privileges’ on local security policies or just...

  Did you ever tried to use bulk insert with unicode instead of ansi data files using a format file as described below: BULK INSERT MyTestTable FROM 'c:\data2.txt' WITH ( FORMATFILE = 'c:\format.fmt',DATAFILETYPE = 'widechar' ) go data2.txt (UNICODE...

This change has been implemented due a problem/limitation on non SQL OLEDB that generated invalid packages when using wizard, this problem has been reported by many customers so a new topic will be added on books online to mention this restriction. However...

On high end performance servers with a huge amount of memory you might notice some spikes on I/O activity due checkpoint executions as examplified below: On SQL Server error log after enabling trace flags 3504 and 3502 to enable checkpoint verbose logging...

When using a query notification enabled application that is using SqlDependency, if Stop() method is called very frequently, which throws away the machinery for receiving a query notification, but it doesn't actually cancel the subscription. So, when...

General info, best practices 907284 - Changes to the readme file for SQL Server 2005 910229 - SQL Server 2005 Express Edition Readme 905395 - A change to the Readme.htm file for SQL Server 2005 Mobile Edition 910070 - The SQL Server 2005 Setup program...

Imagine we are running a 32bit .NET app in a x64 machine . This app is failing so we have taken a memory dump of the app when a specific CLR exception gets raised. We open the dump with our 64bit version of Windbg ( Windbg x64 ), and we verify that we...