120 In-Depth SQLite Questions for Professionals

What is involved in SQLite

Find out what the related areas are that SQLite connects with, associates with, correlates with or affects, and which require thought, deliberation, analysis, review and discussion. This unique checklist stands out in a sense that it is not per-se designed to give answers, but to engage the reader and lay out a SQLite thinking-frame.

How far is your company on its SQLite journey?

Take this short survey to gauge your organization’s progress toward SQLite leadership. Learn your strongest and weakest areas, and what you can do now to create a strategy that delivers results.

To address the criteria in this checklist for your organization, extensive selected resources are provided for sources of further research and information.

Start the Checklist

Below you will find a quick checklist designed to help you think about which SQLite related domains to cover and 120 essential critical questions to check off in that domain.

The following domains are covered:

SQLite, Guided missile destroyer, Language binding, Computer process, Visual Basic .NET, Internationalization and localization, Comparison of relational database management systems, Component Pascal, Write-ahead logging, Embedded system, Common table expressions, Berkeley DB, Application software, Adobe AIR, Web SQL Database, Data type, Keir Thomas, SQL data types, Core Data, HTML Application, Symbian OS, Document-oriented database, Software release life cycle, IBM Informix, RFO BASIC!, Relational database management system, Web browser, Component Object Model, File system permissions, Public domain, Error code, Mozilla Firefox, Windows 10, Database trigger, Solaris 10, Regression testing, Operating system, Database engine, Proprietary software, Software categories, Free Pascal, SQL Server Compact, File size:

SQLite Critical Criteria:

Track SQLite goals and track iterative SQLite results.

– How will we insure seamless interoperability of SQLite moving forward?

– What business benefits will SQLite goals deliver if achieved?

– What are the business goals SQLite is aiming to achieve?

Guided missile destroyer Critical Criteria:

Concentrate on Guided missile destroyer tactics and find out what it really means.

– Do we monitor the SQLite decisions made and fine tune them as they evolve?

– What sources do you use to gather information for a SQLite study?

Language binding Critical Criteria:

Gauge Language binding tasks and overcome Language binding skills and management ineffectiveness.

– Does SQLite systematically track and analyze outcomes for accountability and quality improvement?

– How do mission and objectives affect the SQLite processes of our organization?

– Which SQLite goals are the most important?

Computer process Critical Criteria:

Scan Computer process visions and pay attention to the small things.

– Who is the main stakeholder, with ultimate responsibility for driving SQLite forward?

Visual Basic .NET Critical Criteria:

Be responsible for Visual Basic .NET strategies and handle a jump-start course to Visual Basic .NET.

– What are the success criteria that will indicate that SQLite objectives have been met and the benefits delivered?

– Do the SQLite decisions we make today help people and the planet tomorrow?

Internationalization and localization Critical Criteria:

Grasp Internationalization and localization results and budget the knowledge transfer for any interested in Internationalization and localization.

– How do we measure improved SQLite service perception, and satisfaction?

– What are current SQLite Paradigms?

Comparison of relational database management systems Critical Criteria:

Collaborate on Comparison of relational database management systems goals and ask questions.

– In a project to restructure SQLite outcomes, which stakeholders would you involve?

– What is the purpose of SQLite in relation to the mission?

– What are all of our SQLite domains and what do they do?

Component Pascal Critical Criteria:

Discourse Component Pascal leadership and cater for concise Component Pascal education.

– What other organizational variables, such as reward systems or communication systems, affect the performance of this SQLite process?

– What will be the consequences to the business (financial, reputation etc) if SQLite does not go ahead or fails to deliver the objectives?

– How can you negotiate SQLite successfully with a stubborn boss, an irate client, or a deceitful coworker?

Write-ahead logging Critical Criteria:

Deduce Write-ahead logging management and attract Write-ahead logging skills.

– Can we add value to the current SQLite decision-making process (largely qualitative) by incorporating uncertainty modeling (more quantitative)?

– Who will be responsible for deciding whether SQLite goes ahead or not after the initial investigations?

– Is the scope of SQLite defined?

Embedded system Critical Criteria:

Mix Embedded system projects and raise human resource and employment practices for Embedded system.

– What management system can we use to leverage the SQLite experience, ideas, and concerns of the people closest to the work to be done?

– How do we Identify specific SQLite investment and emerging trends?

– Why should we adopt a SQLite framework?

Common table expressions Critical Criteria:

Deliberate Common table expressions tasks and perfect Common table expressions conflict management.

– What are internal and external SQLite relations?

– What about SQLite Analysis of results?

Berkeley DB Critical Criteria:

Adapt Berkeley DB engagements and integrate design thinking in Berkeley DB innovation.

– Think about the functions involved in your SQLite project. what processes flow from these functions?

– What is the source of the strategies for SQLite strengthening and reform?

– How can you measure SQLite in a systematic way?

Application software Critical Criteria:

Read up on Application software leadership and plan concise Application software education.

– How do you manage the new access devices using their own new application software?

– Is the process effectively supported by the legacy application software?

– How to Secure SQLite?

Adobe AIR Critical Criteria:

Study Adobe AIR planning and suggest using storytelling to create more compelling Adobe AIR projects.

– What are the long-term SQLite goals?

Web SQL Database Critical Criteria:

Infer Web SQL Database tactics and sort Web SQL Database activities.

– Consider your own SQLite project. what types of organizational problems do you think might be causing or affecting your problem, based on the work done so far?

– What potential environmental factors impact the SQLite effort?

– What will drive SQLite change?

Data type Critical Criteria:

Closely inspect Data type risks and describe which business rules are needed as Data type interface.

– Who will be responsible for making the decisions to include or exclude requested changes once SQLite is underway?

– Is SQLite dependent on the successful delivery of a current project?

– Does the SQLite task fit the clients priorities?

– Are there any data standards for this data type?

Keir Thomas Critical Criteria:

Analyze Keir Thomas decisions and know what your objective is.

– Are there SQLite problems defined?

SQL data types Critical Criteria:

Recall SQL data types issues and do something to it.

– How do you incorporate cycle time, productivity, cost control, and other efficiency and effectiveness factors into these SQLite processes?

– How can we incorporate support to ensure safe and effective use of SQLite into the services that we provide?

– In what ways are SQLite vendors and us interacting to ensure safe and effective use?

Core Data Critical Criteria:

Test Core Data goals and achieve a single Core Data view and bringing data together.

– Are accountability and ownership for SQLite clearly defined?

– What are specific SQLite Rules to follow?

HTML Application Critical Criteria:

Paraphrase HTML Application governance and question.

– What are your most important goals for the strategic SQLite objectives?

Symbian OS Critical Criteria:

Confer re Symbian OS failures and oversee implementation of Symbian OS.

– What prevents me from making the changes I know will make me a more effective SQLite leader?

– Who are the people involved in developing and implementing SQLite?

Document-oriented database Critical Criteria:

Win new insights about Document-oriented database engagements and give examples utilizing a core of simple Document-oriented database skills.

– Which customers cant participate in our SQLite domain because they lack skills, wealth, or convenient access to existing solutions?

– Does SQLite appropriately measure and monitor risk?

– Why are SQLite skills important?

Software release life cycle Critical Criteria:

Track Software release life cycle failures and work towards be a leading Software release life cycle expert.

– What is the total cost related to deploying SQLite, including any consulting or professional services?

– Is SQLite Realistic, or are you setting yourself up for failure?

– Have all basic functions of SQLite been defined?

IBM Informix Critical Criteria:

Guard IBM Informix issues and slay a dragon.

– Are we Assessing SQLite and Risk?

RFO BASIC! Critical Criteria:

Prioritize RFO BASIC! tactics and check on ways to get started with RFO BASIC!.

– Have you identified your SQLite key performance indicators?

Relational database management system Critical Criteria:

Study Relational database management system tactics and devote time assessing Relational database management system and its risk.

– Record-keeping requirements flow from the records needed as inputs, outputs, controls and for transformation of a SQLite process. ask yourself: are the records needed as inputs to the SQLite process available?

– Does SQLite analysis isolate the fundamental causes of problems?

– How important is SQLite to the user organizations mission?

Web browser Critical Criteria:

Closely inspect Web browser failures and report on developing an effective Web browser strategy.

– Think of your SQLite project. what are the main functions?

Component Object Model Critical Criteria:

Look at Component Object Model tasks and finalize specific methods for Component Object Model acceptance.

– Marketing budgets are tighter, consumers are more skeptical, and social media has changed forever the way we talk about SQLite. How do we gain traction?

– Is the SQLite organization completing tasks effectively and efficiently?

File system permissions Critical Criteria:

Systematize File system permissions quality and give examples utilizing a core of simple File system permissions skills.

– For your SQLite project, identify and describe the business environment. is there more than one layer to the business environment?

– What knowledge, skills and characteristics mark a good SQLite project manager?

– What are the barriers to increased SQLite production?

Public domain Critical Criteria:

Discuss Public domain projects and raise human resource and employment practices for Public domain.

– What role does communication play in the success or failure of a SQLite project?

– Who will be responsible for documenting the SQLite requirements in detail?

Error code Critical Criteria:

Communicate about Error code decisions and get the big picture.

– How do senior leaders actions reflect a commitment to the organizations SQLite values?

– Is Supporting SQLite documentation required?

– How much does SQLite help?

Mozilla Firefox Critical Criteria:

Add value to Mozilla Firefox outcomes and reinforce and communicate particularly sensitive Mozilla Firefox decisions.

– Does SQLite include applications and information with regulatory compliance significance (or other contractual conditions that must be formally complied with) in a new or unique manner for which no approved security requirements, templates or design models exist?

– How do we know that any SQLite analysis is complete and comprehensive?

Windows 10 Critical Criteria:

Drive Windows 10 engagements and plan concise Windows 10 education.

– How likely is the current SQLite plan to come in on schedule or on budget?

Database trigger Critical Criteria:

Have a session on Database trigger adoptions and spearhead techniques for implementing Database trigger.

– Who will provide the final approval of SQLite deliverables?

Solaris 10 Critical Criteria:

Track Solaris 10 outcomes and correct Solaris 10 management by competencies.

– Do those selected for the SQLite team have a good general understanding of what SQLite is all about?

– How do we maintain SQLites Integrity?

Regression testing Critical Criteria:

Rank Regression testing results and differentiate in coordinating Regression testing.

– What do we do in regression testing?

Operating system Critical Criteria:

Devise Operating system projects and suggest using storytelling to create more compelling Operating system projects.

– If the firewall runs on an individual host for which all users are not trusted system administrators, how vulnerable is it to tampering by a user logged into the operating system running on the protected hosts?

– In a virtualized data center, guest operating system kernels were modified to eliminate the need for binary translation. which compute virtualization technique was used?

– What should an organization consider before migrating its applications and operating system to the public cloud to prevent vendor lock-in?

– What operating systems are used for student computers, devices, laptops, etc.?

– What operating system does your computer use?

– Is unauthorized access to operating systems prevented?

Database engine Critical Criteria:

Adapt Database engine issues and proactively manage Database engine risks.

– How do we ensure that implementations of SQLite products are done in a way that ensures safety?

– Are there any disadvantages to implementing SQLite? There might be some that are less obvious?

Proprietary software Critical Criteria:

Adapt Proprietary software management and gather practices for scaling Proprietary software.

Software categories Critical Criteria:

Deliberate Software categories projects and define what our big hairy audacious Software categories goal is.

– In the case of a SQLite project, the criteria for the audit derive from implementation objectives. an audit of a SQLite project involves assessing whether the recommendations outlined for implementation have been met. in other words, can we track that any SQLite project is implemented as planned, and is it working?

– What is our SQLite Strategy?

Free Pascal Critical Criteria:

Use past Free Pascal issues and frame using storytelling to create more compelling Free Pascal projects.

– To what extent does management recognize SQLite as a tool to increase the results?

SQL Server Compact Critical Criteria:

Be responsible for SQL Server Compact goals and adjust implementation of SQL Server Compact.

– Think about the people you identified for your SQLite project and the project responsibilities you would assign to them. what kind of training do you think they would need to perform these responsibilities effectively?

File size Critical Criteria:

Do a round table on File size decisions and be persistent.

– Does SQLite create potential expectations in other areas that need to be recognized and considered?

– Can we do SQLite without complex (expensive) analysis?

Conclusion:

This quick readiness checklist is a selected resource to help you move forward. Learn more about how to achieve comprehensive insights with the SQLite Self Assessment:

store.theartofservice.com/SQLite-Complete-Self-Assessment/

Author: Gerard Blokdijk

CEO at The Art of Service | theartofservice.com

gerard.blokdijk@theartofservice.com

www.linkedin.com/in/gerardblokdijk

Gerard is the CEO at The Art of Service. He has been providing information technology insights, talks, tools and products to organizations in a wide range of industries for over 25 years. Gerard is a widely recognized and respected information expert. Gerard founded The Art of Service consulting business in 2000. Gerard has authored numerous published books to date.

External links:

To address the criteria in this checklist, these selected resources are provided for sources of further research and information:

SQLite External links:

SQLite SELECT – Querying Data From a Single Table
www.sqlitetutorial.net/sqlite-select

SqliteOnline.com – Sqlite Browser
sqliteonline.com

SQLite Database Provider – EF Core | Microsoft Docs
docs.microsoft.com/en-us/ef/core/providers/sqlite

Guided missile destroyer External links:

Guided missile destroyer. A guided missile destroyer is a destroyer designed to launch guided missiles. Many are also equipped to carry out anti-submarine, anti-air, and anti-surface operations. The NATO standard designation for these vessels is DDG.
Reference: www.definitions.net/definition/guided%20missile%20destroyer

Language binding External links:

Mobius: C# Language Binding For Spark – Databricks
databricks.com/session/mobius-c-language-binding-for-spark

glossary – What is a language binding? – Stack Overflow
stackoverflow.com/questions/25865

Other Language Binding & Slip-on – Bookbind
www.bookbind.net/category-s/147.htm

Computer process External links:

how to remove kms-r@1n.exe in your computer process – …
www.youtube.com/watch?v=xS2NNCk58as

What Does GHz Mean in a Computer Processor? | Chron.com
smallbusiness.chron.com/ghz-mean-computer-processor-66857.html

How Does a Computer Process Data? | Techwalla.com
www.techwalla.com/articles/how-does-a-computer-process-data

Visual Basic .NET External links:

How to Program in Visual Basic .NET (VB.NET) (with …
www.wikihow.com/Program-in-Visual-Basic

Creating Classes in Visual Basic .NET – msdn.microsoft.com
msdn.microsoft.com/en-us/library/ms973814.aspx

Learning Visual Basic .NET – A Guide To VB.NET
www.udemy.com/learning-visual-basic-net

Internationalization and localization External links:

Internationalization and Localization Done Right – YouTube
www.youtube.com/watch?v=QUFPPJMjn6k

Component Pascal External links:

component pascal free download – SourceForge
sourceforge.net/directory/?q=component+pascal

Component Pascal – CFB Software
www.cfbsoftware.com/gpcp

Gardens Point Component Pascal (GPCP) Download
www.softpedia.com › Programming › Coding languages / Compilers

Write-ahead logging External links:

PostgreSQL: Documentation: 10: 30.2. Write-Ahead Logging (WAL)
www.postgresql.org/docs/10/static/wal-intro.html

[PDF]Lec 15: Crashes and Recovery: Write-ahead Logging
www.cs.columbia.edu/~du/ds/assets/lectures/lecture15.pdf

PostgreSQL: Documentation: 9.1: Write-Ahead Logging (WAL)
www.postgresql.org/docs/9.1/static/wal-intro.html

Embedded system External links:

Embedded System & PCB Design, IoT Development Company – Teksun
www.teksun.us

What is an Embedded System? – Definition from Techopedia
www.techopedia.com/definition/3636

Common table expressions External links:

Using Common Table Expressions – technet.microsoft.com
technet.microsoft.com/en-us/library/ms190766(v=sql.105).aspx

SQL Server Common Table Expressions (CTE)
www.sqlshack.com/sql-server-common-table-expressions-cte

SQL Server CTE (Common Table Expressions)
www.tutorialgateway.org/sql-server-cte

Berkeley DB External links:

Berkeley DB
Berkeley DB (BDB) is a software library that provides a high-performance embedded database for key/value data. Berkeley DB is written in C with API bindings for C++, C#, PHP, Java, Perl, Python, Ruby, Tcl, Smalltalk, and many other programming languages. BDB stores arbitrary key/data pairs as byte arrays, and supports multiple data items for a single key. Berkeley DB is not a relational database.

What is Berkeley DB, and where is it installed on XSEDE?
kb.iu.edu/d/axhc

Berkeley DB (Version: 12c Release 1) – Oracle
docs.oracle.com/cd/E17076_05/html/index.html

Application software External links:

Ch. 3 Application Software Flashcards | Quizlet
quizlet.com/149611441/ch-3-application-software-flash-cards

Application software – ScienceDaily
www.sciencedaily.com/terms/application_software.htm

Title application software Free Download for Windows
softwaretopic.informer.com/title-application-software

Adobe AIR External links:

Adobe AIR & PHP Development – vtc.com
www.vtc.com/cd/Adobe-AIR-PHP-Development-Tutorials.htm

Adobe AIR | Deploy applications across platforms and devices
www.adobe.com/products/air.html

As Adobe has focused on Flash Player development in the aftermath of the rise of HTML5, it hasn’t ignored its other content-delivery system: Adobe AIR. AIR 3
3.3/5(133)

Web SQL Database External links:

HTML 5 Web SQL Database – C# Corner
www.c-sharpcorner.com/UploadFile/75a48f/html-5-web-sql-database

Web SQL Database – World Wide Web Consortium (W3C)
www.w3.org/TR/webdatabase

Web SQL Database Mini Tutorial – YouTube
www.youtube.com/watch?v=9EF_lne01r0

Data type External links:

SQLite Data Type – tutorialspoint.com
www.tutorialspoint.com/sqlite/sqlite_data_types.htm

Quick-R: Data Type Conversion – statmethods.net
www.statmethods.net/management/typeconversion.html

Data Type Conversion (Database Engine)
technet.microsoft.com/en-us/library/ms191530(v=sql.105)

Keir Thomas External links:

Keir Thomas-Bryant (@KeirThomsBryant) | Twitter
twitter.com/KeirThomsBryant

Keir Thomas (@_popcool) | Twitter
twitter.com/_popcool

Keir Thomas – Football Recruiting – Player Profiles – ESPN
www.espn.com/college-sports/football/recruiting/player/_/id/195596

SQL data types External links:

Legacy SQL Data Types | BigQuery | Google Cloud Platform
cloud.google.com/bigquery/data-types

SQL Data Types – tutorialspoint.com
www.tutorialspoint.com/sql/sql-data-types.htm

SQL Data Types for MySQL, SQL Server, and MS Access
www.w3schools.com/sql/sql_datatypes.asp

HTML Application External links:

Introduction to HTML Applications (HTAs)
msdn.microsoft.com/en-us/library/ms536496(v=vs.85).aspx

Learn About Scripting for HTML Applications (HTAs)
technet.microsoft.com/en-us/scriptcenter/dd742317

HTML Applications – htmlgoodies
www.htmlgoodies.com/beyond/reference/article.php/3472841

Symbian OS External links:

Symbian Os – Free downloads and reviews – CNET Download.com
download.cnet.com/s/symbian-os

Symbian OS – YouTube
www.youtube.com/watch?v=DZv1Vs8Kve0

Nokia N80 review: Keypad, display, Symbian OS, …
www.gsmarena.com/nokia_n80-review-84p2.php

Document-oriented database External links:

Why is MongoDB a document-oriented database? – Quora
www.quora.com/Why-is-MongoDB-a-document-oriented-database

Software release life cycle External links:

Skill Pages – Software release life cycle | Dice.com
www.dice.com/skills/Software+release+life+cycle.html

Software release life cycle | 9to5Mac
9to5mac.com/guides/software-release-life-cycle

Software Release Life Cycle – Quora
www.quora.com/topic/Software-Release-Life-Cycle

IBM Informix External links:

[PDF]IBM Informix Developer’s Handbook
www.redbooks.ibm.com/redbooks/pdfs/sg247884.pdf

Relational database management system External links:

Relational Database Management System | MariaDB Products
mariadb.com/products

What does Relational Database Management System …
businessintelligence.com/dictionary/relational-database-management-system/

Relational Database Management System (RDBMS) – Techopedia.com
www.techopedia.com/definition/1235

Web browser External links:

Chrome Web Browser – Google Chrome
www.google.com/chrome

Clear your web browser’s cache, cookies, and history
kb.iu.edu/d/ahic

Download Firefox — Free Web Browser – Mozilla
www.mozilla.org/en-US/firefox/new/?icn=tabz

Component Object Model External links:

Distributed Component Object Model – technet.microsoft.com
technet.microsoft.com/en-us/library/cc958799.aspx

Component Object Model Hijacking – enterprise
attack.mitre.org/wiki/Technique/T1122

File system permissions External links:

[PDF]Troubleshoot Windows File System Permissions – …
www.emc.com/collateral/TechnicalDocument/docu63137.pdf

File System Permissions Weakness – ATT&CK – enterprise
attack.mitre.org/wiki/Technique/T1044

Understanding File System Permissions | Mac OS X …
www.peachpit.com/articles/article.aspx?p=1403238&seqNum=5

Public domain External links:

Public Domain ~ Free Media for Creative Projects | Pond5
www.pond5.com/free

Error code External links:

Stop error code 0x0000003B (SYSTEM_SERVICE_EXCEPTION…
support.microsoft.com/en-us/help/980932

Help: Error Code: WEASEL | Bungie.net
www.bungie.net/en/Help/Article/12320

DIRECTV Error Code 771 – DIRECTV Support – AT&T® Official
www.att.com/esupport/article.html#!/directv/KM1001809

Mozilla Firefox External links:

From Mozilla: Mozilla Firefox is a fast, full-featured Web browser. Firefox includes pop-up blocking, tab-browsing, integrated Google search, simplified privacy controls, a streamlined browser window that shows you more of the page than any other browser and a number of additional features that work with you to help you get the most out …
4.3/5(15.6K)

Mozilla Firefox – Download
mozilla-firefox.en.softonic.com

Mozilla Firefox – Google+
plus.google.com/+firefox

Windows 10 External links:

Windows 10 PC Gaming | Microsoft
www.microsoft.com/en-us/windows/windows-10-games

Activation in Windows 10 – Windows Help
support.microsoft.com/en-us/help/12440

Windows 10 release information – current branch, build …
technet.microsoft.com/en-us/windows/release-info.aspx

Database trigger External links:

What is a Database Trigger? – Essential SQL
www.essentialsql.com/what-is-a-database-trigger

Database Trigger samples. – KnowledgeSync
www.vineyardsoft.com/kb/DB_triggers_samples.htm

Solaris 10 External links:

Oracle Solaris 10 | Operating System | Oracle
www.oracle.com/solaris/solaris10

Oracle Solaris 10 1/13 Information Library Updated: 2013 …
docs.oracle.com/cd/E26505_01/index.html

Oracle Solaris 10 Support Explained | Oracle Solaris Blog
blogs.oracle.com/solaris/oracle-solaris-10-support-explained

Regression testing External links:

Regression Testing – Software Testing Fundamentals
softwaretestingfundamentals.com/regression-testing

Re-testing Vs Regression Testing – Meet Guru99
www.guru99.com/re-testing-vs-regression-testing.html

What is regression testing? – Definition from WhatIs.com
searchsoftwarequality.techtarget.com/definition/regression-testing

Operating system External links:

Operating System and Browser warning
itws.dhcs.ca.gov

Which Windows operating system am I running?
support.microsoft.com/en-us/help/13443

KAR Management Operating System (MOS) – Login
mos.auctiontrac.com

Database engine External links:

Lesson 1: Connecting to the Database Engine
technet.microsoft.com/en-us/library/ms345332(v=sql.110).aspx

Using Database Engine Tuning Advisor – technet.microsoft.com
technet.microsoft.com/en-us/library/ms189303(v=sql.105).aspx

Proprietary software External links:

What is Proprietary Software? – Definition from Techopedia
www.techopedia.com/definition/4333

Proprietary Software for Free | USC Spatial Sciences Institute
spatial.usc.edu/index.php/software/proprietary-software-free

Disadvantages of Proprietary Software | Chron.com
smallbusiness.chron.com/disadvantages-proprietary-software-65430.html

Software categories External links:

Software Categories
www.softwareadvice.com/categories

Browse Software Categories | Crozdesk
crozdesk.com/browse

Browse All Software Categories – FinancesOnline.com
financesonline.com/browse-all-software-categories

Free Pascal External links:

The Road to Delphi | Delphi – Free Pascal – Oxygene
theroadtodelphi.com

Free Pascal – Download Win32 version
www.freepascal.org/down/i386/win32-hungary.var

Free Pascal Program Tutorial 18 – Arrays – Lazarus – YouTube
www.youtube.com/watch?v=sv1GZnCx-PM

SQL Server Compact External links:

CAST and CONVERT (SQL Server Compact)
technet.microsoft.com/en-us/library/ms174450(v=sql.110).aspx

Maintaining Databases (SQL Server Compact)
technet.microsoft.com/en-us/library/ms172411(v=sql.110).aspx

Walkthrough: Working with SQL Server Compact in Visual …
msdn.microsoft.com/en-us/library/gg606540(v=vs.100).aspx

File size External links:

[PDF]Tips for Reducing File Size of Documents
www.matc.edu/about/human_resources/upload/TipsForUploadingTranscript

How to reduce the file size of a JPEG – Quora
www.quora.com/How-do-you-reduce-the-file-size-of-a-JPEG