Musings of a technophile

If you ever have to deploy a SQL CLR Function that is not using Safe Permissions, then you may run into a roadblock where you get the error

CREATE ASSEMBLY for assembly ‘MyProject’ failed because assembly ‘MyProject’ is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true:
the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has… Continue reading

I have a table at my company that is replicated from a live database server to a server that is used for reporting. The live server is in one location while the reporting server is located in the building where I work, and they are connected via a point-to-point T1 line. The problem is that the table that is replicated is now over 60GB, so if replication breaks and I… Continue reading

If you’ve dealt with SQL replication, you might have come across the problem of queries getting blocked while you attempt to create a snapshot for your replication publication. The reason why is almost self explanatory – a snapshot is record of how the table was when replication began. This being said, it requires that the table be locked so that the data doesn’t change while the snapshot is reading the… Continue reading

I have some replicated tables on a server we use for reporting at work. We had put some indexes on the replicated tables, but these were not indexes we needed on our master database. Well sure enough one day we needed to redo replication, and of course when you redo replication, you wind up setting the tables back to their original states as on the master – meaning all our… Continue reading