1000 characters left
Don't like using forms? Call us at (630) 692-6700
image
Big Data Consulting
image
Business Intelligence Consulting
image
Partner With Aptude
image
Mobile Development Experts
image
Oracle Fusion Consulting
image
IT Support On-Demand

Aptude's Blog - IT Staffing, Consulting, and Software Development Services

Welcome to Aptude's blogging center! Our blogs are written by experts in each respective field. We hope any information gathered in these articles will be beneficial to you and your company. For more information about how we can assist you with your IT Staffing, IT Consulting, or Software Development needs please give us a call at (630) 692-6700!

Reasons to Migrate to Microsoft SQL Server 2016

Reasons to Migrate to Microsoft SQL Server 2016
As of June of this year, Microsoft SQL Server 2016 – Microsoft’s database management software – has been unleashed for commercial use. There are many new features that enterprises will benefit from that its predecessor didn’t offer or lacked. This beefed up suite of features will have new users grinning from ear to ear. Here is why your organization needs to make the switch to the new and improved SQL Server. Home is where your data is... SQL Server 2016 is blowing the roof off of data access and how fast data analysis is performed. Why? Updating machine learning models, deploying new models, and monitoring performance can be done in the database without redeploying applications. R Services (In-database) allows users to to use the R language and packages to create models and generate predictions using your SQL Server data. R Services (In-database) integrates the R language with the SQL Server which...
Continue reading
780 Hits

Latest Announcements From Microsoft - Free SQL Server Offer & Linux Support

Latest Announcements From Microsoft - Free SQL Server Offer & Linux Support
Microsoft is going after Oracle’s Database market and there are signs that it’s hungrier for more! When I read the news last week from Bloomberg (Microsoft offers-free database software-to lure oracle customers) that Microsoft was offering free licensing for organizations that are willing to move from Oracle it didn’t really surprise me.  Microsoft SQL Server’s Total Cost of ownership is already considerably less than Oracle’s so why not push the envelope and use that all empowering word that has lured many of open-source disciples for the past two decades (Free). Their “free” offer is good through June 30, 2016.  Of course it isn’t exactly free, since there are hardware costs as well as a support agreement they’re calling Software Assurance.   I do like the idea that Microsoft is really committing to help companies make the switch by offering engineers (services) to assist in the migration transition.   With Oracle owning substantial...
Continue reading
825 Hits
0 Comments

SSIS: Calling a Webservice by Using the Webservice Task

SSIS: Calling a Webservice by Using the Webservice Task
I have been exploring the various tasks available in SSIS and thought I would put together a tutorial on the Web Service Task. Database developers and administrators use the business intelligence tool SQL Server Integration Services (SSIS) to perform Extract, Transform & Load (ETL) operations. In this post, I’m examining the use of the Web Service and XML Tasks available in SQL Server 2005 and later versions.     Overview of the Web Service TaskThe Web Service Task is a new task introduced in SQL Server 2005 Integration Services. It enables you to connect to a web service and execute any one of the available web methods which are exposed by the Web Service. Once the web method is executed the currency will be converted with the help of XML task and the converted currency is stored in the separate column by using the Derived column. The final Package that I...
Continue reading
22418 Hits
0 Comments

SQL Server 2012 Installation Steps

SQL Server 2012 Installation Steps
In this post, I'm going to take you through the steps of installing SQL Server 2012.   Let's get started!     Click the “SQLFULL_x86_ENU” folder and double click “SETUP” application.   Checking system requirements for installation. When you see “SQL Server Installation Center” screen, it means that your system configuration is perfect for installation. Click installation from the left pane and select “New SQL Server stand-alone installation or add features to an existing installation”. In the “Setup Support Rules” Click "OK" button when you have failed 0. Otherwise fix the issue and click "Re-run" button. Wait for 1 to 2 minutes. Setup files installation Press "Install" button. Press "Next" button. Here, we can perform new installation or we can add features to existing instance of Sql Server. The default edition is “Evaluation”, but you can also choose “Express” edition from the drop down list. (Leave the product key as of...
Continue reading
2799 Hits
0 Comments

New Functions in SQL SERVER 2012

New Functions in SQL SERVER 2012
This post provides the details of the new SQL Functions which were introduced in Microsoft SQL Server 2012. I have provided a list of the new functions as well as the details on where to use the new functions, with some examples. Conversion functions PARSE TRY_CONVERT TRY_PARSE Date and time functions DATEFROMPARTS DATETIME2FROMPARTS DATETIMEFROMPARTS DATETIMEOFFSETFROMPARTS EOMONTH SMALLDATETIMEFROMPARTS TIMEFROMPARTS Logical functions CHOOSE IIF String functions CONCAT FORMAT   1. PARSE() function can convert any string value to Numeric or Date/Time format. PARSE() function relies on Common Language Runtime (CLR) to convert the string value.             Converting String to INTSELECT PARSE('99.00' AS INT) Result: 99   Converting String to Date/TimeSELECT PARSE('January 30, 2013' AS DATETIME)Result is: 2013-01-30 00:00:00.000.   Note: PARSE only works for String Values to be converted to Numeric and Date/Time.    2. TRY_PARSE() function can convert any string value to Numeric or Date/Time format. Converting String to INTSELECT TRY_PARSE('99.00' AS INT)Result is: 99 Converting String to Date/TimeSELECT TRY_PARSE ('January 30, 2013' AS DATETIME)Result...
Tags:
Continue reading
1914 Hits
0 Comments

Using ROLLUP to Get Subtotal and Grand Total in the Same Output in SQL Server 2008

Using ROLLUP to Get Subtotal and Grand Total in the Same Output in SQL Server 2008
  In this post, I'll show you how to get the grand total and subtotal in the same output from a table using ROLLUP, and avoid the  use of UNION, Temp tables, or CTE. The ROLLUP clause in SQL Server 2008 is used to do aggregate operations on multiple levels in hierarchy. Recently I came across a requirement where I needed to show the total of the Cost of Orders as well as each individual Order cost.       Below is a table called OrderDetails with the respective columns and values: OrderName CostOf Order OR_01 2000 OR_02 4000 OR_03 1000 OR_04 3000   My requirement was to show the information like this: OrderName CostOf Order OR_01 2000 OR_02 4000 OR_03 1000 OR_04 3000 Total 10000   We often use the Union to get one more row to show the total of the Cost, as shown in the below SQL statement:...
Tags:
Continue reading
20721 Hits
0 Comments

Log Shipping in SQL Server 2008

Log Shipping in SQL Server 2008
  In this post, I'll take you through the steps of Log shipping in SQL Server 2008. Log shipping involves copying a database backup and subsequent transaction log backups from the primary server and restoring the database and transaction log backups on one or more secondary servers. The Target Database is in a standby or no-recovery mode on the secondary server(s), allowing subsequent transaction logs to be backed up on the primary and shipped to the secondary servers and then applied (restored) there.      1. Right click the Primary Server and Select Properties.  2. Select the Transaction Log Shipping Page. Check the "Enable this as primary database in a log shipping configuration" check box. To configure and schedule a transaction log backup, click on Backup Settings.  3. To create backups on a network share, enter the network path or for the local machine you can specify the local folder path.  We can control the backup compression behavior of...
Continue reading
4437 Hits
0 Comments

SSIS How-to: Read Multiple Excel Files and Move to Destination Folder

SSIS How-to: Read Multiple Excel Files and Move to Destination Folder
In this Microsoft SQL Server How-to, I'll take you through the steps involved in reading multiple Excel files and moving them to a destination folder through the SSIS package. In general functional requirements, we come across reading multiple Microsoft Excel files on a stretch from a source folder and moving them to a destination folder. But, developers often face problems in achieving the requirements or making it too technically complex to understand. In that case, the process of reading multiple “.txt” and “.csv” files is far easier than reading Excel files.   The SSIS package has given us two components that ease the process of reading multiple Excel files from a folder. They are: 1. Excel Source 2. Excel Source Connection Manager What exactly are these? Excel Source is a SSIS component responsible for reading Excel files from a given source folder. Excel Source Connection Manager is a SSIS component responsible providing the...
Continue reading
8919 Hits
0 Comments

What our clients are saying

  • build

    Aptude provided Build.com a Java, MySQL, Webservices and other UI based solution in the business domain of analyzing and reporting on user activities for our ecommerce website. Utilizing Omniture’s APIs to download, parse, and regenerate and upload back so that we could be more effective in our marketing. I was satisfied with their project work and delivery and would consider utilizing them for future projects.” – Dan D., Build.com

  • 1
  • 2
  • 3
  • 4

Featured Clients

  • 1
  • 2
  • 3
  • 4

Newsletter

Subscribe to our newsletter and stay updated on the latest developments and special offers!

Contact Us

Phone Number
Headquarters
1601 North Bond Street, Suite 316
Naperville, IL 60563
Atlanta Office
3355 Lenox Road Suite 750s
Atlanta, GA 30326