April 14, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
SQL Server 11,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SQL Server Management StudioBy default SQL Server Management Studio will only show you 256 characters per column. The fix for this is pretty easy. You click on Tools > Options to being up the options menu. From there navigate to Query Results > SQL Server > Results To Text. Change the "Maximum number of...
February 17, 2011 2:00 PM
Posted by: Denny Cherry
Database security,
SQL Server,
SQL Server 2000,
SQL Server 2005I know that security people like to remove permissions from everything before certifying that a server is ready to go into production. And like 10+ years ago that was something that you might have wanted to do (I'm just talking about SQL Server here). However in today's world of SQL Server 2005...
February 10, 2011 2:00 PM
Posted by: Denny Cherry
Service Broker,
SQL Server,
SQL Server 2005,
SQL Server 2012All to often when I give a SQL Service Broker presentation, or when I'm talking to people about it they want to know what the odds are that SQL Service Broker will be removed from the platform like how Notification Services was ripped from the product after just one release.
So here's just some...
February 7, 2011 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
SQL Server,
SQL Server 11,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database. There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...
March 25, 2010 11:00 AM
Posted by: Denny Cherry
Replication,
Service Broker,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2During 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
Posted by: Denny Cherry
Installation,
SQL,
SQL Server 2005When 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
Posted by: Denny Cherry
Index Performance,
Performance Problems,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
Statistics,
White PaperToday 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
Posted by: Denny Cherry
Permissions,
SQL Server 2005,
SQL Server 2008,
T/SQL,
TablesWhen 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
Posted by: Denny Cherry
Article,
SearchSQLServer.com,
Service Broker,
SQL Server 2005,
SQL Server 2008Today 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...
