SQL Server with Mr. Denny:

July, 2009


July 29, 2009  7:50 PM

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



Posted by: Denny Cherry
Space, WER, Windows 2008, Windows Error Reporting

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



Posted by: Denny Cherry
Replication, SearchSQLServer.com, SQL Server

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



Posted by: Denny Cherry
Quest Software, Trent Mera, Webcast

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



Posted by: Denny Cherry
Clustering, SQL Server 2008, Starwind, Webcast, Windows 2008

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



Posted by: Denny Cherry
Server Hardware, System Design

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



Posted by: Denny Cherry
Permissions, SQL Server 2005, SQL Server 2008, T/SQL, Tables

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



Posted by: Denny Cherry
Kevin Kline, Quest Software, Troubleshooting, Webcast

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



Posted by: Denny Cherry
Enterprise Manager, SQL Server 2000, T/SQL, Tables

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



Posted by: Denny Cherry
Diskpart, Virtualization, Windows 2008

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



Posted by: Denny Cherry
Article, SearchSQLServer.com, Service Broker, SQL Server 2005, SQL Server 2008

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: