SQL Server with Mr. Denny:

SQL Server


January 7, 2009  11:27 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check



Posted by: Denny Cherry
Bug Check, Microsoft CSS, SQL Server 2005, SQL Server 2008

The SQL Server CSS team has just posted a

January 2, 2009  8:46 PM

Mirroring isn’t a backup solution



Posted by: Denny Cherry
Backup & recovery, Database security, JournalSpace.com, SecurityFightClub, SQL Injection

In case you live under a rock and haven't heard about Journalspace.com's little mistake, they have gone out of business due to a database problem.  Here's a


December 30, 2008  9:07 AM

Managing Multiple Databases on a Single Server



Posted by: Denny Cherry
Consolidation, enterpriseitplanet.com

Back in November I wrote an article for Enterprise IT Planet entitled "Managing Multiple Databases on a Single Server" in which I...


December 22, 2008  11:00 AM

Development of SQL 2008 SSIS Packages Requires SSIS Service



Posted by: Denny Cherry
BIDS, SQL Server 2008, SSIS

Unlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation.  This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation. It doesn't appear that you...


December 15, 2008  8:03 PM

SQLServerPedia.com Webcast Archived



Posted by: Denny Cherry
Quest Software, SQLServerPedia.com, Webcast

I've been informed that the webcast I did last week with some of the other editors for SQLServerPedia.com has been archived for offline...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


December 15, 2008  9:00 AM

Back To Basics: Getting Data from an XML Document



Posted by: Denny Cherry
Back To Basics, T/SQL, XML

One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...


December 8, 2008  1:06 PM

Just how awesome are table parameters in SQL Server 2008?



Posted by: Denny Cherry
CREATE PROCEDURE, SQL Server 2008, T/SQL, Table Variables

I would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure. While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...


December 1, 2008  11:00 AM

SQL Clustering Article in SQL Server Magazine



Posted by: Denny Cherry
Article, Clustering, SQL Server 2005, SQL Server 2008

For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven't already).  When you do be sure to check out the article which I have in the magazine about clustering your SQL Server. For those without a subscription you can sign up for...


November 30, 2008  11:15 PM

Webcast: SQLServerPedia.com — The Definitive SQL Server Knowledge Base



Posted by: Denny Cherry
SQLServerPedia.com, Webcast

Gain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how...


November 27, 2008  12:15 PM

Back To Basics: Creating Indexes



Posted by: Denny Cherry
Back To Basics, CREATE INDEX, SELECT statement

After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database.  If you haven't already done so, its now time to start adding indexes to your database.  The catch with index is that there is such a thing as to...


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: