Monthly Archives: April 2012

… and one more thing … about Managed Service Accounts

Microsoft released hotfix for Windows Server 2008 R2 and Windows 7 fixing password change mechanism. MSA’s passwords are updated by default every 30 days (may be changed in registry at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NetLogon\Parameters). When password expires and is changed by computer, Kerberos … Continue reading

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged , , , , , , , , | Leave a comment

Managed Service Accounts with Microsoft SQL Server 2012

Managed Service Accounts (MSA) which came with Microsoft Windows Server 2008 R2 and Windows 7 allow you to create domain account which is tied to a specific computer. The account itself is a hybrid of User and Computer account and … Continue reading

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged , , , , , , , , , | 41 Comments

Microsoft SQL Server Myth #1

Full backup clears the transaction log which may be shrunk afterwards. FALSE

Posted in Microsoft SQL Server Myths | Tagged , , | Leave a comment

Microsoft SQL Server Myths category

Hello again! In this section I would like to share some of the myths I come across at my day to day activities. In my opinion myths may be divided into three categories by their origin. 1. Incomprehension 2. Ignorance … Continue reading

Posted in Microsoft SQL Server Myths | Tagged , , | Leave a comment