SQL Server educational links

Found a great blog post full of links for a better knowledge of SQL Server.

There are multiple links on each of these subjects:

• Identifying SQL Server Bottlenecks and Performance Issues
• Moving Data in SQL Server
• Know your SQL Server Objects and Manipulate them

Source: Every .NET Developer Should Know About the Database they are working with

Visual Studio: VS templates missing

I was unable to add an aspx page to my web site solution.
The error I got from Visual Studio was:

"Could not find file 'c:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplatesCahce\Web\Csharp\1033\WebForm.zip\WebForm_cb.aspx'."

This was the solution:

1. Open "Visual Studio 2008 Command Prompt"
2. Run the command: "devenv /installvstemplates"

And that was all to solve my problem!

Biztalk Error: The system cannot find the file specified (Exception from HRESULT: 0x80070002)

Each time I tried to test my new mapping using BizTalk I got this error: The system cannot find the file specified (Exception from HRESULT: 0x80070002).

So the full error in the event viewer looked like this:

A message received by adapter "FILE" on receive location "RECEIVE ORDERS PCE FILE" with URI "C:\B2B.TRADCOM.COM\ORDERS\INBOUND\PCE\*.xml" is suspended.
Error details: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
MessageId: {F83F1E4B-3B09-4F9B-A9D5-F6C1BD5C2698}
InstanceID: {E162E5AB-E621-4EA1-B643-FD843D7F8D44}


I was able to map the message using Visual Studio, so I was quite sure my BizTalk mapping was correct.

Now it turned out that I forgot to sign the assembly. So the system was unable to place the assembly in the GAC. Because I used a deploy script I didn't notice the resulting warning.

The Mystery of Query Timeouts by Kendra Little - YouTube

"People are complaining about query timeouts. I don't see anything happening in SQL Server, but they always say the database is the problem. How can I tell what's really going on?"

When your users keep hitting timeouts in their application, they naturally think the database is killing off helpless queries. In this webinar Kendra Little will tell you how to triage treacherous timeout situations and collect hard evidence about whether or not the problem is in the database. Do the right detective work and you can turn your frustrated users and irate developers into raving fans.

This session is be 200-level - you should have familiarity with OLTP concepts and understand what DMVs and Profiler are, but you don't have to be an expert with them.

SQL – Interview Questions and Answers

Pinalkumar Dave has published a neat series of FAQ on SQL Server.

The series of blogs provides a simple way to go back over the building blocks of SQL Server. It's way to remind yourself of what you already know.
A Question and Answer discussion can also be a way to go over old topics in a more interesting manner. Especially if you have been working in the industry, or taking lots of classes on the topic, everything you read can sound like a repeat of what you already know. Going over a topic in a new format can make the material seem fresh and interesting. And an interested mind will be more engaged and remember more in the end.

The list of interview Questions and Answers is helpfull as a refresher for SQL developers/administrators or as a way to learn about SQL (as a beginner or to learn new things).

here's an overview of the complete Questions and Answers Series blogs

BizTalk Server 2009 CU package 3 available

The cumulative update package 3 for BizTalk Server 2009 is available.

included hotfixes:

• BizTalk Server EDI support
• The EDI batching orchestration does not release batches on time in BizTalk Server 2006 R2 and in BizTalk Server 2009
• AS2 messages remain active after they are processed when the "Track Message Bodies - Request message after port processing" option is enabled on a send port in a BizTalk Server 2009 environment
• BizTalk Server Administration Tools & Configuration Tools
• "The group BizTalk Isolated Host Users doesn't exist" error message is logged when you configure the Exception Web Services by using the ESB Configuration Tool in a BizTalk Server 2009 environment
• All the tracking options under "Track Events" are selected unexpectedly after a BizTalk orchestration is created or updated in BizTalk Server 2009
• Applications stop responding or crash when System Center Operations Manager monitors BizTalk Server 2009 applications
• BizTalk Server Message Box and Message Agent, Pipelines & Tracking
• Performance decreases when a server that is running BizTalk Server 2009 processes a large batch of messages after you customize the settings of the "Large Message Threshold" option and of the "Large Message Fragment size" option
• Error message when you receive a MIME or SMIME document in BizTalk Server: "Item has already been added"
• BizTalk Server XLANG engine
• White space is removed if a message is processed by a mapping operation that is included in a Construct Message shape in BizTalk Server
• BizTalk Server Setup
• Cumulative update package 2 for BizTalk Server 2009 fails if a BizTalk group uses a database that uses a case-sensitive collation

Prerequisites
To apply this update, you must have BizTalk Server 2009 installed. For detailed information about how to install this update, see the Readme.txt file that is included in the update package.

Notes

• You have to stop the following services before you apply this update:
• ENTSSO
• IISADMIN
• WINMGMT
• BTSNTSVC
• To install this update in a BizTalk group that includes multiple BizTalk servers, install this server update on each server individually instead of concurrently.

Source: http://support.microsoft.com/kb/2557149

BizTalk Webcast

The biztalk videos for BDD (Behaviour Driven Development) and acceptance testing are now available on cloudcast.

LINK: http://www.cloudcasts.net/Default.aspx?category=BizTalk