I have been trying to find out what permissions are granted to the owner of a database in SQL Server 2005 or higher. I have seen best practices questions like this one: What is the best practice for the database owner in SQL Server 2005? but I haven't been able to find anything specifically addressing what the purpose of having a database owner in SQL Server is and what permissions are granted as a result of making a given login a database owner. If the owner of the database is disabled, what would stop working?
What are the pros and cons of deploying via automated installs vs. drive imaging? For Windows I know there are issues around SID generation when cloning drives. Are there any similar issues for deploying Linux via an image?
I've always wondered if the bandwidth rating of a switch is per port, or total capacity? For example, if I have PC1 and PC2 that are capable of saturating a 100 Mb connection plugged into a 10/100 switch, if I add PC3 and PC4 to the same switch and start transferring files from PC1 to PC2 and from PC3 to PC4 - will both sets of PC's have 100 Mb to use?