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.
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.
In our world of advanced analytics and big data, there is no getting away from our beloved data crunching and wrangling tool: Excel. However, with large datasets, Excel starts to huff and puff. These 10 tips will help crunch your data for the last minute meeting like a pro.
A critical component of any iOS application with a database is implementing a backup strategy. This how-to article provides many options for backing up a SQLite database, which is the standard database choice for iOS apps.
How to create a function module to query the KNVV table using ABAP SQL.
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.
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
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.
Step forwards and backwards though data in SQLite database. Learn how to browse data in a SQLite database using this iPhone app which uses a UITextField and an UITextView to capture and display data to and from the database. The tutorial also shows how to dismiss the keyboard from the UITextField...
This sample code and example iPhone app demonstrates a solution to remove the blinking cursor from an UITextField in an iOS app. This is handy as the app demonstrates to use with an UIDatePicker to allow a user to select the UITextField with no cursor and trigger the app to load the UIDatePicker...
Learn how to store binary data like image in a SQLite database from an iPhone iOS app. You will also learn how to convert the uiimage to binary data for storage and retrieval in an UIImageView using an UIPickerView as a selector.
Learn how easy it is to develop Android App with SQLite using Adobe Flash Builder and Flex. Adobe's Flash APIs have native support for SQLite making developing Android apps easy. Using Adobe Air and the ADT in Flash Builder you can make an Android app in a few hours, thus greatly increasing your...
Sitting postures to avoid back pain while sitting at a computer workstation or desk starts with an office ergonomic chair. Choosing the right office chair to lower pain is key to good posture for computer use. Lower your lower back pain from sitting while sitting by selecting a good office chair...
Easy examples on string format specifiers in iOS NSString objective-c programming. Add values of different data types to strings using c code that conforms to IEEE c printf. Examples for all supported string formaters specifiers.
How to make an iOS app using Flash. Learn to make Flash Builder apps for Flash iOS development. With Flash app development, you can create iOS apps for App Store. Adobe Air will convert to native iOS code for great mobile apps.
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.
iOS UIPickerView is a versatile UI control in the UIKit of the Cocoa Touch Framework. Learn how to create single and multi-column UIPickerViews with this tutorial.
Use the CommandLine, VBScript, or JScript to export a Windows Registry or keys.
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.
Reduce Excel file size using this techniques like file compression, data management, switching to a binary format and using PowerPivot or PowerQuery.
This tutorial provides all the steps to manually add Core Data to an existing application or to an iOS application, like a Single View Application, without using a pre-existing Core Data template. This tutorial assume that no Navigation Controller or Tab Bar Navigator is used.
Learn how to store UIImage (image) data in Core Data using this tutorial.
Develop a SplitViewController iPad in Xcode 4.3.2 and iOS 5.1. This tutorial provides complete instructions.
Develop 2d and 3d graphics using the GLkit and the open GL ES frameworks. This tutorial provides a great introduction on GLKBaseEffect, GLKSkyBoxEffect, GLKTextureLoader and how to setup a basic animation in iOS.
Create AVPlayer applications for iPAD that uses AirPlay. This tutorial provides complete instructions
iOS Property List files, or plist files, are a great way to store data and to use them to store config setting specific to your app or even to use them instead of global variables. This tutorial teaches you how to create plist files and read and write to them using Core Foundation classes as well...
iOS SQLite Database for iPhone and iPad is a tutorial demonstrating how to Insert, Update, Delete, Select (CRUD) data from a UIViewController into a SQLite database in an iPhone or iPad application. Display data from a SQLite database in UITableViewcontroller. How to push selected data from the...
This tutorial demonstrates how to display data in a detail view controller for an iOS app, based on the selection in the UITableView.
iOS, what is the best ways the make data globally available? One possible solution is to use a Singleton as this tutorial demonstrates. Using a Singleton to pass data between multiple view controllers and other objects is a fairly safe way of transferring data. This tutorial shows you how with...
With iOS 5 and ARC, the #define keyword is frown upon and creates linkage issues with the compiler. You still can create Global Variables, but without the #define macro. This tutorial shows you how.
The IOS 5 UIAlertView is a versatile popover that offers several styles. Logins, Prompts, Text Messages. This tutorial offers several examples on how to implement the UIAlertView for iPad and iPhone or iPod Touch.
IOS, send data from one View Controller (scene) to another View Controller (scene) using a segue and the prepareForSegue. This is a simple tutorial with clear steps.
This is a tutorial on how to implement an incrementing or decrementing counting as forward or back buttons to retrieve values from an Array using Objective-C and display the values in a label on a View Controller in an IOS Storyboard.
This is a tutorial to demonstrate how to dismiss the contextual keyboard that displays when a user enters a UITextField. This tutorial demonstrates how to make the keyboard dismiss when a field loses focus, or when a button is press and how to make the keyboard dismiss using a Swipe Gesture...
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...
Select and display data from a SQLite database in iOS Cocoa Touch UITableView. Complete source code included.
SQLite is a great technology for data storage and persistence for mobile applications and web applications. Although not a database server, it offers nevertheless the possibility to group several databases together, for lack of a better explanation, and to allow for multi database queries like you...
Objective-C if examples. If expressions in Objective-C work the same as in C or any other language. This tutorial is a good mix between theory and complete code examples. It also show how to create objects and methods that can be used to evaluate Boolean expressions.
Objective-C instance variables and constant. In addition to the types, C variables and constants, Objective-C also adds instance variables. This tutorial offers a comprehensive review of how to use instance variables and constants in Objective-C and how to implement them in your own code.
Variables, constants and their types are some of the main building blocks in programming. This tutorial covers variables in C in regards to Objective-C. This is a second installment in a complete course on C and Objective-C
IOS 5 Core Data offers a simple development model for applications that require data persistence. This tutorial offers a developer new to IOS 5 how to create and use Core Data with their applications.
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.
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.
(c) klanguedoc 2010. iOS SQLite Database is a tutorial that demonstrates how to create an iOS iPhone and iPad applications with a SQLite database.
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.
This is a tutorial on using the SAP .Net Connector, NCO 188.8.131.52 for .Net 4 and Visual Studio
This is a reference of most of the free and or open source databases that can be used for mobile and web applications that require to be operated offline.
This a tutorial on creating Excel CustomUI controls for the RibbonX UI element.
Over 22 free and open source development frameworks and other software tools to create mobile apps for most major smartphone and tablet devices and platforms.
This tutorials demonstrates a very easy and effective method of manipulating data in a Adobe Flex DataGrid using XML and e4x in an ArrayCollection.
This is a how-to article to demonstrate the html5 api to access files on a computer through a browser.
Creating a servlet is very simple, once you know the mechanics. Just like a Java Servlet is just a bunch of methods to handle HTTPRequests and HTTPResponses so is the Generic Handler class in Microsoft (dot) Net which implements the IHTTPHandler...
Since getItemIndex doesn't return a match lookup value,instead always returns -1, this solution is a great workaround, even on long lists
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
Opendatasource provides the means to create adhoc connections. It uses a linked server object. You can access server locally or remotely. You can add the same kind of parameters as a linked server object including username and password. If you need...
Linking Excel with SQL Server with sp_addlinkedserver You can use the sp_addlinkedserver stored procedure to create the same Linked Server Object. Here is some sample code that you can use: CREATE PROCEDURE dbo.CreateXlsMusicLink AS BEGIN ...
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.
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.
Configure oledb (Microsoft.ACE.OLEDB.12.0) in SQL Server and use OPENROWSET to insert and select data in Excel 2007 and 2010
This tutorial demonstrates how to obtain the last day of any given month using Transact-SQL in SQL Server. It is a perfect solution for a function call.
T-SQL has many function data time functions that can be combined to calculate other missing date time functions like getting the last day of the week.
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)