- Business Intelligence with MicroStrategy Cookbook
- Davide Moraschi
- 316字
- 2021-07-23 15:31:57
Installing SQL Server 2012 Express LocalDB
We will use Microsoft SQL Server for our practice; there are several versions out there both free and commercial. I selected the LocalDB because it's the one with less memory footprint and yet, has a complete set of features.
Getting ready
You will need to download some software prior to installation:
- Microsoft .NET Framework 4.0 available at http://at5.us/Ch1U3
- Update 4.0.2 for Microsoft .NET Framework 4.0 (as in Microsoft article KB2544514) available at http://at5.us/Ch1U4
- SQL Server 2012 Express LocalDB available at http://at5.us/Ch1U5
- SQL Server Native Client 11.0 available at http://at5.us/Ch1U6
- SQL Server 2012 Command Line Utilities available at http://at5.us/Ch1U7
- AdventureWorks DW Database creation scripts available at http://at5.us/Ch1U8
Download all these files and put them in a folder, for example, C:\install\.
How to do it...
The setup is very straightforward, in a command prompt window do the following:
- Install the SQL Server 2012 Express LocalDB engine by running:
C:\install\SqlLocaLDB.MSI - Accept the agreement and click your way out through the Next button; no special attention other than clicking on Continue to allow the user account control permission to install. The setup will take one minute, if not seconds, and it's very simple.
How it works...
We are using a stripped down version of Microsoft SQL Server 2012 database. This LocalDB engine features almost everything from the full-fledged product but runs as a user application, not as a service like its major siblings do. It is important to remember this detail because only the currently logged on user will be able to connect to the database instance.
LocalDB has very low memory requirements and guarantees quick data access on small machines.
There's more...
Check the successful outcome by issuing in a command prompt:
sqllocaldb info
The system will answer with the version number:
v11.0
which is also the name of the default instance.
- 新中國審計制度變遷
- 新形勢下中國投入產出核算的變革與實踐
- Pentaho Business Analytics Cookbook
- 國有企業經濟責任審計實務指南
- Mastering System Center Configuration Manager
- Splunk：Enterprise Operational Intelligence Delivered
- Citrix? XenMobile? Mobile Device Management
- 企業能源審計與節能規劃
- Business Intelligence with MicroStrategy Cookbook
- 基本有用的計量經濟學
- 成功通過PMP（第3版）
- 2017年度注冊會計師全國統一考試專用教材（圖解版）：審計
- 項目管理實務（第二版）
- PMP備考寶典：路晨帶你去通關
- Oracle E-Business Suite Financials R12：A Functionality Guide