Daniel Calbimonte

 

Daniel Calbimonte is a Microsoft Most Valuable Professional, Microsoft Certified Trainer and Microsoft Certified IT Professional for SQL Server. He is an accomplished SSIS author, teacher at IT Academies and has over 10 years of experience as a QE and developer for SQL Server related software. He has worked for the government, oil companies, web sites, magazines and universities around the world. Daniel also regularly speaks at SQL Servers conferences and blogs.

2018 Awards
  

2017 Awards
     

2016 Awards
     

2015 Awards
  

2013 Awards
  

• Automate SQL Server Analysis Services Tasks with PowerShell - Part 2 (last update: 5/17/2013)
  
• Create SQL Server Analysis Services Partitions using AMO (last update: 11/9/2012)
  
• How to synchronize two SSAS Servers (last update: 4/15/2013)
  
• Import data from Azure SQL to Tabular Databases (last update: 8/18/2016)
  
• New features for SQL Server Analysis Services Tabular Databases in PowerShell (last update: 10/12/2016)
  
• PowerShell Commands for SQL Server Analysis Services Tabular Mode (last update: 12/12/2014)
  
• Retrieve SSAS Properties Using Analysis Services Management Objects and SSIS (last update: 3/28/2018)
  
• Using ASCMD to run command line scripts for SQL Server Analysis Services (last update: 6/8/2012)
  
• Using PowerShell for SSAS to check service status and database availability (last update: 7/9/2013)
  

• Common DAX functions and expressions for a SQL Server Tabular Database (last update: 9/6/2016)
  
• Dynamic XMLA using T-SQL for SQL Server Analysis Services (last update: 11/2/2012)
  
• New DAX functions in SQL Server 2016 (last update: 12/28/2015)
  
• New SQL Server Tabular Projects for Analysis Services (last update: 6/20/2012)
  
• SQL Server Analysis Services ProcessAdd for a Partition (last update: 3/17/2014)
  
• Tabular vs Multidimensional models for SQL Server Analysis Services (last update: 1/28/2016)
  

• Copy SQL Server Analysis Services Dimensions (last update: 12/17/2012)
  
• Using ProcessAdd to add rows to a dimension in SQL Server Analysis Services SSAS (last update: 7/15/2013)
  

• Different options for creating a distinct count measure in SSAS (last update: 9/12/2013)
  

• Improve SQL Server Analysis Services Performance with the Usage Based Optimization Wizard (last update: 2/22/2013)
  
• Improving SQL Server Analysis Services Query Response Time with msmdsrv (last update: 3/25/2013)
  

• Getting Started with the DAX queries for SQL Server Analysis Services (last update: 10/28/2015)
  
• Using Excel to interact with a SSAS cube (last update: 2/27/2013)
  

• Automatically upload SQL Server Database Backups to Azure with Integration Services (last update: 9/14/2016)
  
• How to import data from Azure Blob Storage to a local file with SQL Server Integration Services (last update: 9/28/2016)
  

• Ways to compare and find differences for SQL Server tables and data (last update: 5/22/2019)
  

• Getting Started with DevOps and SQL Server (last update: 2/20/2018)
  
• Tool to Deploy SQL Server Database Changes (last update: 7/5/2012)
  

• Format SQL Server Dates with FORMAT Function (last update: 12/6/2018)
  

• SQL Server Semantic Search to Find Text in External Files (last update: 10/4/2012)
  

• Data Import Performance Comparison T-SQL vs SSIS for large import (last update: 4/12/2016)
  
• Import Data from a SQL Server Multidimensional Database to a Tabular Database (last update: 8/2/2016)
  
• Simple step by step process to import MS Access data into SQL Server using SSIS (last update: 5/8/2012)
  

• Getting Started with SQL Server Integration Services SSIS Parameters vs. Variables (last update: 5/12/2016)
  

• Import multiple images to SQL Server using SSIS (last update: 4/11/2012)
  

• Example using Web Services with SQL Server Integration Services (last update: 7/9/2014)
  
• Export data from MySQL to SQL Server (last update: 3/16/2012)
  
• Export data from Postgres to SQL Server using SSIS (last update: 4/3/2012)
  
• Export images from a SQL Server Table to a Folder with SSIS (last update: 8/20/2012)
  
• Fire Events, Execute T-SQL Commands and Run SMO with the SSIS Script Task (last update: 3/23/2016)
  
• Getting started with the SSIS Script Task (last update: 3/18/2016)
  
• Importing SQL Server Data Using SSIS - Which Option is Fastest (last update: 7/13/2012)
  
• Integration Services (SSIS) Convert from Package Deployment Model to Project Deployment Model (last update: 6/3/2016)
  
• SQL Server Integration Services C# Script Task Example (last update: 4/6/2016)
  
• SSIS Expression Examples for Dates, String Concatenation, Dynamic File Names and More (last update: 1/22/2019)
  
• SSIS Expressions for Email Addresses, Random Numbers, File Names, Round, OR and XOR Logic and More Examples using SQL Server Integration Services (last update: 3/13/2019)
  
• Steps to Import MariaDB Objects and Data into SQL Server (last update: 12/19/2014)
  
• Transfer files from Linux to Windows or vice versa using SSIS (last update: 1/6/2014)
  

• Run an Oracle package from SQL Server Integration Services (last update: 9/14/2012)
  

• SQL Server Integration Services Performance Comparison for Row Counts and Data Imports (last update: 5/3/2016)
  

• Adding an Active Directory User with the Integration Services (SSIS) Script Task (last update: 6/10/2016)
  

• Compare Tabular Databases vs. PowerPivot (last update: 10/18/2016)
  
• PowerPivot Example with SQL Server 2012 (last update: 12/24/2012)
  

• Automated Notification Email for SQL Server Object Modifications (last update: 2/6/2018)
  

• Code Comparison for SQL Server vs. MariaDB (last update: 2/6/2015)
  
• Compare MariaDB vs SQL Server SQL Commands (last update: 1/15/2015)
  
• Compare SQL Server and MariaDB Operational Technology (last update: 3/13/2015)
  
• Compare SQL Server and Oracle Coding - Part 2 (last update: 6/18/2015)
  
• Comparing Oracle and SQL Server Code - Part 1 (last update: 6/12/2015)
  
• Comparison of Oracle and SQL Server Management Tools (last update: 8/21/2015)
  
• Comparison of SQL Server and Oracle terminology (last update: 4/30/2015)
  
• More SQL command comparisons between SQL Server and MariaDB (last update: 2/27/2015)
  

• Using PowerShell for SQL Server Analysis Services tasks - Part 1 (last update: 5/6/2013)
  

• SQL Server Career Paths (last update: 11/9/2017)
  

• Getting Started as a Microsoft Certified Trainer (MCT) (last update: 10/9/2017)
  
• How to become a SQL Server MVP (last update: 10/31/2017)
  
• Microsoft Professional Program (MPP) Overview (last update: 12/13/2017)
  
• Overview and Benefits of the Microsoft Certified Educator (MCE) Program (last update: 12/29/2017)
  
• SQL Server versus Oracle certification information (last update: 4/24/2015)
  
• Study material for exam 40-473 Designing and Implementing Cloud Data Platform Solutions (last update: 6/13/2017)
  
• Study material for exam 70-339 Managing Microsoft SharePoint Server 2016 (last update: 1/23/2018)
  
• Study material for exam 70-461 Querying Microsoft SQL Server 2012 and 2014 (last update: 11/28/2016)
  
• Study material for exam 70-462 Administering Microsoft SQL Server 2012 and 2014 Databases (last update: 11/9/2016)
  
• Study material for exam 70-464 Developing Microsoft SQL Server Databases (last update: 12/23/2016)
  
• Study material for exam 70-465 Designing Database Solutions for Microsoft SQL Server (last update: 12/30/2016)
  
• Study material for exam 70-466 Implementing Data Models and Reports Preparation Materials (last update: 2/16/2016)
  
• Study material for exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server (last update: 1/11/2017)
  
• Study material for exam 70-475 Designing and Implementing Big Data Analytics Solutions (last update: 7/10/2017)
  
• Study material for exam 70-532 Developing Microsoft Azure Solutions (last update: 5/1/2017)
  
• Study material for exam 70-533 Implementing Microsoft Azure Infrastructure Solutions (last update: 5/12/2017)
  
• Study material for exam 70-534 Architecting Microsoft Azure Solutions (last update: 6/6/2017)
  
• Study material for exam 70-535 Architecting Microsoft Azure Solutions (last update: 1/12/2018)
  
• Study material for exam 70-537 Configuring and Operating a Hybrid Cloud with the Microsoft Azure Stack (last update: 3/6/2018)
  
• Study material for exam 70-761 Querying Data with Transact-SQL (last update: 1/25/2017)
  
• Study material for exam 70-762 Developing SQL Databases (last update: 2/8/2017)
  
• Study material for exam 70-764 Administering a SQL Database Infrastructure (last update: 2/17/2017)
  
• Study material for exam 70-765 Provisioning SQL Databases (last update: 3/7/2017)
  
• Study material for exam 70-767 Implementing a SQL Data Warehouse (last update: 3/17/2017)
  
• Study material for exam 70-768 Developing SQL Data Models (last update: 4/7/2017)
  
• Study material for exam 70-773 Analyzing Big Data with Microsoft R (last update: 7/21/2017)
  
• Study material for exam 70-774 Perform Cloud Data Science with Azure Machine Learning (last update: 8/3/2017)
  
• Study material for exam 70-775 Perform Data Engineering on Microsoft Azure HDInsight (last update: 8/14/2017)
  
• Study material for exam 70-776 Perform Big Data Engineering on Microsoft Cloud Services (last update: 9/27/2017)
  
• Study material for exam 70-777 Implementing Microsoft Azure Cosmos DB Solutions (Beta) (last update: 7/26/2018)
  
• Study material for exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI (beta) (last update: 8/24/2017)
  
• Study material for exam 70-779 Analyzing and Visualizing Data with Microsoft Excel (last update: 9/1/2017)
  
• Study material for exam 98-364 Database Fundamentals (last update: 4/10/2017)
  
• Study material for exam AZ-100 Microsoft Azure Infrastructure and Deployment (last update: 3/20/2019)
  
• Study material for exam AZ-101 Microsoft Azure Integration and Security (last update: 4/5/2019)
  
• Study material for exam AZ-203 Developing Solutions for Microsoft Azure (last update: 4/25/2019)
  
• Study material for exam AZ-400 Microsoft Azure DevOps Solutions (beta) (last update: 2/11/2019)
  

• Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database (last update: 7/20/2016)
  

• Creating a SSRS report using a mySQL data source (last update: 4/18/2012)
  

• SQL Server Database Stuck in Restoring State (last update: 9/6/2018)
  

• Calculate the Geographical Distance Between Two Cities in SQL Server (last update: 8/6/2012)
  

• JSON Support in SQL Server 2016 (last update: 9/2/2015)
  

• Simple way to create a SQL Server Job Using T-SQL (last update: 9/25/2013)