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

SQL Server with Mr. Denny:

Config

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

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

March 13, 2008  8:00 AM

SQL 2008 prevents schema changes if the table must be dropped



Posted by: Denny Cherry
Config, SQL, SQL Server 2008, SSMS

When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change. The kinds of changes that would require that the table be dropped and recreated would be inserting a...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

March 2, 2008  4:43 AM

New Article: Create an upgrade plan for your move to SQL Server 2005



Posted by: Denny Cherry
Article, Config, Installation, SQL, SQL Server 2005, SQL Server 2008

I’ve published a new tip over on SearchSQLServer.com entitled “Create an upgrade plan for your move to SQL Server...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

February 18, 2008  8:00 AM

So I’ve heard about endpoints, but what are they and how do I use them?



Posted by: Denny Cherry
Config, Endpoints, SQL, SQL Server 2005, SQL Server 2008

In a nutshell Endpoints are ways that people, or applications can connect to the SQL Server.  There are several different kinds of end points which can be created; four to be specific.  Two are system specific, the SERVICE_BROKER and DATABASE_MIRRORING endpoints can only be used for the SQL...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

February 11, 2008  8:00 AM

Getting those memory setting in SQL Server just right.



Posted by: Denny Cherry
Config, Microsoft Windows, RAM, SQL, Windows Computing

When using 64bit SQL Server getting the memory settings right is pretty easy.  Simply set the maximum to what you want and you are good to go. Getting them right in the 32bit versions of SQL Server is a bit harder.  You have to deal with the OS level of enabling the Physical Address Extensions...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...

  Bookmark and Share     4 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 10, 2008  8:00 AM

SQL CLR: The What, When, Why and How.



Posted by: Denny Cherry
CLR, Config, SQL

There are two camps when it comes to SQL CLR.  The DBA camp, which says don't use it, it'll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything.  These two different camps also represent the different messages which...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

October 22, 2007  10:17 AM

How SQL decides how much procedure cache and how much buffer cache to use.



Posted by: Denny Cherry
Cache, Config, SQL

There are two main types of cache which SQL Server deals with, the buffer cache and the procedure cache.  The procedure cache is where the execution plans for procedures and queries are stored.  The buffer cache is where the actual data is cached so that SQL Server doesn't have to go to disk to...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1