What is BI? BI stands for Business Intelligence (BI). Every enterprise requires understanding of how the company is performing, what area of the business requires focus to improve. To determine these, we need data, just data will not help, it requires analysis, calculations, in one word called metrics, to understand projected information. Source of the…
Sometimes I get asked this question, “What is SQL Server CTP edition?” Many people outside Microsoft think of a CTP as a “beta” release, we think of a CTP as a “Release Candidate” quality release with the ability to change the design and improve the test suite. The CTP version of the product has been…
Microsoft SQL is a relational database product from Microsoft Corporation. Any large application required by businesses and other organizations need a large amount of data to be stored and manipulated. Databases, working in tandem with a suitable application, have been the model used in such situations. Classical hierarchical and network databases have been replaced by…
Microsoft’s SQL Server 2014 was released to the public on April 1 2014. This version of SQL Server has quite a few new features, the biggest one is by far the In-Memory OLTP engine that makes performance boost by up to 20x times. Get the latest version of SQL Server 2014 here: http://www.microsoft.com/en-us/server-cloud/products/sql-server/ Noteworthy product…
UPDATE statement is one of common DML (data manipulation language) statements. Other DML statements include: SELECT INSERT DELETE UPDATE query is used to update or modify data in a Table or a View in a database. Using this statement, you can update a single field, multiple fields, single record or multiple records. Need to use…