SQL Server with Mr. Denny:

ITKE grandparent


June 16, 2008  7:12 PM

Replay URL for my GeekSpeak Session



Posted by: Denny Cherry
GeekSpeak, SQL Server 2008, Webcam

For those who were unable to attend my Geekspeak session last week the session was recorded and that

Bookmark and Share     0 Comments     RSS Feed     Email a friend

June 16, 2008  11:00 AM

Back To Basics: Service Broker Services



Posted by: Denny Cherry
Back To Basics, Route, Service, Service Broker, SQL

Services are used to bind contracts to queues.  They are also used to database to database, or server to server routing of messages via routes (we'll talk about them later).  Unlike most other objects within SQL Server, the name of the service is case sensitive, no matter what collation you have...


June 12, 2008  5:24 AM

Use caution when upgrading SQL 2008 CTP SSIS packages to RC0



Posted by: Denny Cherry
Beta, Migration, SQL Server 2005, SQL Server 2008, SSIS

A ran across a bit of a problem when upgrading my SQL 2008  CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0.  Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages.  Because of this when I edit all of the script tasks within my SSIS package the...


June 10, 2008  7:32 PM

SQL Server 2008 RC 0 Released



Posted by: Denny Cherry
SQL Server 2008

Microsoft has just released SQL Server 2008 RC 0.  This release should be pretty close to the final version expected out later this year. Denny


June 10, 2008  6:39 PM

Article: SQL Server memory configurations for procedure cache and buffer cache



Posted by: Denny Cherry
Article, Cache, SQL Server 2000, SQL Server 2005

I've just published another tip over on SearchSQLServer.com.  This one is titled SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend


June 9, 2008  11:00 AM

SQL 2005 Internal Query Error 8623 still unfixed



Posted by: Denny Cherry
Data integrity, Data Normalization, Error 8623, INSERT statement, Internal Query Processor, KB 940371

While working on a new part of our production system  we begun getting the following error message back from the SQL Server. Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support...


June 5, 2008  11:00 AM

Back To Basics: Service Broker Queues



Posted by: Denny Cherry
Back To Basics, Queue, Service Broker, SQL

The service broker queue is where the messages are stored after they are delivered, but before they are processed.  They are kind of like tables as you insert data into them (sending the message) and you view the data in them (receiving the message).  While tables can have triggers, queues can...


June 2, 2008  11:00 AM

Back To Basics: Service Broker Contracts



Posted by: Denny Cherry
Back To Basics, Contract, Queue, Service Broker, SQL

Every Service Broker conversation requires a contract.  The contract defines which message type or types will be used, as well as who (sender or receiver) can use which message types.  The contract is specified when the conversation is created. The syntax for creating the contract is pretty...


May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem



Posted by: Denny Cherry
Service Broker, SQL, SQL Server 2005, TempDB

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


May 25, 2008  6:25 AM

EMC Posts EMC World Videos on Youtube



Posted by: Denny Cherry
SQL

EMC has posted a bunch of video's from EMC World online for all to see. [kml_flashembed movie="http://www.youtube.com/v/n_SSvKXsgKw" width="425" height="350" wmode="transparent" /] You can see all of

Bookmark and Share     0 Comments     RSS Feed     Email a friend


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: