DVD copying

Yes, I duplicate my DVDs. All of them. Or at least I try to. I’m not talking about ISO images grabbed from the peer-to-peer repository du jour, but stuff I liked enough to buy. The round plastic disk distribution thingie has a very nasty side-effect: it fucks my laptop’s reader. It won’t happen immediately, but […]

Cannot install SQL 2005 (server and/or client)

Again the astoundingly complex Microsoft installer lost me several hours for an otherwise simple task. Things that can go wrong (and they all went wrong, under different circumstances, on several systems): 1. “Unexpected error occurred” – if you copy the contents of the two installation CDs, make sure one is in a subfolder called “Servers” […]

How (the fuck) do I link two instances of SQL Server using the Management Studio?

Never thought I’ll actually miss Enterprise Manager, but the newer one is even more confusing. So – no clue so far how to do such a simple task via the graphical interface, just execute the stuff below: EXEC master.dbo.sp_addlinkedserver @server = N’server.domain.com\instance,tcport’, @srvproduct=N’SQL Server’ EXEC master.dbo.sp_addlinkedsrvlogin N’server.domain.com\instance,tcport’, false, null, ‘sa’, ‘thesapassword’

Why can’t I send e-mail from ASP (.Net) anymore?

Things that used to work mighty fine in 2000 server suddenly break in 2003. 1. CDONTS is no longer available, but it works if you copy one dll from a 2000 system and do a regsvr32 %windir%\system32\cdonts.dll 2. Classic ASP using CDO fails with error “cdo.message error 80070005”. Reason: the user IIS runs under (usually […]

How to concatenate several PDF files

Use Ghostscript. There is no Mac package, but a ./configure –without-x && make && sudo make install will do. Ghostscript offers a wealth of functions to generate or manipulate existing PDFs, check http://pages.cs.wisc.edu/~ghost/doc/cvs/Use.htm#Options for details. So, to concatenate: gs -q -sPAPERSIZE=a4 -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sOutputFile=out.pdf in1.pdf in2.pdf …

How to connect to a MS SQL database using ASP.Net 1.1?

1. In web.config: <configuration> … <appSettings> … <add key=”connStr” value=”server=server_name_or_ipaddress; Initial Catalog=database_name; User Id=username; Password=password;” /> … </appSettings> … </configuration> 2. In your .aspx file: <asp:Repeater ID=”rep1″ runat=”server”> <HeaderTemplate><table border=”1″></HeaderTemplate> <ItemTemplate> <tr> <td><%# DataBinder.Eval(Container.DataItem, “col1”) %></td> <td><%# DataBinder.Eval(Container.DataItem, “col2”) %></td> </tr> </ItemTemplate> <FooterTemplate></table></FooterTemplate> </asp:Repeater> 3. In your .aspx.cs file: using System.Data; using System.Data.SqlClient; protected Repeater […]

How to generate passwords for a list of users?

Ugly hack set nocount on declare @a int declare @b varchar(128) set @a=0 drop table #rp create table #rp(p varchar(128)) While 1=1 Begin set @a=(Select Min(theindexfield) from thetable Where theindexfield>@a) If @a is null break else delete from #rp insert into #rp exec random_password 8,’simple’ update thetable set thepassfield=(select p from #rp) where id=@a continue […]

The format wars have ended

Unfortunately, Sony won. Warner Bros., Wal-Mart and Netflix have chosen Blu-Ray, and – from an article in an American newspaper (Hollywood Reporter): “Immediately after the Warner announcement, the HD DVD North American Promotional Group canceled its Consumer Electronics Show presentation. The following week, data collected by the NPD Group revealed Blu-ray took in 93% of […]

Bad Behavior has blocked 85 access attempts in the last 7 days.