In this article we look at the vulnerabilities associated with enabling SQL Mail and look at ways to work around such security issues For SQL users, enabling an email database for replying to database queries is possible, since queries are...
Read more »In this article we look at key security vulnerabilities that one can possibly be exposed to while working with SQL Server Express edition. All editions of SQL Server although come with a lot of security features, the user might still have to face...
Read more »Several times SQL Server might be the reason for the space issue on disks. In this article, we will see what the root causes for this issue are and how we can fix it. Your SQL Server needs space. Many times SQL Server will need disk space. This...
Read more »Monitoring database growth is a key factor in planning a server's resource. Use this script and create easy to understand database growth report Why You Need to Monitor Database Growth If you are a SQL Database administrator and if you are not...
Read more »In this article we look at the key functions of transaction logs in SQL Server Transaction Log, as the name suggests, keeps a log of all the transactions that are taking place; along with the database modifications it’s making each day. It is...
Read more »This sections aims to explain in brief the functions of MDF and LDF files in an SQL server database. Other than that, the post also explains basic differences between the two. MDF and LDF Files in SQL Server Database All the companies need a...
Read more »In this article we check out the cause behind the SQL Server error code 17 Sometimes while trying to access the SQL Server database, one might come across an error stating “SQL Server does not exist or access denied”. This is a general...
Read more »In this article we attempt to diagnose SQL Server Error 18456 and look at its possible causes The Ms SQL Server application finds a place across an array of organizations in the world today ranging from small businesses to huge corporations....
Read more »Stored procedures in MS SQL Server offer us a great deal of flexibility by which users can avoid writing queries every time for performing tasks that are typically repeated. For the uninitiated, stored procedures are nothing but queries that you can...
Read more »The MS SQL Server is considered one of the most versatile database applications in vogue today and it packs in quite a punch to ease your work. Now while you are creating queries to run on the SQL Server database, you can include functions in them....
Read more »