SQL Server with Mr. Denny:

July, 2009


July 29, 2009  7:50 PM

Windows 2008, where oh where has all my drive space gone?

Denny Cherry Denny Cherry Profile: Denny Cherry

If you are using Windows 2008, you may be like me.  Wondering where the hell all this drive space is disapearing to. Continued »

July 27, 2009  11:58 AM

Push vs. pull: Configuring SQL Server replication

Denny Cherry Denny Cherry Profile: Denny Cherry

I've published a new artcile over on SearchSQLServer.com.  This article is titled "Push vs. pull: Configuring SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend


July 23, 2009  11:12 PM

Yesterday’s Webcast Recording posted

Denny Cherry Denny Cherry Profile: Denny Cherry

The folks at Quest and Live Meeting worked overtime to get yesterday's webcast recording posted already.  This way if you missed the great webcast that...


July 23, 2009  10:31 PM

Join me on Sept 15, 2009 as we talk about Clustering SQL Server without a SAN

Denny Cherry Denny Cherry Profile: Denny Cherry

On September 15, 2009 I'll be hosting a webcast entitled "How to Set Up a Cost-Effective Windows Server 2008 Cluster with SQL Server 2008 and Tune The Performance".  During this webcast I'll be showing how to use...


July 23, 2009  11:00 AM

Design the server to fit the database, don’t cram the database into the server

Denny Cherry Denny Cherry Profile: Denny Cherry

I am so sick and tired of people posting questions on various forums along the lines of "We just bought a Some brand and model of server and it has n hard drives in it.  How should I setup the database on these drives?"


July 20, 2009  11:00 AM

Changing the default owner when creating objects

Denny Cherry Denny Cherry Profile: Denny Cherry

When a user that doesn't have sysadmin rights creates objects by default they will be created in the schema that is the users default schema.  Now the catch to this is that if you grant the user rights into the database via a domain group that domain group then the user doesn't have a default...


July 17, 2009  1:31 AM

Webcast next with on Troubleshooting the SQL Server service

Denny Cherry Denny Cherry Profile: Denny Cherry

Next week I have the pleasure of presenting another Pain of the Week webcast for Quest Software.  This...


July 16, 2009  11:00 AM

Non-sysadmins create tables under own schema

Denny Cherry Denny Cherry Profile: Denny Cherry

When using SQL Server 2000 and the user doesn't have sysadmin rights, and their login isn't mapped to the dbo user within the database all objects created will be, by default created under the user schema. This is the normal behavior of SQL Server 2000.  In order to allow users who are not...


July 13, 2009  11:00 AM

Windows 2008 C Drive doesn’t always extend correctly

Denny Cherry Denny Cherry Profile: Denny Cherry

When using VMs and Windows 2008 you have the ability to easily grow the C drive on your servers. This makes it much easier to assign only the space needed to the C drive of your servers saving you a ton of space. However I recently had a few machines say that the disk was extanded in Computer...


July 9, 2009  1:27 AM

Setting up SQL Server Service Broker for secure communication

Denny Cherry Denny Cherry Profile: Denny Cherry

Today a new article that I wrote was posted up on SearchSQLServer.com. The article is about setting up SQL Service Broker to use Certificates to secure the traffic between the...


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: