SQL Server with Mr. Denny:

SQL Server 2008


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


July 3, 2008  5:39 AM

Installing SQL Server on Windows Server 2008



Posted by: Denny Cherry
SQL Server 2005, SQL Server 2008, Windows 2008, Windows Firewall

I ran across an excellent post from Shawn Hernan of the SQL Server Development team (the guys that write SQL Server).  Shawn has put out an excellent blog post on what needs to be done to get SQL Server2005 or SQL Server 2008 installed on Windows Server 2008.  You can find the post


June 16, 2008  7:12 PM

Replay URL for my GeekSpeak Session



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

For those who were unable to attend my Geekspeak session last week the session was recorded and that

Bookmark and Share     0 Comments     RSS Feed     Email a friend


June 12, 2008  5:24 AM

Use caution when upgrading SQL 2008 CTP SSIS packages to RC0



Posted by: Denny Cherry
Beta, Migration, SQL Server 2005, SQL Server 2008, SSIS

A ran across a bit of a problem when upgrading my SQL 2008  CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0.  Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages.  Because of this when I edit all of the script tasks within my SSIS package the...


June 10, 2008  7:32 PM

SQL Server 2008 RC 0 Released



Posted by: Denny Cherry
SQL Server 2008

Microsoft has just released SQL Server 2008 RC 0.  This release should be pretty close to the final version expected out later this year. Denny


May 20, 2008  12:26 AM

EMC World 2008 Day 1 (Last post of the day)



Posted by: Denny Cherry
EMC World 2008, Remote Blob Storage Architecture, SQL Native Client, SQL Server 2008

I find myself with a little extra time between my last session of the day, which was a SQL 2008 Session, and the Grant Opening Reception, so I figured that a blog post was in order.  The SQL 2008 session was a what's coming in SQL 2008. Most of the information was stuff that I already knew and...


April 17, 2008  10:00 PM

New Article: Configure SQL Server Service Broker for sending stored procedure data



Posted by: Denny Cherry
Article, Service Broker, SQL Server 2005, SQL Server 2008

I’ve just published a new tip on SearchSQLServer.com called Configure SQL...

Bookmark and Share     1 Comment     RSS Feed     Email a friend


April 17, 2008  8:00 AM

SQL 2008 one click database encryption gives a false sense of security



Posted by: Denny Cherry
Compliance, DataManagement, Encryption, SQL Server 2008

While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I'm not sure how useful it actually is.  It's touted as giving you data encryption of the entire database without any code change. What this actually means is that if someone...


April 7, 2008  11:00 AM

SQL Server 2008 changes the way that CONVERT/CAST works



Posted by: Denny Cherry
Query tuning, SQL, SQL Server 2008

Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless.  In SQL Server 2008 this problem is fixed.  Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime...


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: