SQL Server with Mr. Denny:

SQL


July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command



Posted by: Denny Cherry
Back To Basics, BACKUP DATABASE, SQL, SQL Server 2000, SQL Server 2005

Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion.  This would be done by taking backups of the database.  Backups are taken by using the BACKUP DATABASE command. The...

July 17, 2008  11:00 AM

Book: The Windows Manager’s Guide to iSCSI SANs



Posted by: Denny Cherry
Exchange, Microsoft Windows, SQL, SQL Server 2005, SQL Server 2008, Storage

That's right I said a book.  Well it's actually an eBook but good enough right?  The best part is that it's available for free.  It's a three chapter eBook called "The Windows Manager's Guide to iSCSI SANs".  Each chapter was posted separately so you have to click through to each...


July 14, 2008  11:00 AM

Using batching to do large operations without filling the transaction log



Posted by: Denny Cherry
DELETE statement, Query tuning, SQL, Tables

Deleting large amounts of data from a table is usually an important task, but if you don't have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database.  Not to mention you will cause a very large amount of...


July 10, 2008  11:00 AM

SQL 2008 RC0 Intellisense doesn’t work against SQL 2005



Posted by: Denny Cherry
Beta, Intellisense, SQL, SQL Server 2005, SQL Server 2008

I've been working with SQL 2008 RC0 for a couple of weeks now, and something I've noticed that really sucks.  The Intellisense doesn't work against a SQL 2005 server any more.  I've been using the SQL 2008 UI exclusively for several months now (since the November CTP at least) and I've gotten...


July 7, 2008  11:00 AM

Back To Basics: The RECEIVE command (and END CONVERSATION)



Posted by: Denny Cherry
Back To Basics, RECEIVE, Service Broker, SQL, T/SQL

The RECEIVE command is the last of the Service Broker items to cover in the Back To Basics series.  The RECEIVE command is what is used to actually get the message out of the queue so that you can process the data within the message_body column.  The RECEIVE command works just like the


June 26, 2008  11:00 AM

Back To Basics: The SEND command (and the BEGIN DIALOG command)



Posted by: Denny Cherry
Back To Basics, BEGIN DIALOG, SEND, Service Broker, SQL, T/SQL

The SEND command was introduced to SQL Server when SQL Server 2005 was released.  It's kind of like the INSERT command except that it is used only with the SQL Server Service Broker.  With the service broker you put data into a queue instead of a table.  Insert of inserting a command into the...


June 19, 2008  11:00 AM

Back To Basics: Service Broker Routes



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

Routes are only needed when sending service broker messages from one server to another.  They define the SQL Server and TCP Port which the sending SQL Server will connect to in order to deliver the message.  If you are sending the message to a mirrored database, then you can specify the mirror as...


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 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...


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: