SQL Server with Mr. Denny


August 6, 2009  11:02 AM

What do you mean I can’t access my own database when trying to attach it?

Denny Cherry Denny Cherry Profile: Denny Cherry

When you detach a database from Microsoft SQL (I’m talking SQL Server 2005 and up here) the SQL Server automatically changes the NTFS permissions on the file so that only the user who told the SQL Server to detach the file has access to them.  SQL Server does this to ensure that an unauthorized person isn’t able to access the data files. Continued »

August 4, 2009  11:44 PM

Speaking at the Orange County SQL Users Group This Thursday

Denny Cherry Denny Cherry Profile: Denny Cherry

This Thursday I’ll be speaking at the Orange County SQL Server Users Group.  The group meets at the New Horizons Computer Learning Center in Anaheim, CA which is at 1900 S. State College Blvd Suite 100.

It’s right behind Angles stadium, you can’t miss it.

We haven’t decided on a topic yet, I’ll probably bring a few presentations with me, and let the group pick the topic from the list.  After the presentation I’ll post what presentation we did, and the slide deck, etc for it.

The meeting starts at 7, but people show up as early as 6:30.  There’s usually some pretty good eating, so drop on by.  I’m pretty sure that they charge $5 at the door to cover food, etc.

See you there.

Denny


August 4, 2009  9:11 PM

SoCal Code Camp – LA #2 has been announced

Denny Cherry Denny Cherry Profile: Denny Cherry

The SoCal Code Camp website has been reset and is ready for the next Code Camp.  This code camp will be the second camp camp that we are doing up in LA.  This time it is November 21st and 22nd and is being hosted at USC’s campus again.  (There’s a second site setup for the LA Code Camp specifically so be sure to check that site out as well.) Continued »


August 3, 2009  11:00 AM

Single Instance vs Multiple Instances

Denny Cherry Denny Cherry Profile: Denny Cherry

I see this question quite a bit, should I use a single instance or one instance per application database on my server. Continued »


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 replication“.  In this article I talk about the differences between the two, and when each should be used, as well as how to combine them to get the best of both.

Denny


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 Trent Mera and I did you can at least catch it afterwords.

Denny


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 Starwind Software’s iSCSI Server software to replace to need for a SAN when creating your Windows 2008 and SQL Server 2008 server.

The presentation will start at 2PM EST, 11AM PST.  Pre-registration is required using the above link.

Do note that this presentation will be done a little bit backwards as we’ll dive into the technical content write away, then hit the slide show with the SQL Installation is running in the background.

See you there.

Denny


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?” Continued »


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

So, now how do you fix this?  Unfortunately the only fix to this is to grant the users Windows login as a separate login, then grant this login rights into the database.  You can then grant the user which is mapped directly to the users Windows login a default schema of dbo.

Because of this the user should specify the schema when creating objects.

The downside to this is that they won’t be able to use the object editor to create new tables.  All new tables will need to be created in T/SQL directly.

Denny


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: