SQL Server with Mr. Denny:

SQL


July 14, 2008  11:00 AM

Using batching to do large operations without filling the transaction log

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

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

My Experience with putting a CRL Procedure into SQL

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005.  Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL.  Could I have done what I needed to without a CRL...


July 10, 2008  11:00 AM

SQL 2008 RC0 Intellisense doesn’t work against SQL 2005

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've been working with SQL 2008 RC0 for a couple of weeks now, and something I've...


July 7, 2008  11:00 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The RECEIVE command is the last of the Service Broker items to cover in the Back To...


July 3, 2008  4:59 PM

My Back To Basics session was way more popular than I was expecting

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

At the last SoCal Code Camp I did several new sessions.  One...


July 3, 2008  5:39 AM

Installing SQL Server on Windows Server 2008

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I ran across an excellent post from Shawn Hernan of the SQL Server Development team (the guys that write SQL Server).  Shawn has put out an excellent blog post on what needs to be done to get SQL Server2005 or SQL Server 2008 installed on Windows Server 2008.  You can find the post


June 30, 2008  11:00 AM

New Article: Secure SQL Server from SQL injection attacks

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

An article that I wrote about securing your SQL Server from SQL Injection attacks was just published.  It covers information from both a DBAs point of view and a .NET...


June 28, 2008  8:57 PM

SoCal Code Camp Slide Decks and Sample Code

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

As promised to the folks at the Code Camp here are the slide decks and sample code from this weekends code camp.   Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 26, 2008  11:00 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The SEND command was introduced to SQL Server when SQL Server 2005 was...


June 25, 2008  9:27 PM

Comic Book Cover Contest

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I know that this is way outside the normal content for my blog, but oh well.  A friend at work has entered a comic book cover contest.  Needless to say he's very talented.  His picture is below.  The reason that I'm posting this is it's a 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: