• iPhone

    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…

  • Articles and Books,  Bushel

    Virtual Strategy Magazine Article On Security Breaches And Their Impact On Small Businesses

    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 beyond what I do on…

  • SQL

    Update Existing SQL Records Using the UPDATE Statement

    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…

  • SQL

    Add New Records To MySQL Databases With The INSERT Statement

    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…

  • SQL

    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…

  • SQL

    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…

  • SQL

    Us the ORDER BY Keyword With Your SQL SELECT Statements

    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…

  • SQL

    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…

  • Business

    20 Lessons About Business I Learned From Dungeons & Dragons

    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:). Build a great campaign and then if the…

  • SQL

    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…