With business becoming increasingly competitive, even the shortest of the downtimes can prove risky for the reputation of an organization. Hence from a perspective of business continuity and data recovery, SQL Server administrators have for years relied on disk mirroring to keep things going in case of a fault. However mirroring has several limitations and this had lead Microsoft to roll out AlwaysOn availability groups from its 2012 SQL Server iteration which offers a whole deal of reliability...
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 save for future use by you and others to whom you have authorized access to. Incidentally SQL Server ships with several prebuilt procedures for the perusal of its users. Now there may be incidents where an user in your organization can complain that...
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. While most database professionals from a programming background are well versed with functions, others may be hesitant to use them. Essentially functions are pieces of reusable code that can be called in whenever necessary to execute a series of...
Read more »
