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 »
The WordPress CMS platform today is counted as the most popular Content Management System in vogue today. It boasts of an ardent fan following and thousands of websites run on this trusted open source platform. Typically the WordPress CMS has been used on the LAMP technology stack with MySQL being the backend to facilitate its awesome capabilities. However many organizations who are predominantly on a Windows environment may wish to run a WordPress intranet site on a SQL Server backend. Given...
Read more »
