Errors related to logins are one of the most searched in this blog. Many of the blogs that talk about these errors are the ones that get viewed often too. This is one of the interesting errors, which you might see in your environments. One of my blog reader contacted me and told that their event log and ERRORLOG is full of below the messages:
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database.…
Read More
SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081
[Note from Pinal]: This is a 81th episode of Notes from the Field series. Master Data Services is one of the most important, but a very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI experts. I requested Reeves from LinchiPin people to help me answer this unique question. Let us learn in this blog post how to add reference data to Master Data Services (MDS).
SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server
How many times you had a problem where you have deployed a high availability solution, but the application is not able to use database and getting login failed for user after failover? Note that this issue would happen only with SQL Logins not Windows Login. You would understand the reason shortly. Here are the situations where you might face login failure.
SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074
[Note from Pinal]: This is a 74th episode of Notes from the Field series. Agile is a time boxed, iterative approach to software delivery that builds software incrementally from the start of the project, instead of trying to deliver it all at once near the end. Storytelling is an art very few have mastered in their life. When I requested Stuart to share his ideas about agile, he shared a very interesting insight on this subject. He had very interesting stories to share about 3 common mistakes of agile development. I very much enjoyed his notes from the field and I am confident that you will like it too.
In this episode of the Notes from the Field series database expert Stuart Ainsworth explains about 3 Common Mistakes of Agile Development.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
[Note from Pinal]: This is a 72th episode of Notes from the Field series. Master Data Services is one of the most important but very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI…
Read MoreSQL SERVER – Marking Filegroup as ReadOnly with SQL Server
My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and they wanted to know how this can be done. This blog post is in continuation to…
Read More