97Apprenticeship Alum
- 4
How to Work With Very Large Data Sets Using Excel
Explore the techniques to handle very large data in Excel from Azure. Use any of Microsoft Azure storage options like HDInsight (Hive), CosmoDB, Azure Storage or MongoDB in Azure with Azure Analysis Services from Excel and Power Query.
- 2
8 Ways to Use Python With Excel
Python and Excel are both powerful tools for data exploration and analysis. They're both powerful, and even more so together. There are different libraries that have been created over the past several years to integrate Excel and Python or vice versa.
- 2
4 Ways to Compare Data in Excel Using Power Query
Comparing two data sets in Excel is quite easy using Power Query and the Merge operation. The Merge operation can perform inner and outer join operations on your data. This article will explain the different types of operations.
- 0
Execute PowerShell Scripts through SQL Server T-SQL
Execute PowerShell command (cmdlets) directly from T-SQL on SQL Server. Also execute PS1 script files from T-SQL on SQL Server and optional store the data in a SQL Table.
- 10
4 Ways to Export Data From Power BI
While Power BI has the technology to allow users to import data from many data sources easily, many data analyst and business users don't realize that it is just as easy to export data from Power BI. I will show you how.
- 7
Easily Import and Export Excel Data to SQL Server
Adding a few lines of VBA code to Excel will allow you to dynamically export your data in a Worksheet to a Microsoft SQL Server without the need of a programmer.
- 0
10 Tips for Working With Large Excel Files
In our world of data analytics and big data, there is no getting away from our beloved data crunching and wrangling tool: Excel. However, with large data sets, Excel starts to huff and puff. These 10 tips will help crunch your data for the last minute meeting like a pro.
- 22
Create Radio Buttons and Checkboxes for iOS Applications
Create beautiful custom control radio buttons and checkboxes for your iOS (iPhone, iPad) applications. Follow this simple tutorial to create radio buttons and checkboxes that fit the style of your app and requires very little code.
- 2
How to open and view PDF files using Objective-C
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
- 31
Create PDF using iOS UIKit
Learn to create PDF documents using the APIs in the iOS UIKit. Use the UIGraphicsBeginPDFContextToFile and the UIGraphicsBeginPDFContextToData to quickly create and save PDF files with this sample iOS iPhone app.
- 5
How-To Execute CLI Commands from T-SQL
Run WMI queries and process or another DOS or Windows process from SQL Server using the SQL xp_cmdshell function. This tutorial walks you through how to setup xp_cmdshell on the server and execute different types of queries and storing those values in tables.
- 2
How to Backup Windows Registry With VB Script or JavaScript
Use the CommandLine, VBScript, or JScript to export a Windows Registry or keys.
- 28
How to Write a Software Development Proposal
A free and complete software development proposal template with budget, ROI and CAGR formulas and instructions. Detailed instructions to help you prepare a winning software development proposal.
- 18
How to Reduce a Large Excel File
Reduce Excel file size using this techniques like file compression, data management, switching to a binary format and using PowerPivot or PowerQuery.
- 0
How-To Develop an iOS AVPlayer Application and AirPlay
Create AVPlayer applications for iPAD that uses AirPlay. This tutorial provides complete instructions
- 69
How-To Pass Data from UITableView to Detail View Controller
This tutorial demonstrates how to display data in a detail view controller for an iOS app, based on the selection in the UITableView.
- 18
A Beginner’s Guide to Storyboard Object Connections & Delegates on iOS
This Storyboard Connections tutorial provides insight on how to create connection in a Storyboard, set delegates, add code to interact with the different objects. It is designed for new programmers or at least programmers just learning the technology. It also show how to dismiss the keyboard suing...
- 5
How To Develop a Standalone (EXE) C# Application
It is easy to create standalone application using C# or even VB.Net. This tutorial provides the step by step instructions on how to create your own.
- 23
How-To Read and Write to Files with iOS SDK (Objective-C)
There are several ways to use Objective-C to read, write and create files and directories. This tutorial presents one way, which is adapted for the IOS 5 SDK.
- 258
Tutorial on Creating an iOS SQLite Database Application for iPhones and iPads
(c) klanguedoc 2010. iOS SQLite Database is a tutorial that demonstrates how to create an iOS iPhone and iPad applications with a SQLite database.
- 70
Tutorial on using VBA in Excel to Connect to SAP RFC
This tutorial demonstrates how to make a silent connection using VBA (or Visual Basic), either from an Excel worksheet or VB client. The tutorial uses the BAPI Control and SAP Logon Control, both of which, are included with the SAPGui and RFC SDK.
- 133
How to Use SAP Nco 3 Connector with C# and .Net
This is a tutorial on using the SAP .Net Connector, NCO 3.0.3.0 for .Net 4 and Visual Studio
- 2
How to Find an Item in ArrayCollection Without getItemIndex() using Apache Flex and ActionScript
Since getItemIndex doesn't return a match lookup value,instead always returns -1, this solution is a great workaround, even on long lists
- 2
How-To Synchronize Data Between Excel and SQL Server
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
- 3
How to Execute Command Line Commands Using T-SQL
The Transact-SQL language has many far fetched functions and commands. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.
- 16
How to Develop With Microsoft Office Excel and C#
How to Develop an Excel App using the VSTO Interop services (com) and C#. This hub also demonstrates how to add a ribbon and interact with the app from the ribbon.
- 0
How-To use xp_cmdshell with SQL Server and T-SQL
Transact-SQL boast many specialized stored procedures, enabling the developer or administrator to interface with every part of the Microsoft platform. This tutorial presents some example on how -to use vbscript to obtain information about the file system (files, directories, attributes)