Administrator, Architect & Developer

In addition to being a Microsoft SQL Server DBA (database administrator), architect, and developer, Dr. Bisconti is an X-DBA (database x-administrator), architect, and developer in the following databases:

4th Dimension, ADABAS, Adabas D, Alpha Five, Apache Cassandra, Apache Derby, Aster Data, Altibase, BlackRay, CA-Datacom, Clarion, Clustrix, CSQL, CUBRID, Daffodil database, DataEase, Database Management Library, Dataphor, DB2, DB2/2, dBase, Derby aka Java DB, Empress Embedded Database, EXASolution, EnterpriseDB, eXtremeDB, FileMaker Pro, Firebird, Foxpro, Greenplum, GroveSite, H2, Helix database, HSQLDB, IBM DB2, IBM Lotus Approach, IBM DB2 Express-C, IDMS, IMS, Infobright, Informix, Ingress, InterBase, InterSystems Caché, GT.M, Linter, MariaDB, MaxDB, MemSQL, Microsoft Access, Microsoft Jet Database Engine (part of Microsoft Access), Microsoft SQL Server, Microsoft SQL Server Express, Microsoft Visual FoxPro, Mimer SQL, mizanSQL, MonetDB, MongoDB, mSQL, MySQL, Netezza, NexusDB, NonStop SQL, Openbase, OpenLink Virtuoso (Open Source Edition), OpenLink Virtuoso Universal Server, OpenOffice.org Base, Oracle, Oracle Rdb for OpenVMS, Panorama, Paradox, Quattro Pro, Pervasive PSQL, Polyhedra, PostgreSQL, Postgres Plus Advanced Server, Progress, Progress Software, RDM Embedded, RDM Server, The SAS system, SAND CDBMS, SAP HANA, SAP Sybase Adaptive Server Enterprise, SAP Sybase IQ, SQL Anywhere (formerly known as Sybase Adaptive Server Anywhere and Watcom SQL), ScimoreDB, SmallSQL, solidDB, SQLBase, SQLite, Sybase, Sybase Advantage Database Server, Teradata, TimesTen, txtSQL, UDB, Unisys RDMS 2200, UniData, UniVerse, Vectorwise, Vertica, VMDS

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.

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:

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

 

SQL Server 2012

FeaturesEnterpriseBusiness

Intelligence

Standard
Maximum Number of CoresOS 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.