SQL przydatne linki

 

Training Data Bases	DB Script	Data File	Schema
BANK_v2
AdventureWorks 2008 R2
AdventureWorks DW 2008
AdventureWorks DW 2008 R2
AdventureWorks LT 2008
AdventureWorks LT 2008 R2
AdventureWorks OLTP 2008
AdventureWorks OLTP 2008 R2
AdventureWorks OLTP 2008
Adventure Works Cycles Database 2000
Northwind

SQL Server 2008 R2

• SQL Server 2008 R2 Express SP1 - Express Edition link: http://www.microsoft.com/en-us/download/details.aspx?id=26729 po kliknięciu w przycisk "download", mamy do wyboru wersje: - SQLEXPR32_x86_ENU.exe (93.1 MB) - SQLEXPR_x64_ENU.exe (117.5 MB) - SQLEXPR_x86_ENU.exe (106,1 MB) - SQLEXPRADV_x64_ENU.exe (980.9 MB) - SQLEXPRADV_x86_ENU.exe (867.0 MB) - SQLEXPRWT_x64_ENU.exe (329.9 MB) - SQLEXPRWT_x86_ENU.exe (308.4 MB)
• SQL Server 2008 Management Studio Express link: http://www.microsoft.com/en-us/download/details.aspx?id=7593
• SQL Server 2008 R2 Service Pack 2: link: http://www.microsoft.com/en-us/download/confirmation.aspx?id=30437

Dodatki potrzebne do instalacji SQL Server 2008 R2

• .NET Framework 3.5 SP1 link: http://go.microsoft.com/fwlink/?LinkId=159615
• Microsoft Windows Installer 4.5 link: http://go.microsoft.com/fwlink/?LinkId=159623
• Windows PowerShell link: http://www.microsoft.com/en-us/download/details.aspx?id=16818

Microsoft SQL Server 2012 Express

• link: https://www.microsoft.com/en-us/download/details.aspx?id=29062

Microsoft SQL Server 2014 Express

• link: https://www.microsoft.com/en-us/download/details.aspx?id=42299

Bazy Danych (przykładowe)

• BANK_v2 DB Script - BANK_v2 DB Script
• BANK_v2 Data File - BANK_v2 Data File
• AdventureWorks 2008 R2 Data File - http://msftdbprodsamples.codeplex.com/downloads/get/478216
• AdventureWorks DW 2008 R2 Data File - http://msftdbprodsamples.codeplex.com/downloads/get/670505
• AdventureWorks DW 2008 R2 DB Script - http://msftdbprodsamples.codeplex.com/downloads/get/364193
• AdventureWorksDW 2008 DB Script - http://msftdbprodsamples.codeplex.com/downloads/get/364193
• AdventureWorks LT 2008 R2 DB Script - https://awlt2008dbscript.codeplex.com/downloads/get/124436
• AdventureWorks LT 2008 DB Script - https://awlt2008dbscript.codeplex.com/downloads/get/93332
• AdventureWorks 2008 R2 OLTP DB Script - http://msftdbprodsamples.codeplex.com/downloads/get/363849
• Adventure Works Cycles Database 2000 Data File - http://www.microsoft.com/en-us/download/details.aspx?id=4385
• Northwind Data File - http://www.microsoft.com/en-us/download/confirmation.aspx?id=23654
• Northwind - http://archive.msdn.microsoft.com/northwind/Release/ProjectReleases.aspx?ReleaseId=1401

Schematy

• AdventureWorks 2008 OLTP Schema - schemat
• Adventure Works 2008 Data Warehouse schema - schemat
• AdventureWorks OLTP Database Diagram - http://www.microsoft.com/en-us/download/details.aspx?id=10331 - AdvWorksOLTPSchemaHTML.exe - AdvWorksOLTPSchemaVisio.vsd
• Northwind - schemat

Inne

• Słownik danych AdventureWorks - http://technet.microsoft.com/pl-pl/library/ms124438(v=sql.100).aspx
• Microsoft SQL Server Community Projects & Samples - http://sqlserversamples.codeplex.com/