SQL Server with Mr. Denny:

Networking

1

May 28, 2012  2:00 PM

Know your app when migrating your data



Posted by: Denny Cherry
Migration, Network Traffic, SQL Server

One of the projects that I'm working on at the moment is moving a data center from being hosted in Dallas Texas up to New Jersey so that it's closer to the companies corporate office in New York City.  As a part of this data center migration the Microsoft SQL Server databases must be moved to the...

March 19, 2012  2:00 PM

Windows 8 Boots With No Network



Posted by: Denny Cherry
Beta, Networking, SQL Server, Windows 8

So I've run into a bit of a strange issue with Windows 8 on my laptop that I wanted to share in case anyone else runs into the same problem.  My basic problem is that about 50% of the time when my laptop boots up into Windows 8 it can't find the network.  I know that the WiFi card is working...


October 14, 2010  11:00 AM

Where did my Default GateWay go?



Posted by: Denny Cherry
Networking, Windows 2008

Apparently some people (myself included) have reported that Windows Vista and Windows Server 2008 are loosing their default gateway settings after installing Service Pack 2 onto the machine.  The basic symptom is that after putting in the default gateway everything works fine, until you reboot. ...


February 15, 2010  11:00 AM

Dealing with a digital “chicken or the egg” situation.



Posted by: Denny Cherry
Cisco VPN, Windows 7

Recently I had the opportunity to upgrade my computer desktop from 2 Gigs of RAM to 8 Gigs of RAM.  This required that I reinstall Windows 7 to replace by 32bit OS with a 64bit OS. This presented me with a problem as I work from home full time and I have to VPN in.  You see we use a Cisco VPN...


April 28, 2009  4:51 AM

Why should the DBA care about Network Firewalls?



Posted by: Denny Cherry
Networking, Security, SecurityFightClub, SQL Server

All to often I see people online asking some sort of question about connecting to their CoLo'ed SQL Server and they connect directly over the Internet.  This is nuts people.  If you can access your SQL Server via Management Studio from anywhere on the Internet so can people who would love to...


January 15, 2009  10:06 AM

Windows 7 and Cisco VPN Software



Posted by: Denny Cherry
Cisco VPN, Windows 7

We use Cisco VPN Software to access the office from home, Starbucks, etc. There are several threads on the subject on the net (I used this one).  There are a couple of workarounds which...


January 15, 2009  3:47 AM

My first day with Windows 7



Posted by: Denny Cherry
Cisco VPN, RDP, Windows 7

Today was my first day using Windows 7 as my primary OS.  I took the time this afternoon to install Windows 7 and start getting everything set back up. Continued »


September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication



Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...


1