{"product_id":"microsoft-sql-server-2012-standard","title":"Microsoft SQL Server 2012 Standard","description":"\u003cul\u003e\n\u003cli\u003e\u003cspan\u003eSQL Server Standard\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan\u003eDigital download\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan\u003eDiscounted price\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan\u003e24\/7\/365 customer support \u003c\/span\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eBetter Database Management\u003c\/h3\u003e\n\u003cp\u003eIt goes without saying that almost any business in today’s world requires database management software or DBMS. In order to have all your data in perfect order, readily available and easily accessed, you need a program that will guarantee you performance, scalability and intuitiveness of the highest order. This is what Microsoft SQL Server 2012 brings to the table, thanks to a variety of innovative features and valuable enhancements that will give you all you need in a DBMS.\u003c\/p\u003e\n\u003cp\u003eThe Standard edition of Microsoft SQL Server 2012 consists of the core database package along with standalone services. It also offers larger database support, reduced hardware limitations and inclusion of valuable tools that will help your business immensely, making it the ideal choice for managing departmental databases in small- and medium-sized enterprises. Keep reading to get acquainted with the key new features, gadgets and improvements in SQL Server 2012 Standard, as well as why they result in such strong advantages of this excellent DBMS.\u003c\/p\u003e\n\u003c!-- split --\u003e\n\u003ch2\u003eFeatures\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003e• Transact-SQL\u003c\/strong\u003e\u003cspan\u003e is stronger in Microsoft SQL Server 2012 with different enhancements such as a \u003c\/span\u003e\u003cstrong\u003eSEQUENCE object\u003c\/strong\u003e\u003cspan\u003e, a logical function such as \u003c\/span\u003e\u003cstrong\u003eIIF \u003c\/strong\u003e\u003cspan\u003eand \u003c\/span\u003e\u003cstrong\u003eCHOOSE\u003c\/strong\u003e\u003cspan\u003e, date and time function, among others.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e• Features \u003c\/span\u003e\u003cstrong\u003eDistributed Replays\u003c\/strong\u003e\u003cspan\u003e, which allows you to capture a workload in one server instance and replay it in another. This is handy when doing application compatibility testing and capacity planning.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e• Query the meaning of a document using the new \u003c\/span\u003e\u003cstrong\u003eSemantic Search\u003c\/strong\u003e\u003cspan\u003e feature. Semantic Search provides you with an efficient way to organize relevant data by \u003c\/span\u003e\u003cstrong\u003e\u003cem\u003eextracting key\u003c\/em\u003e\u003c\/strong\u003e\u003cspan\u003ewords and phrases from documents and finding similar matches. \u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e• Use \u003c\/span\u003e\u003cstrong\u003eFILESTREAM\u003c\/strong\u003e\u003cspan\u003e feature in \u003c\/span\u003e\u003cstrong\u003e\u003cem\u003eFileTable\u003c\/em\u003e\u003c\/strong\u003e\u003cspan\u003e to manage files on a file server via unique tables. Any changes made on the \u003c\/span\u003e\u003cstrong\u003e\u003cem\u003eFileTable\u003c\/em\u003e\u003c\/strong\u003e\u003cspan\u003e automatically reflects on the file server.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e• Features new \u003c\/span\u003e\u003cstrong\u003eContained Databases\u003c\/strong\u003e\u003cspan\u003e, a feature that includes all the defining metadata and database settings. One merit of using a contained database is that it is independent of instance, \u003c\/span\u003e\u003cstrong\u003e\u003cem\u003ecollation\u003c\/em\u003e\u003c\/strong\u003e\u003cspan\u003e and \u003c\/span\u003e\u003cstrong\u003e\u003cem\u003eTempDB.\u003c\/em\u003e\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e• Supports \u003c\/span\u003e\u003cstrong\u003eDatabase Mirroring\u003c\/strong\u003e\u003cspan\u003e and \u003c\/span\u003e\u003cstrong\u003eProtection\u003c\/strong\u003e\u003cspan\u003e; this is achieved through a new packet of \u003c\/span\u003e\u003cstrong\u003eAlwaysOn\u003c\/strong\u003e\u003cspan\u003e feature. You can now replicate your information without any noticeable drop in performance. In case the primary server stops function, the new \u003c\/span\u003e\u003cstrong\u003eAlwaysOn\u003c\/strong\u003e\u003cspan\u003e failover cluster takes effect instantly.\u003c\/span\u003e\u003c\/p\u003e\n\u003c!-- split --\u003e\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003cdiv class=\"col-12 col-sm-12 col-md-12 col-xl-12\"\u003e\n\u003cdiv class=\"inner-container\"\u003e\n\u003cdiv class=\"systemreq-container\"\u003e\n\u003cdiv\u003e\n\u003ch4\u003e\u003cstrong\u003eHardware\u003c\/strong\u003e\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eProcessor - 1GHz and above (x86); 1.4GHz and above (x64)\u0026lt;\u003c\/li\u003e\n\u003cli\u003eProcessor type - AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support (x64); Pentium III-compatible processor or faster (x86)\u0026lt;\u003c\/li\u003e\n\u003cli\u003eMemory - 1GB (recommended 4GB and higher, depending on database size)\u0026lt;\u003c\/li\u003e\n\u003cli\u003eHDD - at least 6GB available disk space\u0026lt;\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eSoftware\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003e.NET Framework 3.5 SP1\u003c\/li\u003e\n\u003cli\u003eWindows Powershell 2.0 (required for installation)\u003c\/li\u003e\n\u003cli\u003eOS - Windows Vista SP2 Business (32- or 64-bit) and above; Windows Server 2008 Web (32- or 64-bit) and above\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":40396380241975,"sku":"sql2012std","price":36100.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0090\/2125\/9831\/files\/microsoft-software-microsoft-sql-server-2012-standard-31474788859959.png?v=1714628869","url":"https:\/\/softwarekeep.com\/en-in\/products\/microsoft-sql-server-2012-standard","provider":"SoftwareKeep","version":"1.0","type":"link"}