Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you don’t know how fast. What would be the...

There is a growing need for Graph Databases in the market. This is a type of database, which is capable of storing, representing and...

So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time. Users constantly complain about poor...

What are Orphaned Users “Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant...

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:...

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...

The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is...

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...

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...