Tag Archives: SQL_Server

Last Contract Technologies

Posted on by

This  was a cloud-computing project that utilized multiple technologies, including  AWS (Amazon Web Services), including RDS and EC2, Hadoop, Hive, Pig, Redshift,  SQL Server, MySQL, MySQL Workbench, and SSIS.   SQL Server and MySQL databases and SSIS were hosted in the AWS cloud and  the following tasks were completed:

  • Upgraded SQL Server 2008 to SQL Server 2008 R2 then applied SP3.
  • Created SQL Server and MySQL logical and physical models.
  • Created SQL Server and MySQL databases on both local and cloud servers.
  • Created SSIS packages to load SQL Server databases on both local and cloud servers.
  • Created and compiled SQL Server digital, educational library.
  • Created and compiled MySQL digital, educational library.
  • Designed SQL Server to SSIS to MySQL architecture.
  • Installed SQL Server 2008 and 2008 R2 on both local and cloud servers.
  • Installed MySQL and MySQL Workbench on both local and cloud servers.
  • Installed SSIS, SSAS, and SSRS.
  • Developed  accelerated, table generation tools.
  • Performed troubleshooting of numerous system components, including SSIS packages.
  • Used Embarcadero to translate diverse RDBMS DDL database generation SQL scripts.
  • Used Visual Studio 2008 to create SSIS packages.

HDIM Technical Library

Posted on by

We have posted information about our HDIM Technical Library under the Downloads menu option at the top of our website.  Information compression technology has been applied to the instructional modules that make up this library.  This allows the student to learn ten times faster than they can from other sources of instruction.  The link below will take you directly to the HDIM Technical Library page:

//biscontitechnologies.com/tenthgen/downloads/hdim-technical-library/.

 

SQL Server 2012

Posted on by
Features Enterprise Business

Intelligence

 Standard
Maximum Number of Cores OS Max¹ 16 Cores-DB

OS Max-AS&RS²

 16 Cores
Basic OLTP

X

X

X
Programmability (T-SQL, Data Types, FileTable)

X

X

X
Manageability (SQL Server Management Studio, Policy-based Management)

X

X

X
Basic High Availability³

X

X

X
Basic Corporate BI (Reporting, Analytics, Multidimensional Semantic Model, Data Mining)

X

X

X
Basic Data Integration (Built-in Data Connectors, Designer Transforms)

X

X

X
Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)4

X

X
Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPaq™ In-Memory Engine, Advanced Data Mining)

X

X
Enterprise Data Management (Data Quality Services, Master Data Services)

X

X
Advanced Data Integration (Fuzzy Grouping and Lookup, Change Data Capture)

X
Advanced Security (SQL Server Audit, Transparent Data Encryption)

X
Data Warehousing (ColumnStore Index, Compression, Partitioning)

X
Advanced High Availability (Multiple, Active Secondaries; Multi-site, Geo-Clustering)³

X

¹Existing SQL Server Enterprise edition licenses in the Server + CAL licensing model upgraded to SQL Server 2012 will be limited to server deployments with 20 cores or less. Refer to Datasheet and FAQ for more details.

²Analysis Services & Reporting Services.

³Basic includes log shipping, database mirroring, server core support and two-node Failover Clustering. Windows Server Enterprise edition or above is a system requirement for AlwaysOn / Failover Clustering.

4SharePoint Server with Enterprise CAL is a system requirement for Power View and PowerPivot for SharePoint. Alerting is accessible through SharePoint Foundation or above.