SQL Server with Mr. Denny:

SQL


February 1, 2008  12:27 AM

Webcast: ‘Under The Hood of SQL Server – Checking Out Internals’



Posted by: Denny Cherry
SQL, SQL Server 2005, SQL Server 2008, Webcam

On Thursday Feb 7, 2008 at 8am Pacific (11am Eastern, 4pm GMT) myself and Jason Hall, Systems Consultant at Quest Software will be co-hosting a webcast looking into the challenges in seeing exactly what is happening within SQL Server (including SQL Server 2008) using Spotlight® on SQL Server...

January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...


January 28, 2008  8:00 AM

Guide to Installing SQL 2000 and SQL 2005 on the same machine



Posted by: Denny Cherry
Installation, SQL, SQL Server 2000, SQL Server 2005

You can install SQL 2000 and SQL 2005 on the same machine.  I always recommend that they be installed in this order to try and get everything working as best as possible.

  1. Install SQL 2000
  2. Install SQL 2005
  3. Install SQL 2000 SP4 (Or the latest service...


January 21, 2008  8:00 AM

Virtualizing SQL Server? When to and when not to.



Posted by: Denny Cherry
SQL, Virtualization

Virtualizing servers is huge right now.  And thanks to VMWare it is very easy to build virtual machines.  In most of IT virtualizing servers is a good think.  In the database world, that isn't always the case.  As we know...


January 17, 2008  12:00 PM

MS KB Article with all the hot fixes listed



Posted by: Denny Cherry
Article, Bug, SQL, SQL Server 2005, Support

I found this great little MS KB article today.  It's got all the SQL Server 2005 post SP2 host fixes including bug numbers and descriptions of the bug.  The MS KB article ID is 937137. Denny


January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition



Posted by: Denny Cherry
DR, Log Shipping, Replication, SQL, T/SQL

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise Edition on both the machines.  This makes the solution fairly expensive.  Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...


January 12, 2008  1:26 AM

SQL Server 2008 – Resource Governor Questions



Posted by: Denny Cherry
Resource Governor, SQL, SQL Server 2008

The engineers from Microsoft PSS has posted some excellent information on thier blog about SQL Server 2008's Resource...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 11, 2008  6:40 PM

New Article: Determining SQL Server database storage requirements



Posted by: Denny Cherry
Article, Config, DataManagement, SQL, SQL Server 2005, SQL Server 2008

I’ve published a new tip over on SearchSQLServer.com entitled “   Bookmark and Share     0 Comments     RSS Feed     Email a friend


January 10, 2008  8:00 AM

SQL CLR: The What, When, Why and How.



Posted by: Denny Cherry
CLR, Config, SQL

There are two camps when it comes to SQL CLR.  The DBA camp, which says don't use it, it'll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything.  These two different camps also represent the different messages which...


January 3, 2008  8:00 AM

Using a foreach loop to process an XML document.



Posted by: Denny Cherry
DataManagement, SQL, SQL Server 2005, SQL Server 2008, SSIS, XML

Receintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn't for the life of me get it to properly process the XML document which I...


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: