SQL Server with Mr. Denny:

Development


August 13, 2008  1:05 AM

Don’t Consolidate Yourself Into Performance Problems

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Consolidated too many databases or too many instances onto a single server?  Got users...

August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


August 7, 2008  11:00 AM

How to configure DTC on Windows 2003

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 7, 2008  1:21 AM

Microsoft SQL Server 2008 goes RTM

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Microsoft has just announced that SQL Server 2008 has been released to the public. You can download the Eval edition as of...


August 4, 2008  11:00 AM

I need a secure transfer of data between SQL Servers. What are my options?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

You've got a few options, none of which are all that easy to setup. 1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file. 2. Setup IPSec between the two SQL Servers and then transfer the data as normal. 3. Setup a Secure FTP Server at...


July 30, 2008  1:24 AM

SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I was asked...


July 28, 2008  11:00 AM

You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren't compatible.  You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won't be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it...


July 24, 2008  11:00 AM

How to setup SQL 2008 BIDS to use VB.NET as the default scripting language

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

If you are like me and don't know anything about...


July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion.  This would be done by taking backups of the database.  Backups are taken by using the BACKUP DATABASE command. The...


July 21, 2008  11:00 AM

A better way to index text data

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for.  However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server.  This is because of the large amount of data being put in...


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: