Tag Archives: sql server

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts. Security is important for our database servers. One of the loopholes that everyone should be aware of is that the service running SQL … Continue reading

Posted in Blog | Tagged , , | Comments Off on Password for SQL Server Service Accounts

My SQL Server Service Account Philosophy

Recently someone sent me a question about service accounts. They weren’t sure how they should go about setting accounts up for various instances and services in their environments. Specifically they asked me about having domain accounts, or accounts separate for … Continue reading

Posted in Blog | Tagged , , | 2 Comments

No Defaults – T-SQL Tuesday #68

It’s the second Tuesday of the month, and time for T-SQL Tuesday. This month’s invitation is from Andy Yun, where he asks you to Just Say No to Defaults. This is the monthly blog party started by Adam Machanic, and … Continue reading

Posted in Blog | Tagged , , | 1 Comment

I Feel Like a Magician

I ran across this comparison of SQL Server to PostgreSQL. It’s written from the point of view of a PostgreSQL developer, who certainly doesn’t like the Microsoft product much, with no shortage of complaints. Whether you agree or not, I do … Continue reading

Posted in Editorial | Tagged | 2 Comments