How to Tips & Tricks
Microsoft SQL Server is a relational database management system developed by Microsoft. Its primary function is to store and retrieve data. It can be used to connect with with various programming language supported by .NET Technologies such as C#, VB.NET, F#, C++ etc.
To install SQL Server 2014 express edition and Management studio, visit - http://www.microsoft.com/en-in/download/details.aspx?id=42299, the URL may change based on the version release of Microsoft SQL Server in future so please search in search engines like Google or Bing and find the correct url. The current home page of SQL Server at Microsoft is http://www.microsoft.com/en-us/server-cloud/products/sql-server/. The SQL Server 2014 database details and versions can be found at http://www.microsoft.com/en-us/server-cloud/products/sql-server/.
The Express edition of the SQL Server is completely free and most suitable for the developers and small projects.
More details on different versions of SQL Server can be found at http://www.microsoft.com/en-us/server-cloud/products/sql-server/Purchasing.aspx.
Please also note that by default SQL Server database doesn’t have any user interface through which we can interact with the database so we use Microsoft SQL Server Management studio (Integrated Development Environment - IDE) to work with the SQL Server database.
Please ensure that when you are installing the database, you also choose to install Microsoft Management Studio or SQL Server (version) Management studio that let you manage the database (such as creating new database, tables, stored procedures etc).
Use left side course content to SQL Server How to Tips & Tricks that are based on real time problem and solutions.
Mr. Sheo Narayan is a software professional since 2000 (15+ years) and working in .NET Technologies since its first release. He is also the founder of a popular .NET Community website http://www.DotNetFunda.com. He has been awarded with Microsoft® Most Valuable Professional (MVP), Star Entrepreneur Award etc. He has served thousands of professionals worldwide in solving their technical problems and teaching them in their professional careers. His corporate training clients includes many MNCs.