Documentation Scanner
TweetFollow Us on Twitter

Documentation Scanner

Wednesday February 10

10:00
OS X El Capitan 10.11.4 beta 3 (15E39d) Now Available

OS X El Capitan 10.11.4 beta 3 (15E39d) Now Available

| Read more »
09:00
Empowering students with Genius Hour—Part 2:...

Today’s post is written by Tammy Brecht Dunbar, M.Ed., STEM and fifth-grade teacher in the Manteca Unified School District and Educational Technology at Teachers College of San Joaquin in Stockton, California.

This is part two of a three-part series taking an in-depth look at actual in-class lessons from “Liberating Genius,” Angela Maiers’ free e-book (in OneNote format). For more guidance, access my updated OneNote lesson plans, which include “Part 1: Accepting your genius” and “Part 2: Accelerating your genius,” here.

It’s been said that a person must hear something positive about themselves 17 times before they believe it. After implementing “Liberating Genius” (which...

| Read more »
05:00
Query SQL Data In A Range Using The BETWEEN Operator

Sometimes you’re looking for IDs, prices, zip codes and the like in a range. You can use the BETWEEN operator to select integers, text, or dates within a range of items. The syntax when using the BETWEEN operator would look similar to the following:

SELECT column(s)
FROM table
WHERE column_name BETWEEN value AND value;

In this article, we’ll use the same “Customers” table from our first articles:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange Minneapolis 55418 US

The following SQL statement selects all Sites with an ID BETWEEN 2 and 4:

SELECT * FROM Customers
WHERE ID BETWEEN 2 AND 4;

Or look for the ones that are not between those:

... | Read more »

Tuesday February 9

13:30
Download and Install the Renewed Intermediate...

Starting February 14, the renewed Apple Worldwide Developer Relations Intermediate certificate must be included when signing all new Apple Wallet Passes, push packages for Safari Push Notifications, and Safari Extensions. While most developers and users will not be affected by the certificate change, we recommend that all developers download and install the renewed certificate on their development systems and servers as a best practice. Learn more.

| Read more »
13:30
Download and Install the Renewed Intermediate...

Starting February 14, the renewed Apple Worldwide Developer Relations Intermediate certificate must be included when signing all new Apple Wallet Passes, push packages for Safari Push Notifications, and Safari Extensions. While most developers and users will not be affected by the certificate change, we recommend that all developers download and install the renewed certificate on their development systems and servers as a best practice. Learn more.

| Read more »
09:08
Deferred Channel build now available for the Office...

The first Office 365 Deferred Channel build (previously known as Current Branch for Business) is now available for Microsoft Office 365 for Windows (including Office 365 ProPlus, Office 365 Business, Project Pro for Office 365 and Visio Pro for Office 365). The Deferred Channel allows organizations to choose an update schedule that reduces the frequency of feature changes for the Windows desktop apps, enabling IT admins and developers to have more time between releases to validate Office against their line-of-business applications, add-ins and macros. For information on the updates available in the Deferred Channel build, visit the Office 365 Client Release Notes.

Starting today, you can download the Deferred Channel build directly from the Office CDN, and on Feb 23, 2016, the build will be available in the Office 365 User...

| Read more »
09:00
The Office Small Business Academy February webcast—”...

Are you paying yourself what you’re worth or just enough to get by? Be sure to watch the February episode of the Office Small Business Academy titled “Money Matters: How to Get It, Grow It and Keep It” on February 23 at 9 a.m. PT / noon ET. We will discuss all things money—from financing to tax preparation to cash flow management.

  • CNBC on-air contributor, Carol Roth, shares her financial tips for entrepreneurs, including how to build your financial team and the best ways to save for the future.
  • CPA and president of The Marks Group, Gene Marks, has advice on tax preparation, avoiding audits and boosting deductions.
  • Entrepreneur and author of “How to Get Unstuck,” Barry Moltz, explains how to maximize cash flow and offers help to sidestep costly mistakes.

Don’t miss this episode full of helpful advice...

| Read more »
05:00
Compound Searching Using The SQL WHERE Statement...

One of the most important aspects of searching for objects is to be able to define multiple values in a search. We looked at searching using text globbing. But the IN operator goes a step and allows you to search
The IN operator allows you to specify multiple values in a WHERE clause.

SELECT column
FROM table
WHERE column IN (value,value,...);

In this article, we’ll use the same “Customers” table from our first articles:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange Minneapolis 55418 US

The following outputs all customers with a Site of “Krypted” or “JAMF”:

SELECT * FROM Customers
WHERE Site IN ('Krypted','JAMF');

When looking to use the IN operator, note...

| Read more »
04:13
My MacADUK Slides from London

As promised, here’s the presentation I gave this morning at the MacAD UK Conference in London. It is incredibly well put together and all the presentations thus far have just been fantastic. Congrats to the entire team at Amsys and the speakers for such a great show!

MacADUK 2016 Presentation

| Read more »

Monday February 8

10:00
Xcode 7.3 beta 3 Now Available

Xcode 7.3 beta 3 Now Available

| Read more »
10:00
Xcode 7.3 beta 3 Now Available

Xcode 7.3 beta 3 Now Available

| Read more »
10:00
iOS 9.3 beta 3 Now Available

iOS 9.3 beta 3 Now Available

| Read more »
10:00
iOS 9.3 beta 3 Now Available

iOS 9.3 beta 3 Now Available

| Read more »
10:00
tvOS 9.2 beta 3 Now Available

tvOS 9.2 beta 3 Now Available

| Read more »
10:00
watchOS 2.2 beta 3 Now Available

watchOS 2.2 beta 3 Now Available

| Read more »
10:00
OS X El Capitan 10.11.4 beta 3 Now Available

OS X El Capitan 10.11.4 beta 3 Now Available

| Read more »
10:00
Apple Configurator 2.2 beta 3 Now Available

Apple Configurator 2.2 beta 3 Now Available

| Read more »
10:00
tvOS 9.2 beta 3 Now Available

tvOS 9.2 beta 3 Now Available

| Read more »
10:00
watchOS 2.2 beta 3 Now Available

watchOS 2.2 beta 3 Now Available

| Read more »
10:00
OS X El Capitan 10.11.4 beta 3 Now Available

OS X El Capitan 10.11.4 beta 3 Now Available

| Read more »
10:00
Apple Configurator 2.2 beta 3 Now Available

Apple Configurator 2.2 beta 3 Now Available

| Read more »
05:00
Moar About SQL Wildcards

Previously we looked at using wildcards in conjunction with the SQL LIKE operator. Wildcards allow you to search for data in a defined table. Think of them as text globbing for SQL. The wildcards available include the following:

  1. [list]: Define a ranges of characters for pattern matching
  2. [!charlist]: Matches only a character NOT specified within the brackets
  3. %: Require a single character/object in a pattern
  4. _: Allow any single character in a pattern

In this article, we’ll use the same “Customers” table from our first articles:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange Minneapolis 55410 US

... | Read more »

Sunday February 7

05:00
Hey Photos, stop opening when I plug in my devices…

When I plug my iPad in, Photos opens. I want it to stop opening when I plug it in. To make it stop, write a disableHotPlug key into com.apple.ImageCapture as true:

defaults -currentHost write com.apple.ImageCapture disableHotPlug -bool true

To enable Photos opening when you plug in a device again, just delete the disableHotPlug key:

defaults -currentHost delete com.apple.ImageCapture disableHotPlug

| Read more »

Saturday February 6

05:00
Remove Records From A MySQL Database

Sometimes you have data in a MySQL database that you just don’t need. You can delete tables and records pretty easily. In fact, it’s almost too easy. And there’s no undo. So be careful. And backup. And then backup again. And then snapshot again, before tinkerating with anything in this article.

In this article we’ll look at using the SQL DELETE statement to delete rows in a table. To do so, we’ll follow this basic syntax, which includes a WHERE clause to narrow the scope of the DELETE by specifying which records will be removed:

DELETE FROM table
WHERE column=value;

In this article, we’ll use the same “Customers” table from our first articles:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange...

| Read more »

Friday February 5

13:50
Stay secure with Advanced Threat Protection in...

Office 365 already provides robust email protection against spam, viruses and malware. But as hackers around the globe launch increasingly sophisticated attacks, many organizations are seeking tools that provide increased protection. Advanced Threat Protection (ATP) in Office 365 is your solution! ATP is an email filtering service that provides additional protection against advanced threats.

ATP provides you with:

  • Protection against unknown malware/viruses.
  • Real-time, time-of-click protection against malicious URLs.
  • Rich reporting and URL trace capabilities.

See the product in action by watching this video and learn how you can prevent hackers from attacking your organization.

Want to know the Forrester Total Economic Impact of Office 365 for Enterprise customers? Download the report...

| Read more »
13:25
Office 365 news roundup

Just as we’re focused on continuous innovation to expand and improve Office 365 capabilities, we’re also committed to making it easier for more people to benefit from our cloud productivity suite.

Just this week, we made it easier for small to midsized businesses (SMBs) to move to Office 365 and give their employees the ability to access team files from anywhere, collaborate in real-time from any device and get enterprise-grade security to help protect their information. Customers with 50 to 149 seats of Office 365 enterprise and small-business plans can now take advantage of our customer success service, Microsoft FastTrack, which provides resources and dedicated engineers to help them, or the...

| Read more »
10:30
CloudKit Now Supports Server-to-Server Web Service...

In addition to providing a web interface for users to access the same data as your app, you can now easily read and write to the CloudKit public database from a server-side process or script with a server-to-server key. Learn more about generating a server-to-server key and composing web service requests.

| Read more »
10:30
CloudKit Now Supports Server-to-Server Web Service...

In addition to providing a web interface for users to access the same data as your app, you can now easily read and write to the CloudKit public database from a server-side process or script with a server-to-server key. Learn more about generating a server-to-server key and composing web service requests.

| Read more »
09:47
About the security content of iOS 9

This document describes the security content of iOS 9.

| Read more »
09:45
About the security content of iOS 8.4.1

This document describes the security content of iOS 8.4.1.

| Read more »
09:32
About the security content of Safari 9

This document describes the security content of Safari 9.

| Read more »
06:00
A quick list of iOS Functionality Restrictions

There are a lot of payloads that MDM and profiles can manage in iOS. Restrictions are probably the one I get the most questions about. And most are pretty self-explanatory. Sooooo, rather than open Profile Manager every time I need to see the list, here it is:

  • Allow use of Camera
  • Allow FaceTime
  • Allow screenshots and screen recording
  • Allow AirDrop (supervised only)
  • Allow iMessage (supervised only)
  • Allow voice dialing while device is locked
  • Allow Siri
  • Allow Siri while device is locked
  • Enable Siri profanity filter (supervised only)
  • Allow user-generated content in Siri (supervised only)
  • Allow iBooks Store (supervised only)
  • Allow installing apps using Apple Configurator and iTunes
  • Allow installing apps using App Store (supervised only)
  • Allow automatic app downloads (supervised only)
  • Allow removing apps (supervised only)
  • Allow in-app purchase...
| Read more »

Thursday February 4

21:21
Virtual Strategy Magazine Article On Security...

The title of this one ended up a bit more FUDy than I’d prefer, but the content’s mostly what I provided.

With the rise of SMB-friendly backup solutions like CrashPlan, Carbonite, Mozy, and Backblaze, small businesses will choose to back up their systems with alternatives to expensive tape libraries, software to drive those libraries, and countless hours spent restoring files. As more cloud-based security attacks happen, businesses will realize that having a solid backup is one of the most important aspects to device security.

Read more: http://www.virtual-strategy.com/2016/02/03/executive-viewpoint-2016-prediction-bushel-major-security-breaches-will-change-how-small-?page=0,1#ixzz3zGet80fK

Oh, and in case anyone (Mosen/Dials) is bothered by the fact that I’m reblogging articles I do above and...

| Read more »
12:55
3 ways to drive business decisions using the new...

With the release of Office 2016, we unveiled a set of highly anticipated new charts to give you more ways to explore data and tell rich stories across Excel, Word and PowerPoint. The Waterfall, Histogram, Box & Whisker, Pareto, Treemap and Sunburst are six examples of powerful new charts that help you quickly visualize common financial, statistical and hierarchical data.

Below are just a few ways these new charts speed up your analysis and expand the ways you drive business decisions. We also share a sneak peek at the Funnel chart, coming soon to Office 365 subscribers.

Quickly visualize gains and losses

Most business owners seek to better understand their finances to ensure their success. However, understanding and communicating your gains, losses and balances by viewing financial statements can be challenging. With the Waterfall chart, you can quickly illustrate the line items...

| Read more »
05:00
Update Existing SQL Records Using the UPDATE...

Previously we looked at finding data in a SQL database and The UPDATE statement is used to update records in a table. You can also use the UPDATE statement to update existing records in a table. When using the SQL UPDATE statement, we’ll also use the WHERE clause, as we used previously to constrain output of a SELECT statement. The WHERE locates the record(s) to be updated with syntax as follows:

UPDATE table
SET column=value,column=value,...
WHERE column=value;

The WHERE clause indicates the record(s) to update. I’ve forgotten to put it in in the past and updated every record of a database. That’s bad (unless you mean to do it). So let’s run a SELECT on our sample database from earlier, so we can see the “Customers” table from our first article:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053...

| Read more »

Wednesday February 3

11:45
How to assess security, compliance and privacy...

In keeping with our commitment to provide customers the utmost transparency, we have released a detailed overview of how Office 365 controls map to the security, privacy, compliance and risk management controls defined in the Cloud Security Alliance Cloud Control Matrix (CSA CCM).

The Cloud Security Alliance (CSA) is a nonprofit organization led by a broad coalition of industry practitioners, associations, governments and corporate and individual members who are dedicated to defining and raising awareness of best practices that help ensure a secure cloud computing environment. The CSA CCM Security, Trust & Assurance Registry (STAR) is considered the gold standard while performing risk assessment and due diligence against cloud service providers. As part of our efforts to provide customers with in-depth insights into our security, compliance and privacy controls, we regularly publish self-assessments of...

| Read more »
09:00
Planner preview expanded to include more plans and...

A few months ago, we began rolling out the preview of Office 365 Planner to Office 365 First Release customers with enterprise plans. Today, we are making the Planner preview available to customers with Education and Nonprofit plans, as well as to Government tenants in the multi-tenant environment. (Planner preview is not currently available to customers on Government Community Cloud).

In addition, we are expanding the preview to tenants that are configured with the “Select people” option for First Release. Previously, the Office 365 Planner preview was only available for tenants that are configured with the “Entire organization” option for First Release. To verify how your organization is configured for First Release, your Office 365 admin can navigate to the Office 365 Admin Portal, expand Service Settings and select Updates...

| Read more »
09:00
Sway helps strategic music company Man Made Music...

Today’s post was written by Kristen Lueck, senior strategist for Culture and Innovation at Man Made Music, Inc.

Discovering and translating the “who, what, when, why and where” of culture—that’s a simple way to sum up my role at Man Made Music. Our company creates experiences, identities and sonic strategies for entertainment and brands, with offices and personnel across New York City, Los Angeles and the United Kingdom. You may have heard our audio logo work on brands such as AT&T, Southwest Airlines and the IMAX countdown before screenings. There’s no shortage of information on what’s moving and shaking across entertainment, fashion, design and technology, and I distill that knowledge down into shareable, useful and entertaining takeaways for our staff and clients. What differentiates us is not...

| Read more »
05:00
Add New Records To MySQL Databases With The INSERT...

Sometimes you need to write a record into a table in a SQL database. The INSERT INTO statement creates new records in a table and can work in one of two ways. The first form does not specify the column names where the data will be inserted, only their values. When doing so, each value needs to be inserted in the columned order they appear, here the table being the name of the table you’re adding a record into and each value would be replaced with the contents of your value (don’t insert the string ‘value’ into each!):

INSERT INTO table
VALUES (value,value,value,...);

If you don’t have every value to insert, you can also list the columns to insert data in and then include the values in the same order that the columns are listed in. The second form specifies both the column names and the values to insert:

INSERT INTO table (column,column,column,...)
VALUES (value,value,value,...);

Below is a selection from the “Customers” table that I put in...

| Read more »

Tuesday February 2

09:00
Get ready for Yammer!

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office team.

Today, I’m excited to announce that we are activating Yammer for every eligible Office 365 tenant—new and existing—without requiring additional action on the part of admins. This allows all Office 365 customers to gain the full benefits of Yammer. It also marks the culmination of our foundational efforts—including moving Yammer into Microsoft managed datacenters and undertaking identity work with Azure Active Directory—to bring Yammer fully into Office 365.

Seamless availability in Office 365

With this groundwork laid, we’re poised to provide a new set of high-value user and admin scenarios. Every Office 365 user with a Yammer license will be able to easily access Yammer from the Office 365 app launcher or start a Yammer conversation from SharePoint, Office 365 Video Portal and, coming soon, Delve and Skype Broadcast. This enables you and your coworkers to...

| Read more »
09:00
Microsoft Ignite 2016: Registration is open—sign up...

It’s time—register now for Microsoft Ignite and mark your calendar for September 26–30, 2016. Be there when top industry leaders talk about what’s next, get direct access to the people who built the products you use every day and surround yourself with smart people talking tech.

Sharpen your ideas with the best in the business

From high-level strategy to deep product insights, you’ll hear about new technologies and explore real-world solutions to today’s challenges. Customize your schedule to go deep on the topics that matter most to you and your organization, including cloud infrastructure and management, big data, analytics, productivity, communications, operating systems, mobile devices and more.

  • 1,000+ hours of content, 700+ sessions and a multitude of networking opportunities.
  • Insights and roadmaps from industry leaders.
  • Deep dives and live demos on the...
| Read more »
09:00
Join us for the “Driving Business Results with...

Join us for a virtual event series live from a Microsoft Technology Center covering sales and cloud productivity solutions.

We are thrilled to announce that in partnership with MTC studio our live events during the months of February and March will revolve around Driving Business Results with Intelligent Tools. Covering both Office and Dynamics solutions, this event proves to be exciting, as organizations can increase customer satisfaction by creating an intelligent workplace by utilizing intelligent tools.

With a great lineup of speakers, this eight-part MTC webcast series allows customers to see how innovations can help drive maximum impact across multiple...

| Read more »
09:00
Share your Excel insights with Power BI

The Excel and Power BI teams have been busy releasing capabilities and tools that allow you to share your Excel data and insights to Power BI more quickly and easily.

Here are a few new ways in which Excel and Power BI work better together:

Share your Excel insights with Power BI publisher for Excel

With Power BI publisher for Excel Preview—just announced two weeks ago—you can save snapshots of important PivotTables, charts, cell ranges and more from across all of your spreadsheets to a single location quickly. Select a range or an element in your workbook and, under the Power BI tab, click Pin.

...

| Read more »
05:00
Compound Searches With SQL Using AND && OR

Previously, we looked at the SQL SELECT and WHERE options to obtain output and then constrain what would be displayed in a query. The AND & OR operators are used to add additional logic so you can filter records based on more than one condition. Which is to say to search based on the contents of multiple columns within a single table. AND is used to show information if two different conditions are true and OR is used to show information if either condition is true.

Below is a selection from the “Customers” table that showed in our first article an we will use it to run some SQL sorting statements using the ORDER BY keyword:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange Minneapolis 55418 US

The...

| Read more »

Monday February 1

09:00
Collaborate in Office—Office tools to collaborate in...

Welcome to 2016! You may remember the release of Office 2016 and the new features it brought focused on collaboration. In the new year we will continue to plan, develop and release new features to help you collaborate—especially inside the classroom. Before these new features are released, let’s take some time to look at what’s already available to help you to collaborate in and out of the classroom!

OneNote Class Notebook—the ultimate collaboration tool

If you have not yet started using OneNote, you are missing out! OneNote can be used anywhere, on any device, with anyone and it’s free! OneNote Class Notebooks are described as an Office 365 wizard that allows teachers to quickly set up the ideal OneNote collaborative environment for the classroom, including public and private spaces.

Check out what some...

| Read more »
09:00
Office 365 Advanced eDiscovery now enables export to...

Companies must address the challenges of storing and organizing vast and exponentially increasing quantities of data so they can quickly be responsive to a litigation, investigation or regulatory eDiscovery requests. Complying with regulatory and legal requirements along the entire eDiscovery lifecycle is absolutely critical.

In early December, we released Office 365 Advanced eDiscovery, which integrates Equivio machine learning, predictive coding and text analytics capabilities to reduce the costs and challenges that come along with sorting through large quantities of data for eDiscovery purposes. These new capabilities further strengthen the rich set of eDiscovery in-place retention, preservation and search capabilities already present in Office 365—helping our customers quickly identify relevant data while decreasing cost and risk...

| Read more »
09:00
New offers make it easier for small and midsized...

We want to make it easier for small to midsized businesses (SMBs) to move to Office 365 and experience the ability for your employees to access team files from anywhere, collaborate in real-time from any device and get enterprise-grade security that works as hard for you as for the largest organizations.

Starting today, customers with 50 to 149 seats of Office 365 enterprise and small business plans can take advantage of our customer success service Microsoft FastTrack. Previously available only to customers with 150 seats or more, FastTrack provides resources and dedicated engineers who can assist you, or the Microsoft Partner you work with, to implement Office 365, onboard users and get the most business value from your investment....

| Read more »
09:00
How Lotus F1 Team built custom Office 365 integrated...

During the race season, roughly 100 crew members support Lotus F1 Team on site around the world. On today’s show, we learn from the team’s head of software development, Mark Everest, how Lotus F1 Team leveraged Office 365 APIs and extensibility to update their legacy travel application—complete with calendar and directory services integration.

The team built new underpinnings with a flexible data model in Azure, a web front end for logistics planning and user management, a mobile app that worked across mobile platforms and an Outlook add-in to integrate race events directly into users’ calendars. In the show, Mark describes how Visual Studio, Apache Cordova and integrated Office 365 APIs were used in the project. Keep watching to get a glimpse of how the team uses the apps to manage their itineraries.

This marks the fourth and final chapter in the series documenting Lotus F1 Team’s IT journey to Office 365. We’ll continue to track their progress as the team...

| Read more »
09:00
Students liberate teachers’ genius at TCEA with...

The four-day TCEA Education Conference in Austin, Texas, kicks off February 1, 2016, and we’re happy to share some exciting news about the OneNote team’s partnership with Angela Maiers and students from Connally Schools at this exciting EdTech event.

Students from Connally Schools and their fearless Serious Video Games leader, David Conover, will lead a Liberating Genius educator training with Angela Maiers on February 3 at TCEA. Together we’ll empower educators to incorporate Genius Hour into their class with “Liberating Genius: the First 20 Days,” by Angela Maiers. This eBook, published on Docs.com, is free to all educators and offered exclusively...

| Read more »
05:42
Constrain SQL Queries Using WHERE and LIKE

Previously, we covered the SQL SELECT Statement, to pull data from a SQL database. Here, we’ll constrain our search for items that match a given string, or pattern using the WHERE clause to filter search results, rather than getting all of the records and parsing the output.

The WHERE clause extracts records that fulfill a specified string and follows the general syntax as follows, replacing the word column with the name of the column in one of your tables and the word table with the name of a table that you’d like to search within:

SQL WHERE Syntax
SELECT column,column
FROM table
WHERE column operator value;

Below is a selection from the “Customers” table that showed in our first article an we will use it to run some SQL sorting statements using the ORDER BY keyword:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft...

| Read more »

Sunday January 31

06:00
Us the ORDER BY Keyword With Your SQL SELECT...

The ORDER BY keyword in a SQL SELECT statement is used to sort a given result-set based on the contents of one or more columns of data. By default, results are in ascending order, but you can use either ASC or DESC to indicate that you’d like results sorted in ascending or descending order, respectively.

Below is a selection from the “Customers” table that we will use to run some SQL sorting statements using the ORDER BY keyword:

ID Site Contact Address City Zip Country
1 Krypted Charles Edge my house Minneapolis 55418 US
2 Apple Tim Cook spaceship Cupertino 95014 US
3 Microsoft Satya Nadella campus Redmond 98053 US
4 Facebook Mark Zuckerberg foodhall Menlo Park 94025 US
5 JAMF Dean Hager Grain Exchange Minneapolis 55418 US

The syntax we’ll use for these commands is:

SELECT column_name, column_name
FROM table
ORDER BY column ASC|DESC, column ASC|DESC;

Here is a basic SQL statement that selects all of the...

| Read more »

Saturday January 30

19:39
The SQL SELECT Statement

Most tasks you will execute against a database are done with SQL statements. Think of statements as a query, an insert, a change, or a delete operating. For example, to see all of your data, you would select all of the records from a database using the SELECT statement. Then we’ll ask for all, or *, and tell the command to show us where the data is coming from, which is the Customers table. Finally, we’ll be nice and tidy and put a semi-colon at the end; although if you forget, you can always do so after you hit return:

SELECT * FROM Customers;

As can be seen above, the SELECT statement is used to select data from a database. Results are stored in a result table that is simply called the result-set. The syntax to run a select is to run SELECT followed by a list of columns separated by commas and then a FROM statement to indicate which table of a database you’ll query followed by the name of the table and then a semi-colon (;).

SELECT column name,column name...

| Read more »

Friday January 29

14:06
Put your Apple TV in sleep mode

Since there isn't a power button, you can't turn off your Apple TV. Instead, use Sleep mode.

| Read more »
10:45
Outlook for iOS and Android turns 1!

It has been an exciting journey for all of us on the Microsoft Outlook team since launching Outlook apps for iOS and Android exactly one year ago today. We’ve been humbled by the response from the more than 30 million people actively using our app and thrilled that Outlook remains one of the Top 10 Best Productivity Apps in the App Store with a 4+ star rating.

However, we’ve only scratched the surface of what’s possible. This past year laid the foundation for great new features and partnerships coming in 2016 to help you get more done on the go—even on the smallest screen.

As we celebrate our app’s first birthday, we want to take a look back at our favorite moments and feature releases from the past year.

Outlook for iOS and Android is born!

On January 29, 2015, Outlook for iOS and a preview of Outlook for Android are released to the App Store and Google Play. The Android app would leave preview soon thereafter. Since then, we’ve been busy shipping...

| Read more »
09:00
OneNote—what’s new in January 2016

When writing our New Year’s resolutions, we challenged ourselves to answer just one question: How do we make 2016 the best year yet for OneNote users? To that end, we’re thrilled to announce the number of features we’ve released in the past few weeks.

Insert shapes on Mac

Sick of circling things? Keeping chart axes straight have your mood slopin’ down? We’ve got your back. You can now add perfectly crisp lines, polygons and other geometric shapes from the Insert menu.

Search all OneDrive notebooks on Mac and iOS

We spiffed up Search over the holidays and added some new tricks! Now you can search all of your OneDrive notebooks—even if they’re not on your device. You can even search for things you’re currently reading.

...

| Read more »
07:00
Cushman & Wakefield chooses the Office 365 E5...

Today’s post was written by John Case, corporate vice president for Microsoft.

Last month, we announced several significant new capabilities in Office 365, including Skype for Business meetings and voice services, and new security and analytics capabilities, all of which are now available in the Office 365 E5 suite. We’ve since seen tremendous interest in these new services from customers of all sizes. And today, I’m thrilled to announce that global real estate services leader Cushman & Wakefield has signed up on Office 365 E5.

With 43,000 employees in 60 countries, Cushman & Wakefield will implement Office 365 as its comprehensive communications and collaboration solution.

CTO Robert Franch explains, “As our company grows, so does our investment in modern collaboration and security capabilities. With Office 365, we are delivering the office of the future to our employees, with cloud-based voice and conferencing that’s part of a complete...

| Read more »

Thursday January 28

15:35
Edit your photos using third-party extensions in...

With OS X El Capitan, you can install third-party photo editing extensions on your Mac and use them alongside the built-in tools in Photos.

| Read more »
11:00
Learn new insights from leaders in the business...

The Excel and Power BI teams are hosting a new conference designed specifically for you, the business analyst. The first of its kind, the Microsoft Data Insights Summit will be held on March 22–23, 2016 in Bellevue, Washington, and will feature talks from leaders in the Excel community and successful analysts. They will share their thoughts on trends in the industry, Excel and Power BI best practices and what it takes to succeed as an analyst in the modern workplace.

Hear from our featured speakers

Nate Silver, founder, FiveThirtyEight—Silver launched the field of data prediction into the public eye with his accurate analyses during the 2008 and 2012 elections. Today, he’s pioneering the new field of data journalism with his award-winning website,...

| Read more »
09:41
Skipping Network Setup in SetupAssistant

SetupAssistant.app has many fun hidden dot files in /var/db/ and Pepijn Bruienne (@bruienne) has found another good one: /var/db/.MBSkipWiFiSetupIfPossible This dot file will make SetupAssistant skip the WiFi setup portion of the setup in some cases. Only 10.11 and higher will respect this dot file.

For SetupAssistant to skip the WiFi setup /var/db/.MBSkipWiFiSetupIfPossible, some criteria have to be met. The first is that the /var/db/.MBSkipWiFiSetupIfPossible file must exist, this can be done by touching the file. The second is a WiFi network has to be added either as a profile, manually and then deleting the .AppleSetupDone file, or by networksetup in a post image/first boot script. The end result is to have a network in the preferred networks list before SetupAssistant runs. Third is that when the Mac is booted, the WiFi network must be within range and provide the Mac with a valid IP address.

Note: This will not work with 802.1X WiFi networks that have user level...

| Read more »
09:00
5 commonly overlooked security threats

The Internet is a vast place that brings amazing information to our fingertips in a matter of seconds. While this is a wonderful attribute, it also can be dangerous to your personal information or business’s data. That’s because there are hackers out there just itching to access your information and email is still a common way they accomplish this feat. And as we’ve seen through several recent examples—including the 2015 Pentagon and 2014 Sony email hacks—simply having a “strong” email password isn’t enough to keep your data from being compromised.

While some may jokingly (or not-so-jokingly) call for less...

| Read more »

Wednesday January 27

15:20
Lower Price Tiers Available for Canada and New...

Lower price tiers, Alternate Tier A and Alternate Tier B, now let you offer paid apps and In-App Purchases at $0.99 (CAD) and $0.99 (NZD). Existing apps that already use these price tiers have been automatically updated. Get details on App Store pricing in the Pricing and Availability section of My Apps on iTunes Connect.

| Read more »
15:20
Lower Price Tiers Available for Canada and New...

Lower price tiers, Alternate Tier A and Alternate Tier B, now let you offer paid apps and In-App Purchases at $0.99 (CAD) and $0.99 (NZD). Existing apps that already use these price tiers have been automatically updated. Get details on App Store pricing in the Pricing and Availability section of My Apps on iTunes Connect.

| Read more »
09:00
Teachers, invite your students to OneNote Class...

Teachers in over 105 countries have been using OneNote Class Notebooks to organize class content, save time and collaborate with students in the classroom.

Today, we are pleased to announce that teachers who do not have an Office 365 account can sign up for free and create OneNote Class Notebooks for their classes. In a few simple steps, teachers can now add students into their Class Notebook and quickly set up a personal workspace for every student, a content library for handouts and a collaboration space for lessons and creative activities—all within one powerful notebook. All you need is a school-assigned email for each student to get them into the Class Notebook and give them free access to Office 365. No IT support needed!

  1. Sign up for a free Office 365 account or sign in*—Head over to www.onenote.com/classnotebook...
| Read more »
09:00
New cloud storage options for Office mobile and...

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office team.

In February 2015, we announced the Cloud Storage Partner Program (CSPP) and enabled cloud storage providers to connect their services to Office Online and Office for iOS. Today, we’re making Office even easier for customers to use with cloud storage providers by adding real-time co-authoring with Office Online for documents stored in partner cloud services, extending our Office for iOS integration to all partners in the CSPP, and enabling integration between Outlook.com and cloud storage providers Dropbox and Box.

Real-time co-authoring with Office Online for docs stored in partner cloud services

Since...

| Read more »

Tuesday January 26

11:10
Free college prep planning resources and virtual...

In partnership with TeenLife, the largest content and listing site for experiential learning opportunities, the OneNote team is offering students the opportunity to expand their world and discover amazing experiences outside of the high-school classroom at a live online fair on January 31, 2016. This event includes 12 speakers and 30+ exhibitors focused on college prep, STEM, summer and gap-year experiences, community service and more! To learn about the speakers and exhibitors and to access incredible online resources built in OneNote and Sway on Docs.com for college prep planning, check out Docs.com/TeenLife-Media.

TeenLife is also giving away one Microsoft Surface tablet to a TeenLife LIVE attendee who downloads...

| Read more »
10:00
Working. Evolved.

Today’s post was written by Thom Gruhler, corporate vice president at Microsoft.

The way we work has evolved. Dynamic teams that span time zones are no longer the exception; collaboration is how work gets done and people expect to be able to access their work from any device. In addition, co-working spaces like WeWork are positioned at the center of this change and offer a new generation of workers an exciting alternative for the traditional physical workspace.

It’s with this in mind that I’m pleased to announce we’ve joined forces with our friends at WeWork to launch a special offer for Office 365. Launching in February and running through June of this year, WeWork members around the world can get 25 percent off an Office 365 Business or Business Premium subscription, giving them access to the tools and technology that empower them to achieve their goals. In fact, check out this video to learn how Dash,...

| Read more »
04:00
20 Lessons About Business I Learned From Dungeons...

I started playing Dungeons and Dragons in about the 5th or 6th grade. I didn’t get good at it for awhile. And once I got good at it, I didn’t play much longer (insert reference to “The Best Days of My Life” here). Along the way, I learned a few lessons that until I got older, I didn’t realize were great life lessons. I also learned a lot that helped me later in life in the business world. Here’s a few you may or may not agree with (and yes, the image is of a box sitting on my table at home:).

  1. Build a great campaign and then if the game is good, expect your players to totally break it. In business, you create a situation where customers give you money. You build processes, procedures, marketable packages, and teams. These prepare you for the massive onslaught of all the moneys that are going to come in. You need to be able to build a product,...
| Read more »

Monday January 25

22:08
Your First SQL Statement

Databases and Tables

A SQL database is an organized collection of data. Or at least that’s what they taught me in college. In real life, it’s only as organized as the people putting data into the database. Databases contain schemas, tables, stored procedures, reports, views and other objects. Most databases will contain multiple tables. Tables contain rows that have data in them. I like to think of a database kinda’ like an Excel spreadsheet. Each tab on a spreadsheet is similar to a table; each row is similar to a row in a database and each column in the spreadsheet is somewhat similar to a column, or attribute. The headers are kinda’ like the schema.

These are overly simplistic explanations. And whenever you oversimplify something, you run the risk of miscommunication, but it helps as a starting place. This page is meant to be a short and easy guide to get started writing SQL queries. More links will appear throughout the page that point to other posts on my site,...

| Read more »
15:00
Xcode 7.3 beta 2 Now Available

Xcode 7.3 beta 2 Now Available

| Read more »
15:00
Xcode 7.3 beta 2 Now Available

Xcode 7.3 beta 2 Now Available

| Read more »
13:00
Apple Configurator 2.2 beta 2 Now Available

Apple Configurator 2.2 beta 2 Now Available

| Read more »
12:00
iOS 9.3 beta 2 Now Available

iOS 9.3 beta 2 Now Available

| Read more »
12:00
iOS 9.3 beta 2 Now Available

iOS 9.3 beta 2 Now Available

| Read more »
12:00
tvOS 9.2 beta 2 Now Available

tvOS 9.2 beta 2 Now Available

| Read more »
12:00
tvOS 9.2 beta 2 Now Available

tvOS 9.2 beta 2 Now Available

| Read more »
12:00
watchOS 2.2 beta 2 Now Available

watchOS 2.2 beta 2 Now Available

| Read more »
12:00
watchOS 2.2 beta 2 Now Available

watchOS 2.2 beta 2 Now Available

| Read more »
12:00
OS X El Capitan 10.11.4 beta 2 Now Available

OS X El Capitan 10.11.4 beta 2 Now Available

| Read more »
12:00
OS X El Capitan 10.11.4 beta 2 Now Available

OS X El Capitan 10.11.4 beta 2 Now Available

| Read more »
12:00
Apple Configurator 2.2 beta 2 Now Available

Apple Configurator 2.2 beta 2 Now Available

| Read more »

Friday January 22

12:00
Carillion builds engaging communities to improve...

Today’s post was written by Lisa Benbow, director of corporate communications for Carillion.

Carillion knows a thing or two about creating communities. Our mission is to make tomorrow a better place for our customers and the communities where we live and work. We are proud to be entrusted with building hospitals, schools, libraries, roads and railways, and with rolling out high speed broadband. We also provide essential services such as cleaning, catering, repair and maintenance that help to make a difference every day for people in all walks of life.

At the heart of all of this are 46,000 Carillion people. Located across the United Kingdom, Canada and the Middle East, our employees work really hard to do a great job for our customers and to bring our values to life on a daily basis. Many of them work remotely at customers’ operations or construction sites...

| Read more »
09:00
Sway Recycle Bin, full screen mode in Windows, Send...

Happy New Year from the Sway team! It’s now been a few months since Sway became generally available. Last month we introduced new controls that allow Office 365 business and education admins to better manage and tailor the way Sway is used within their organization. This month we’re ushering in 2016 with new Sway capabilities we recently added to enhance your experience and increase the ways you can use Sway to create polished, interactive content.

Sway now has a Recycle Bin

We added a Recycle Bin to Sway—a common customer request. Now, any Sway you delete using Sway on the web, Sway for Windows 10...

| Read more »

Thursday January 21

13:00
Cloud PBX with Skype for Business—simplify...

With Skype for Business Cloud PBX (Private Branch Exchange), users can globally manage calls right within Office 365 and eliminate separate PBX systems for information workers. This provides users with access everywhere, so they can make, receive and transfer calls from mobiles, tablets and PCs from nearly anywhere with Internet access. It also provides consolidated management, so the Office 365 administration portal is the central location to manage users for communications, email and content.

See the product in action by watching the following video:

Want to get insights around how and why enterprises are adopting cloud-based telephony, unified communications and contact center apps? Download and read the Market Demand for Cloud-based Services whitepaper.

The post...

| Read more »
09:00
Office 365—monthly Dev Digest for January

This month’s Office 365 Dev Digest was written by Jeremy Thake, technical product manager for the Office 365 Dev team.

Welcome to the 11th edition of Dev Digest, designed to help you—the Office 365 developer—keep up to date with what’s new in Office 365 development.

As we roll into 2016 and head towards our next major announcement at Build in March, there have been some great additions, by our internal efforts and community efforts.

Add-in commands have been available in Outlook since we announced them in early 2015, and now Word, Excel and PowerPoint have these available as a developer preview. You can find out more about them on the github repository and by listening to episode 77 of the Office 365 Developer Podcast with Humberto.

In...

| Read more »
09:00
New to Office 365 in January—new inking tools,...

Today’s post was written by Kirk Koenigsbauer, corporate vice president for the Office team.

We’re starting off the New Year with new ways to work with Office! We’re improving the inking experience so writing and drawing with your finger, pen or stylus are more intuitive and powerful. We’re bringing PowerPoint Designer and Morph, available last month in Windows, to additional platforms. Also, Office 365 consumer subscribers with Macs can now get Office Insider builds for first access to new features.

Office works the way you do with new inking capabilities

As part of our effort to make Office even more intuitive and easier to use, we want to make pen and ink a primary input across Office apps.­ While digital inking tools have been available in Office on Windows PCs since 2007, today we are releasing new inking tools in Office...

| Read more »

Wednesday January 20

14:10
Take your teamwork to the next level anywhere,...

Join us for a Microsoft Immersion Experience session from the comfort of your own office. An immersion experience is a facilitated, hands-on session to “experience the possible” by test-driving Microsoft solutions through simulated everyday business scenarios.

We send you a link to connect your own device to a remote desktop loaded with our latest and greatest technology so you can experience first-hand how Microsoft tools can solve your biggest challenges. These interactive, hands-on, 90-minute sessions are guided by a skilled facilitator and customized to your interests.

Each session is only open to 20 participants—so reserve your seat now. Sessions fill quickly. If you would like to receive advanced notification of upcoming sessions, please email cieon@microsoft.com.

Interactive online sessions help you discover and explore

  • Keep information secure while being productive—Make it easier...
| Read more »
13:27
6 Ways To Cloud Nirvana Article On IT Business Edge

I have another article up on the world webs. This one is on cloud use in small businesses, with IT Business Edge. Check it out at http://www.itbusinessedge.com/slideshows/6-ways-small-businesses-can-master-the-cloud-in-2016-08.html.

| Read more »
09:00
SharePoint Server 2016 and Project Server 2016...

Building on our announcement of SharePoint Server 2016 Beta 2 in November, we’re pleased to announce the availability of SharePoint Server 2016 Release Candidate (RC). SharePoint Server 2016 RC is mostly feature complete and represents an important milestone for customers and partners looking to deploy and evaluate SharePoint Server 2016 before general availability in Spring 2016.

Over 5,000 customers have downloaded the SharePoint Server 2016 previews to date, which, through customer feedback, has resulted in a high-quality Release Candidate.

SharePoint Server 2016 is our most reliable, scalable, secure and high-performant server release ever. With built-in Hybrid Cloud capabilities, it is the premier choice for organizations who are looking to take advantage of the latest innovations in Microsoft Cloud offerings while also...

| Read more »
07:44
Set up CarPlay to use with your iPhone

With select cars and stereos, you can use CarPlay to get directions, make calls, send and receive messages, and more.

| Read more »

Tuesday January 19

10:28
About the security content of OS X El Capitan 10.11....

This document describes the security content of OS X El Capitan 10.11.3 and Security Update 2016-001.

| Read more »
09:00
From Inside the Cloud—What protection exists for...

It’s the New Year and one of the things that I hope gives you increased peace of mind in 2016 are the continued investments that we are making to protect your information within the Office 365 service, as I explain on our latest episode of “From Inside the Cloud.”

To put this into context, Office 365 has one of the largest data sets in the world. As people author and share files, send email and collaborate on their day-to-day tasks, terabytes and terabytes of enterprise data flows through the service at any given time.

We focus on protecting your data everywhere it is authored and shared, without disrupting your ability to get work done. This is a very real and vital engineering goal and requires an approach that balances both information security and end user needs. It starts with harnessing the intelligence of the service itself and providing the controls to tailor protection to your specific organization requirements.

In previous episodes of “From Inside...

| Read more »
09:00
Embed video throughout your intranet

A video message that is easy to find and easy to view will be more successful than one buried in the depths of one, two, three clicks away. When you put a company message from the CxO or a status update from a project leader—front and center where employees and team members are—the information and insights will be better targeted, more fully understood and ultimately shared within the right context.

“The capabilities of Office 365 Video represent a tremendous productivity value: it’s not intrusive, and it’s reliable.
It’s a great way to reach large audiences and targeted audiences alike.”

—Jacob Skaggs, SharePoint developer at PulteGroup. Read their full case study.

Within Office 365, it is possible to place videos (embed) in-line and in-context where people work on projects, online and on-premises. You can do this within SharePoint Team Sites,...

| Read more »
03:00
Learning Tools for OneNote improves learning for all

“Students spend so much energy decoding that they can’t focus on content. This tool will help making learning more efficient.”
—Joel Reese, educator at Sammamish High School

“If my imagination designed technology, this would be in my wildest dream.”
—Haley Heck, educator at Sammamish High School

Today’s classrooms include students with a wide range of abilities. Educators are expected to adapt content to meet the needs of each of their students, including students with learning differences. While technology can be an enabler to learning, for some, technology is a challenge. Many educators lose valuable instructional time discovering, justifying, deploying and maintaining assistive technology for students with learning differences. To help address these challenges, we’re introducing Learning Tools for OneNote....

| Read more »

Monday January 18

17:46
My 16 Mac Security Advances Article On TechCrunch

Ever since the kids from Silicon Valley went to TechCrunch, I’ve been thinking that at some point I’d want to put a piece there. Luckily, I recently got the chance. Today, 16 Apple Security Advances To Take Note Of In 2016 went up on TechCrunch. You can access the article here.

The original article actually listed the year that each was introduced in order. It was a lot of work to go back in time and piece the timeline together, so since the years didn’t make it through editorial, I list them here (not that anyone actually cares):

  • 2002: Managed Preferences
  • 2003: FileVault
  • 2004: Require all software installers that need system resources to prompt for a password
  • 2005: Restrict setuid and setgid in scripts...
| Read more »

Friday January 15

17:11
IT Administrator’s Guide For OS X Now Available On...

It can be tough to get information about larger Mac deployments. I’ve written a few books on it. Apple has built some pages on it. But many prefer to consume their content through video. As such, Sean Collins has teamed up with Lynda.com to put together an IT Administrator’s Guide for El Capitan. With topics ranging from SIP to DEP, and all the acronyms in the middle, Sean’s soothing voice will guide you through what you need to get started with a new Mac deployment.

Many a job can seem daunting, but with this latest addition to our arsenal, you’ll instantly feel less intimidated. It’s like the Sun A of the Mac world. But afterwards, when you go into corpse pose, you won’t fall asleep, because the content is too good. Check it out here:

...

| Read more »
14:00
iAd App Network will be Discontinued

The iAd App Network will be discontinued as of June 30, 2016. Although we are no longer accepting new apps into the network, advertising campaigns may continue to run and you can still earn advertising revenue until June 30. If you’d like to continue promoting your apps through iAd until then, you can create a campaign using iAd Workbench. We will continue to keep you updated, but if you have any questions, contact us.

| Read more »
14:00
iAd App Network will be Discontinued

The iAd App Network will be discontinued as of June 30, 2016. Although we are no longer accepting new apps into the network, advertising campaigns may continue to run and you can still earn advertising revenue until June 30. If you’d like to continue promoting your apps through iAd until then, you can create a campaign using iAd Workbench. We will continue to keep you updated, but if you have any questions, contact us.

| Read more »
 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Ys Chronicles II (Games)
Ys Chronicles II 1.0.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0.0 (iTunes) Description: After a hard fight to recover the six sacred books in Ys Chronicles I, Adol is back for a sequel! | Read more »
FINAL FANTASY Ⅸ (Games)
FINAL FANTASY Ⅸ 1.0.4 Device: iOS Universal Category: Games Price: $16.99, Version: 1.0.4 (iTunes) Description: ==========●Special sale price for the FINAL FANTASY IX release! ●20% off from February 10 to February 21, 2016... | Read more »
Tennis Club Story (Games)
Tennis Club Story 1.03 Device: iOS Universal Category: Games Price: $4.99, Version: 1.03 (iTunes) Description: Aim for the ace position of tennis club prestige in this simulation! Your leadership decides if players make it to the big... | Read more »
Juggernaut Wars guide - How to use skill...
Juggernaut Warsis a brand new auto-RPG on iOS and Android that challenges you to build a team of heroes, send them out into various different missions to defeat waves of heroes, and level them up to increase their power. The actual combat itself... | Read more »
Check out the new Pirate Attack update i...
Love pirates and board games? Well, you'll love the new Pirate Attack themed update that just launched in Game of Dice. It adds a bunch of new content themed around pirates, like an all new event map based on a pirate ship which revamps the toll... | Read more »
Splash Cars guide - How to paint the tow...
Splash Cars is an arcade driving game that feels like a hybrid between Dawn of the Plow and Splatoon. In it, you'll need to drive a car around to repaint areas of a town that have lost all of their color. Check out these tips to help you perform... | Read more »
The best video player on mobile
We all know the stock video player on iOS is not particularly convenient, primarily because it asks us to hook a device up to iTunes to sync video in a world that has things like Netflix. [Read more] | Read more »
Four apps to help improve your Super Bow...
Super Bowl Sunday is upon us, and whether you’re a Panthers or a Broncos fan you’re no doubt gearing up for it. [Read more] | Read more »
LooperSonic (Music)
LooperSonic 1.0 Device: iOS Universal Category: Music Price: $4.99, Version: 1.0 (iTunes) Description: LooperSonic is a multi-track audio looper and recorder that will take your loops to the next level. Use it like a loop pedal to... | Read more »
Space Grunts guide - How to survive
Space Grunts is a fast-paced roguelike from popular iOS developer, Orange Pixel. While it taps into many of the typical roguelike sensibilities, you might still find yourself caught out by a few things. We delved further to find you some helpful... | Read more »

Price Scanner via MacPrices.net

What iPad Pro Still Needs To Make It Truly Pr...
I love my iPad Air 2. So much that I’m grudgingly willing to put up with its compromises and limitations as a production tool in order to take advantage of its virtues. However, since a computer for... Read more
21-inch 3.1GHz 4K on sale for $1399, $100 off...
B&H Photo has the 21″ 3.1GHz 4K iMac on sale $1399 for a limited time. Shipping is free, and B&H charges NY sales tax only. Their price is $100 off MSRP: - 21″ 3.1GHz 4K iMac (MK452LL/A): $... Read more
Apple price trackers, updated continuously
Scan our Apple Price Trackers for the latest information on sales, bundles, and availability on systems from Apple’s authorized internet/catalog resellers. We update the trackers continuously: - 15″... Read more
Save up to $240 with Apple Certified Refurbis...
Apple is now offering Certified Refurbished 12″ Retina MacBooks for up to $240 off the cost of new models. Apple will include a standard one-year warranty with each MacBook, and shipping is free. The... Read more
Apple refurbished 13-inch Retina MacBook Pros...
Apple has Certified Refurbished 13″ Retina MacBook Pros available for up to $270 off the cost of new models. An Apple one-year warranty is included with each model, and shipping is free: - 13″ 2.7GHz... Read more
Apple refurbished Time Capsules available for...
Apple has certified refurbished Time Capsules available for $120 off MSRP. Apple’s one-year warranty is included with each Time Capsule, and shipping is free: - 2TB Time Capsule: $179, $120 off - 3TB... Read more
13-inch 2.5GHz MacBook Pro (refurbished) avai...
Apple has Certified Refurbished 13″ 2.5GHz MacBook Pros available for $829, or $270 off the cost of new models. Apple’s one-year warranty is standard, and shipping is free: - 13″ 2.5GHz MacBook Pros... Read more
Apple refurbished 15-inch Retina MacBook Pros...
Apple has Certified Refurbished 2015 15″ Retina MacBook Pros available for up to $380 off the cost of new models. An Apple one-year warranty is included with each model, and shipping is free: - 15″ 2... Read more
New Liquid Crystal Technology Prevents Automo...
Researchers at the University of Central Florida have developed three new liquid crystal mixtures which will allow automobile displays to operate at unprecedented high and low temperatures In... Read more
BookBook For iPad Pro Coming Soon
The iPad Pro is a device unlike any other, and with Apple Pencil, it’s the ideal portable sketchpad: all that’s missing is the modern easel and portfolio to go. TwelveSouth’s BookBook for iPad Pro... Read more

Jobs Board

Lead Engineer - *Apple* OSX & Hardware...
Lead Engineer - Apple OSX & Hardware **Job ID:** 3125919 **Full/Part\-Time:** Full\-time **Regular/Temporary:** Regular **Listed:** 2016\-02\-10 **Location:** Cary, Read more
*Apple* System Analyst - ATOS IT Services...
Apple System AnalystReference no.198783CountryUSARegionUS - CALIFORNIACityUS - CALIFORNIA - BURBANKPosition TypeProfessionalJob AreaIT SupportJob TypeFull Read more
*Apple* Retail - Multiple Positions (US) - A...
Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, you're also the Read more
*Apple* Retail - Multiple Positions (US) - A...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
*Apple* Subject Matter Expert - Experis (Uni...
This position is for an Apple Subject Matter Expert to assist in developing the architecture, support and services for integration of Apple devices into the domain. Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.