Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

DataManagement

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

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

March 27, 2008  6:54 PM

New Article: SQL Server tempdb best practices increase performance



Posted by: Denny Cherry
Article, DataManagement, System Configuration

I’ve recently published a new tip on SearchSQLServer.com called “SQL Server...

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

October 24, 2007  5:09 AM

Upgrade for sp_who2 called sp_who3



Posted by: Denny Cherry
DataManagement, sp_who3, SQL, T/SQL

I've published this before over on tek-tips.com, but I figured that I'd republish it here as well.  I've written an update for sp_who2 which I call sp_who3.  It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

October 10, 2007  1:58 AM

Getting the right disk config for your SQL Server



Posted by: Denny Cherry
DataManagement, SQL, Storage

Many DBAs so not have the knowledge needed in the storage area to be able to ask the right questions to there storage engineers, and often storage engineers do not know the right questions to ask a DBA to get the answers that they need.  Because of this database storage ends up being configured...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1