Script00 is the place to find useful small scripts related to viewing and managing defined CLR functions and assemblies. Script10 will drop and recreate the TEST database, enable CLR integration for ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Nesse repositório quero compartilhar com vocês um projeto que surgiu em 2010 com um e-mail para criar um checklist de um banco de dados e enviar via excel por email ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

I'm not much of a BATCH scripter (More of a BASH scripter) but I have an issue I need to work out and would like some help (Though I've probably already hexed myself by admitting I work in Linux). I'm ...

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...