SQL Server with Mr. Denny:

Database


October 2, 2009  7:14 PM

Join me on Oct 21st for a Clustering with iSCSI Presentation



Posted by: Denny Cherry
Clustering, iSCSI, SQL, Starwind, Webcast

All, On October 21st, 2009 at 11am (Pacific) / 2pm (Eastern) I'm going to be presenting a free Webcast on how to setup a Windows 2008 Cluster when using iSCSI.  Additionally I'll be going over some tuning tricks you can use to improve the performance of your iSCSI network.

October 1, 2009  11:00 AM

HA and DR require the same techniques right?



Posted by: Denny Cherry
Clustering, SQL

While many of the technologies used for HA and DR are similar (or even the same) HA and DR are two different types of events which should be handled differently.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


September 17, 2009  11:00 AM

Dates can easily be the hardest datatype to work with.



Posted by: Denny Cherry
Index Performance, Index Scan, Index Seek, Indexing, T/SQL

The datetime data type can be one of the hardest to work with when it comes to index optimization.  Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value.  Most people handle this via a convert function around the date...


September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important



Posted by: Denny Cherry
Index Performance, Performance Problems, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, Statistics, White Paper

Today I'm publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy.


September 1, 2009  6:31 PM

SQL Server 2008 Clustering Article in SQL Server Magazine



Posted by: Denny Cherry
Article, Clustering, SQL Server 2008, SQL Server Magazine, Windows 2008

For those of you who haven't check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on...


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 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 4, 2009  11:00 AM

Use caution when using an image to setup servers which will be clustered.



Posted by: Denny Cherry
Clustering, Lesson Learned, VMware, Windows 2008

A lesson that I learned while setting up our new data center for work, is to be careful when setting up your clustered servers. Most of our servers are VMs, including a Windows 2008 Cluster (yeah I know not supported, I'm a rebel damn it and I want a Windows 2008 cluster installed under VMware...


May 28, 2009  11:00 AM

What’s the difference between encrypted data and hashed data?



Posted by: Denny Cherry
Database, Database security, Encryption, Hashing, Security, SecurityFightClub

The biggest difference between encrypted data and hashed data is that encrypted data can be decrypted later.  Hash algorithms such as MD5 are one way hashing algorithms which means that the value that is returned can't be decrypted back to the original value. It is important to know the...


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...


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: