SQL Server with Mr. Denny:

SQL Server

August 7, 2008  1:21 AM

Microsoft SQL Server 2008 goes RTM

Posted by: Denny Cherry
SQL Server 2008

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

August 4, 2008  11:00 AM

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

Posted by: Denny Cherry
Config, Encryption, IPSec, OpenSSL, PGP, Secure Data Transfer, Secure FTP, SFTP, 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 28, 2008  11:00 AM

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

Posted by: Denny Cherry
RDL, SQL Server 2005, SQL Server 2008, SSRS

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

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

If you are like me and don't know anything about C#, and you don't want to have to change the script language every time to create a .NET script from C#.NET to VB.NET you can change the default.  Open BIDS, and select Tools > Options.  On the menu on the left select "Business Intelligence...

July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command

Posted by: Denny Cherry
Back To Basics, BACKUP DATABASE, SQL, SQL Server 2000, SQL Server 2005

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

Posted by: Denny Cherry
Index Performance, Query tuning, SELECT statement, T/SQL, Tables, Uni-code

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...

July 17, 2008  11:00 AM

Book: The Windows Manager’s Guide to iSCSI SANs

Posted by: Denny Cherry
Exchange, Microsoft Windows, SQL, SQL Server 2005, SQL Server 2008, Storage

That's right I said a book.  Well it's actually an eBook but good enough right?  The best part is that it's available for free.  It's a three chapter eBook called "The Windows Manager's Guide to iSCSI SANs".  Each chapter was posted separately so you have to click through to each...

July 14, 2008  11:00 AM

Using batching to do large operations without filling the transaction log

Posted by: Denny Cherry
DELETE statement, Query tuning, SQL, Tables

Deleting large amounts of data from a table is usually an important task, but if you don't have a maintenance window to work within then you can end up causing locking and blocking against the other processes which are accessing the database.  Not to mention you will cause a very large amount of...

July 10, 2008  11:00 AM

My Experience with putting a CRL Procedure into SQL

Posted by: Denny Cherry
C#, CREATE ASSEMBLY, CREATE PROCEDURE, Encryption, Microsoft.SqlServer.Server, SQL CLR Procedure, SQL Server 2005, SQL Server stored procedures, T/SQL

A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005.  Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL.  Could I have done what I needed to without a CRL...

July 10, 2008  11:00 AM

SQL 2008 RC0 Intellisense doesn’t work against SQL 2005

Posted by: Denny Cherry
Beta, Intellisense, SQL, SQL Server 2005, SQL Server 2008

I've been working with SQL 2008 RC0 for a couple of weeks now, and something I've noticed that really sucks.  The Intellisense doesn't work against a SQL 2005 server any more.  I've been using the SQL 2008 UI exclusively for several months now (since the November CTP at least) and I've gotten...

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: