SQL Server with Mr. Denny:

SQL Server 2005

March 25, 2010  11:00 AM

Using Service Broker instead of Replication

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

During my SQL Service Broker sessions I talk about using SQL Service Broker as a replacement for SQL Replication.  But I've never really documented how to do this other than bits and pieces here and there.  So here I'm going to try and spell out how I put a system like this together for an auto...

October 5, 2009  11:00 AM

SQL 2005 SP3 Failing to install with password length error

Posted by: Denny Cherry
Installation, SQL, SQL Server 2005

When installing SQL Server 2005 SP3 you may get an error about the password being to short, and it may have nothing to do with your sa password.  It's because the Install Scripts are trying to create a certificate with a password which doesn't meet your domain's password requirements. If you...

September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important

Posted by: Denny Cherry
Index Performance, Performance Problems, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, Statistics, White Paper

Today I'm publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy.

July 20, 2009  11:00 AM

Changing the default owner when creating objects

Posted by: Denny Cherry
Permissions, SQL Server 2005, SQL Server 2008, T/SQL, Tables

When a user that doesn't have sysadmin rights creates objects by default they will be created in the schema that is the users default schema.  Now the catch to this is that if you grant the user rights into the database via a domain group that domain group then the user doesn't have a default...

July 9, 2009  1:27 AM

Setting up SQL Server Service Broker for secure communication

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

Today a new article that I wrote was posted up on SearchSQLServer.com. The article is about setting up SQL Service Broker to use Certificates to secure the traffic between the...

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

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

April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory

Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the

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: