I have been developing for SharePoint lately, working on timer jobs. This resulted in tons of deployments and job runs, and before I knew it…
Category: SQL Server
I’m sure the first question someone would ask me is why do this, if installing the SRS Connector does the job just fine? And I…
I needed to move the set of Commerce Server databases from one server to another, so I developed and tested this procedure. Script the database…
Doh! Another simple thing I wish I knew (or thought of) previously: Using RunAs to connect to SQL Servers in other domains
Sometimes when copying databases, for instance from production down to development, the user accounts become dysfunctional. The database login no longer matches the overall server…
I blogged previously about some issues with SelfSSL and multiple web sites. A colleague of mine, Charles Medcoff, blogs about a related problem with SelfSSL…
An excellent post by Pablo Castro of the ADO.NET team explaining the mechanics of how batch updates work with ADO.NET 2.0 and Sql Server 2005.
Having to excecute hundreds of .sql files in an environment without port 1433 open led me to this nugget of a Usenet post: How to…