Today, we launched the newest generation of our SQL Server–dedicated website – SQL Server Solutions.
Tag Archives: SQL_Server
Last Contract Technologies
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.
fx: Instant Hiring
We also use the regular hiring process. The following does not apply to the regular hiring process. You may now also hire me instantly if you meet certain criteria. These criteria are:
- You must need either a SQL Server Database Administrator and/or SSRS Developer.
- The work location must be in Continue reading
HDIM Technical Library
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
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.