You should be able to shrink the tlogs without changing the recovery model. It is the change of the recovery model that would break log shipping.

To fix the...

I like the opportunity for a new OS for SQL Server. This opens a new world of learning opportunities.

I like the question. It made me think of the need to break down the types of triggers when looking at a new system and evaluating the state of the...

Here is a an article that covers making the config file more secure.

https://msdn.microsoft.com/en-us/library/dtkwfdky.aspx

Sadly, people just use the SA account or some other application account...

phalanges

I have to sit and muse as to why in the world this network admin has any permission whatsoever inside of the database. He is a network admin or is...

Nice basics question.