SQL Server with Mr. Denny:

SQL Server


August 6, 2009  11:02 AM

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



Posted by: Denny Cherry
Attaching Database, Database security, NTFS Permisions, SecurityFightClub, SQL Server

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

August 4, 2009  9:11 PM

SoCal Code Camp – LA #2 has been announced



Posted by: Denny Cherry
Execution Plans, In Person Events, Indexing, SoCal Code Camp, Storage

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


August 3, 2009  11:00 AM

Single Instance vs Multiple Instances



Posted by: Denny Cherry
Instance, Multiple Instance Configuration, RAM, SQL Server, TempDB

I see this question quite a bit, should I use a single instance or one instance per application database on my server. 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  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 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 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 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...


July 2, 2009  11:00 AM

When clustering SQL 2008, SQL Server may reject the Key



Posted by: Denny Cherry
Clustering, Installation, SQL Server 2008

When installing SQL Server 2008 Enterprise onto my new SQL Cluster I downloaded the media from Microsoft and dropped it onto a network share and installed it.  The first node went perfectly, the second node, not so much.  When I went to install on the second node I would get to the screen which...


June 29, 2009  7:37 PM

If I wanted to learn the law, I would have been a lawyer



Posted by: Denny Cherry
Data Encryption, Database Administration, Encryption, Lawyers, SecurityFightClub, Transparent Data Encryption

So your probably a lot like me, you were a teen who liked to play with computers and you managed to end up in IT.  This is awesome you figured, I play with computers and someone actually pays me for this. During the 90’s life was good, there wasn’t any regulations to deal with, you followed...


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: