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…

0

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…

0

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…

0

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…

0

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…

0