SQL Server with Mr. Denny:

SQL Server

June 15, 2009  11:00 AM

PASS 2009 here I come

Posted by: Denny Cherry
In Person Events, PASS, Storage

The people at the PASS 2009 have made the ultimate mistake.  They've decided to allow me to come and speak at the PASS 2009 Summit this November. Continued »

June 11, 2009  11:00 AM

Who’s been logging into my SQL Server?

Posted by: Denny Cherry
ERRORLOG, LOGIN, Security, SecurityFightClub, SQL Server 2000, SQL Server 2005, SQL Server 2008

Knowing who has been logging into your SQL Server is one of the key things to know about your SQL Server.  It lets you know quite a bit about who’s using your server, and about who’s been trying to break into your SQL Server, and most importantly if they have succeeded. Obviously you can...

June 1, 2009  1:00 PM

Clean up the backup history

Posted by: Denny Cherry
Backup & recovery, Database Administration, sp_delete_backuphistory

Something that most people don't release needs a little TLC in SQL Server is the backup history. Every time a database is backed up records are written about it.  Over time this can add up to a lot of useless data floating around the SQL Server in the msdb database. If you like to use the UI...

May 25, 2009  11:00 AM

VMware and SQL and Lock Pages in Memory

Posted by: Denny Cherry
Lock Pages, SQL, VMware

With the recent release of the ability for the Lock Pages in Memory setting to be used on SQL Server 2005 and 2008 Standard Edition I see more and more people shooting them selves in the foot with this setting when running under VMware.  I see this as becoming more of an issue now that this switch...

May 14, 2009  11:00 AM

Outside Queue to SSB adapter

Posted by: Denny Cherry
MSMQ, Open Source, Outside Queue to SSB Adapter, Service Broker

Something that I think that Microsoft should include with the SQL Service Broker is an adapter so that MSMQ messages (and other messaging systems as well) will flow automatically into the SQL Service Broker.  Since Microsoft hasn't gotten around to writing one I'm going to start. It shouldn't...

May 11, 2009  11:00 AM

How do I change from push to pull subscriptions in SQL Replication?

Posted by: Denny Cherry
distrib.exe, Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

The official answer is to delete the subscriber and recreate it pushing a new snapshot to the subscriber. The much quicker and easier method is as follows. 1. Stop the distribution agent on the machine that it's currently running on. 2. Disable the SQL Agent job that runs the distribution...

May 7, 2009  11:00 AM

Pull vs. Push Subscriptions? Which one should you use?

Posted by: Denny Cherry
Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

This is a "it depends" sort of question. These are my recommendations, your mileage may vary. Your distributor is on the same system as your publisher - Pull is probably for you Your Subscribers are a very high transaction count - Push is probably for you You need to manually copy the...

May 4, 2009  11:00 AM

How can I remove duplicate records in my tables?

Posted by: Denny Cherry
CTE, DELETE statement, SQL Server 2005, SQL Server 2008, T/SQL

All to often we end up with duplicate rows in a table.  The best way to keep duplicate rows out of the database is to not let them in.  But assume that they are there.  This bit of sample code shows how to delete those duplicate rows quickly and easily in a single statement.  No temp tables...

May 1, 2009  5:03 AM

Should I install an Anti-Virus software on my server?

Posted by: Denny Cherry
Anti-Virus, SQL Server

Yes, for crying out loud yes. Every server that can access the Internet or be access from the Internet, or that can be accessed from a computer that can access the Internet should have an anti-virus on it.  Preferably a corporate wide solution like

Bookmark and Share     2 Comments     RSS Feed     Email a friend

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

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: