A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081
Reeves Smith shows how to add reference data to Master Data Services with the MDS add-in for Excel, so the business can manage it themselves.
A Custom db_executor Role for Stored Procedure Access
The app gets a permission error while it works for you as a sysadmin. Here is how a db_executor role fixes it without opening everything.
SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server
Create login with SID to keep SQL logins in sync on a secondary server, so users connect after log shipping, AlwaysOn or mirroring failover.
SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074
Agile builds software in small, time boxed steps. In Notes from the Field #074, Stuart Ainsworth shares stories about 3 common mistakes of Agile Development.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.