SQL Server Solutions

Looking to Boost Scalability of your SQL Server- Here’s What You Need To Do!

In this article we look at ways to scale up a SQL server implementation Whether you agree or not but deep inside your heart you must be wishing to optimize your SQL Server Database; but since scaling out a SQL Server running on multiple cores is bit difficult you might have hesitated to do so. Good news is that now you can easily boost the scalability of your individual SQL Server and in fact, now scaling up is easier than scaling out. In order to scale your existing SQL Server, you need...

Read more »

Locking in SQL Server

In this article we look at how locking happens in Ms SQL server and learn about their types Whether you know or not, the credit for handling a number of transactions in SQL Server goes to its Locking strategy. There are in fact, different types of locks for different types of query plans. This is not all; a user can make the server create more locks like the shared, holdlocks and noholdlocks for specific queries. Locking in SQL server can be done both at a larger level and at a smaller...

Read more »

Why is a database solution way better for storing records than a spreadsheet like Ms Excel

In this article we will explore the rationale behind using a database solution like SQL over a spreadsheet like Ms Excel in context of small and medium sized firms. Small Businesses are often at a loss while deciding to choose between a spreadsheet and a database solution while looking to execute routine tasks. Although, both have special features, yet it becomes difficult sometimes figuring out which one to use for what. Spreadsheets like MS Excel, a program which is a part of Microsoft...

Read more »