top of page
How to fix Orphaned Users easily
What are Orphaned Users “Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant...
Madeira Team
Jan 3, 20184 min read
How to troubleshoot database mail?
If after creating a DB Mail Profile and an account you send a test email and it doesn’t work, you can try these steps to troubleshoot it:...
Madeira Team
Dec 25, 20171 min read
What is the Automatic Plan Correction in SQL Server 2017?
SQL Server 2017 brings a new interesting feature, that might be a game changer in some environments. I’m talking about Automatic Plan...
Madeira Team
Dec 25, 20172 min read
SQL Saturday Nepal 2017
I had the honor to visit Nepal and participate in SQL Saturday Nepal 2017. You can visit the event website here. I presented a session...
Madeira Team
Dec 23, 20172 min read
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is...
Madeira Team
Dec 7, 20173 min read
Why is the job duration a negative number?
About a month ago I noticed, on one of our clients’ server, a weird duration time for one of the jobs – the job duration was negative. As...
Madeira Team
Dec 2, 20171 min read
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL Server. I promised to...
Madeira Team
Nov 19, 20172 min read
Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the responses, analyzed...
Madeira Team
Nov 18, 20173 min read
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The former is used to lock resources...
Madeira Team
Nov 18, 20173 min read
Why I Believe in the Data Architecture Review
We have a solution called Data Architecture Review. With this solution, we conduct a complete review of the customer’s data environment....
Madeira Team
Oct 23, 20175 min read
bottom of page