Database Mirroring fighting with DocAve

Here’s a weird one… while trying to set up DB mirroring of a content database colocated with a SharePoint contentDB, I got the following error: "The server network address “TCP://SQLServer:5023″ can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational"…

1

Sybase ODBC Linked Server from SQL Server 2005 doesn’t like underscores in table names

I hit an interesting issue this week trying to integrate with a Sybase ASE 15.x database via a linked server. I managed to properly formulate my provider strings, and I was able to issue queries against most tables. However, one of my queries failed, giving me the message Msg 7314, Level 16, State 1, Line…


Artificial Keys

How big? I’ve started noticing a lot of DBs (sometimes turning up in embarrassing places) that neglect some pretty easy scaling techniques. An often-looked consideration is designing a table to support efficient indexing. I personally find that, unless there’s a really good overriding argument, I default to creating an artificial key of the smallest numeric…


My second favorite SQL tip

Create an audit log table (or even better yet, an audit database). It can have a pretty simple structure – I often only have an artificial key, description, and date in mine. Then, when you’re executing a long running script or automated process, you can liberally add “INSERT” statements. Besides providing a log of what…


My favorite SQL tip

Get SQL Server to do the hard work for you, and learn a lot of useful T-SQL while you’re at it. Nearly every operation you can perform with the SQL Server Management Studio GUI can be converted into a T-SQL script. This has a lot of advantages: You can save it and/or share it You…


Project Server 2007 Archive DB too large?

Is your PWA Archive database too large? You may have a problem if your archive DB is significantly larger than (# of retention copies set to be maintained in your PWA’s Server Settings)  x (draft DB size) There are several things to look at: 1. How did you detect the problem? Did you run out…