SQL Server with Mr. Denny:

Database


July 26, 2012  2:00 PM

Security Sessions at SQL PASS 2012



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Database, Database Administration, Database Design, Database security, Encryption, Security, SQL Injection, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

The SQL PASS session list for the SQL PASS 2012 Summit has been released.  This year there are 192 sessions being presented at the SQL PASS summit.  Last year at the 2011 summit there were only a couple of sessions...

July 5, 2012  6:31 PM

VMworld needs to provide more feedback to session submitters



Posted by: Denny Cherry
Database, SQL, SQL Server, Tech Ed, vCenter, Virtualization, VMware, VMworld, VMworld 2012, vSphere 5.0

I've submitted a lot of sessions to a lot of conferences over the years.  And while the feedback from some of the conferences is a little cryptic thanks to the review team only having access to canned responses, it'll do.  Now personally I'd love to get specific feedback saying exactly why my...


July 2, 2012  2:00 PM

Giving users the ability to create indexes



Posted by: Denny Cherry
Index Performance, SQL Server

So I ran across a pretty interesting requirement when setting up a new reporting database server.  The end users who run queries against the databases on this server are pretty good at performance tuning their own queries so they wanted the ability to create indexes on the tables on the reporting...


June 4, 2012  2:00 PM

VMware vCenter Performance Tuning



Posted by: Denny Cherry
Index Performance, Nonclustered Index, SQL Server, vCenter, VMware

As hopefully everyone that is using VMware's vSphere in either data center knows VMware's vCenter runs off of a Microsoft SQL Server database (by default).  Now as good as they guys at VMware are at building a virtualization platform there database leave a little to be desired.  I've identified a...


November 28, 2011  2:00 PM

Using CNAMEs with clustered file share resources



Posted by: Denny Cherry
Clustering

One of the questions that I see on the forums every once in a while is how to get a CNAME working with a network share.  For example if you have a cluster where the server names are "SERVER1 and SERVER2" and the virtual name is "VIRT1" how can I allow users to connect to the network shares by...


September 19, 2011  7:13 PM

Slide Decks for #sqlsat95



Posted by: Denny Cherry
Clustering, Indexing, SQL Saturday, SQL Saturday 95, SQL Server

This last weekend was SQL Saturday 95, and it was a great event.  I was speaking during 5 sessions.  Three were my own sessions, and two were panels (one panel I did solo as my co-presenter got sick and couldn't make it).  For my three sessions you'll find my slide decks below.


August 18, 2011  4:30 PM

When working with SQL in a cluster, the account rights on both nodes of the cluster need to be the same



Posted by: Denny Cherry
Clustering, Database, Permissions, Security, SQL Server

Recently I was working with a clients SQL Server cluster.  The managed service provide had installed some Windows patches causing the SQL Cluster to fail over to the other node.  No big deal, everything appeared to be working as normal.

After a couple of days we noticed...


January 4, 2010  11:00 AM

When setting up a new Windows Cluster test failover before releasing to production



Posted by: Denny Cherry
Clustering, Microsoft Cluster Service

When you build a new Microsoft Cluster Server cluster always be sure to fail over all the drives between all the nodes before installing SQL Server on it and deploying the cluster to production.  The first time that you fail over a cluster from one node to another the disks can take a very long...


December 28, 2009  11:00 AM

How to convert a standalone instance to a clustered instance



Posted by: Denny Cherry
Clustering, SQL

This question has come up a couple of times on various forums on the Inter-webs so I figured I'd write up something a little more in-depth than I'd be able to do on a forum. There's no way to easily flip a standalone SQL Server instance to a clustered instance.  However moving a standalone...


November 23, 2009  11:00 AM

Moving a standalone instance to a cluster while keeping the name and IP



Posted by: Denny Cherry
Clustering, Migration, SQL

A little while back I posted about how to move a standalone instance to a clustered instance using a different name and IP, but what do you do when you...


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: