uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 38 bookmarks
howto information development guide reference administration design website software solution service product online business uk tool company linux code server system application web list video marine create data experience description tutorial explanation technology build blog article learn world project boat download windows security lookup free performance javascript technical network control beautiful support london tools course file research purchase library programming image youtube example php construction html opensource quality install community computer profile feature power browser music platform mobile user process work database share manage hardware professional buy industry internet dance advice installation developer 3d search access customer camera material travel test standard review documentation css money engineering develop webdesign engine device photography digital api speed source program management phone discussion question event client story simple water marketing yacht app content setup package fast idea interface account communication cheap compare script study live market easy google resource operation startup monitor training
Tag selected: query.
Looking up query tag. Showing 38 results. Clear
Can Windows tell me what is using my USB drive? - Super User
Saved by uncleflo on January 16th, 2022.
Connect and share knowledge within a single location that is structured and easy to search. Being the good citizen I am, I left-click on the "Safely Remove Hardware" icon in my taskbar, and select my USB drive to dismount. Then I get the message: Windows can't stop your Generic volume device because it is in use. Close any programs or windows that might be using the device, and then try again later. Of course, being the Operating System, it knows exactly what applications are using my device. So why won't it tell me? Or is there a way that I can find out?
eject unmount graceful click remove overflow query stack explorer disclose partition windows drive file scan device answer connect knowledge howto question structure search safely hardware generic program system message block problem solution administration
Working with Amazon Aurora Global Database - Amazon Aurora
Saved by uncleflo on June 23rd, 2019.
Following, you can find a description of Amazon Aurora Global Database. Each Aurora global database spans multiple AWS Regions, enabling low latency global reads and disaster recovery from region-wide outages. An Aurora global database consists of one primary AWS Region where your data is mastered, and one read-only, secondary AWS Region. Aurora replicates data to the secondary AWS Region with typical latency of under a second. You issue write operations directly to the primary DB instance in the primary AWS Region. An Aurora global database uses dedicated infrastructure to replicate your data, leaving database resources available entirely to serve application workloads. Applications with a worldwide footprint can use reader instances in the secondary AWS Region for low latency reads. In the unlikely event your database becomes degraded or isolated in an AWS region, you can promote the secondary AWS Region to take full read-write workloads in under a minute.
aurora cluster database endpoint latency snapshot amazon query console replication footprint synchronize bucket secondary instance primary compatibility relational capability website failover mariadb howto isolated resource application workcreate enable browser read parameter outage administration aws documentation
sql - MySql : Grant read only options? - Stack Overflow
Saved by uncleflo on June 23rd, 2019.
Is there a way to group all read operations in grant ? If there is any single privilege that stands for ALL READ operations on database. "Reading" from tables and views is the SELECT privilege. If that's what you mean by "all read" then yes: However, it sounds like you mean an ability to "see" everything, to "look but not touch." So, here are the other kinds of reading that come to mind: "Reading" the definition of views is the SHOW VIEW privilege. "Reading" the list of currently-executing queries by other users is the PROCESS privilege.
solution read readonly write administration development privilege query database mariadb mysql data permission user howto question
Create a Database User - SQL Server | Microsoft Docs
Saved by uncleflo on May 4th, 2019.
This topic describes how to create the most common types of database users. There are eleven type of users. The complete list is provided in the topic CREATE USER (Transact-SQL). All varieties of SQL Server support database users, but not necessarily all types of users. You can create a database user by using SQL Server Management Studio or by using Transact-SQL.
authenticate database password user schema folder authentication server select query containment specify feedback certificate connect execute confirm windows transaction manage studio microsoft sqlserver type description variety support topic access privilege
Download Query Express
Saved by uncleflo on April 18th, 2019.
Query Express is a simple Query Analyzer look-alike, but being small and free, it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects, to Oracle and other OLE-DB compliant databases. Query Express requires no installation and is packaged as a single 100KB executable. This is more than 300 times smaller than SQL Server Management Studio! Query Express is ideal for those not yet ready for LINQPad.
query permissive analyzer compliant package program setup playground oracle browser definitive server compatible express file client ideal framework tool useful ready windows object visual maintain contact source reference simple look sql sqlclient connection ole portable manage management data
tf–idf - Wikipedia
Saved by uncleflo on December 23rd, 2018.
In information retrieval, tf–idf or TFIDF, short for term frequency–inverse document frequency, is a numerical statistic that is intended to reflect how important a word is to a document in a collection or corpus. It is often used as a weighting factor in searches of information retrieval, text mining, and user modeling. The tf–idf value increases proportionally to the number of times a word appears in the document and is offset by the number of documents in the corpus that contain the word, which helps to adjust for the fact that some words appear more frequently in general. Tf–idf is one of the most popular term-weighting schemes today; 83% of text-based recommender systems in digital libraries use tf–idf. Variations of the tf–idf weighting scheme are often used by search engines as a central tool in scoring and ranking a document's relevance given a user query. tf–idf can be successfully used for stop-words filtering in various subject fields, including text summarization and classification. One of the simplest ranking functions is computed by summing the tf–idf for each query term; many more sophisticated ranking functions are variants of this simple model.
tf-idf logarithm retrieval document query corpus frequency statistic weighted relevance term relevant wikipedia howto theory explanation article text mine model
Heliguy - CAA Approved NQE
Saved by uncleflo on November 27th, 2018.
CAA Approved NQE Heliguy has National Qualified Entity (NQE) approved status from the Civil Aviation Authority. This permits us to carry out unmanned aircraft pilot training at a number of UK locations. Drone pilots who want to undertake commercial work are required to have been trained and tested before they can apply for a Permission for Commercial Operations (PfCO) from the CAA. We’ll guide you through this process and ensure it’s as painless and enjoyable as is possible! We have an FCA-approved consumer credit licence to enable us to broker credit deals on drones, equipment and training. Heliguy’s on-site technical team not only builds custom aircraft and deals with repairs, it’s also equipped to produce bespoke equipment and modifications to UAVs with the aid of 3D printing technology and years of hands-on experience. Our knowledgeable sales team are just a phone call away when you need a quick answer to your query.
drone uav unmanned aircraft query knowledge licence build team status caa authority technology equipment learn approve modify experience sales answer repair process train require undertake permission course howto test
Amazon - High Performance MySQL: Optimization, Backups, and Replication - Third Edition
Saved by uncleflo on June 27th, 2018.
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
amazon mysql power performance technique design index query tune server system hardware potential practical scale application replication balance availability failover infrastructure advanced optimization backup high performance buy product book information developer administration
How to use MySQL to search in php serialized fields
Saved by uncleflo on June 22nd, 2018.
Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT * FROM table WHERE your_field_here REGEXP '.*"array_key_here";s:[0-9]+:"your_value_here".*' Of course it won’t be very fast but in small tables should be enough
rule index mysql search query array regex fast table associate serialized reason field php database stored solution development code sql
Create MySQL table by using another table
Saved by uncleflo on May 29th, 2018.
Let's look at a common task that a developer does in their day-to-day job. A database table is to be modified for its data and/or structure. Before making any changes, the first thing that is always wise to do is to back up the database table. The easy way to accomplish this is to write a piece of SQL script like below. The scenario is we're going to make some changes to Products table, so here we go. Copy and paste the following SQL to your SQLyog free Community Edition query window. Note that the SQL needs to end with semi-colon if you have multiple queries in the query window. Most of the queries in the tutorials need Northwind MySQL database, you can download the database script on this page.
common task database table development administration windows query tutorial mysql create howto example script modify structure web
VividCortex - Application performance starts with your database
Saved by uncleflo on April 18th, 2018.
Most app performance issues originate in the database, but engineering teams lack visibility into the data tier. VividCortex provides unique insights into database workload and query performance, enabling faster issue resolution. The result is better application performance, reliability, and uptime. This ebook will help you understand key questions that you should pose about your database—and it will show you exactly how you can answer them, quickly and safely, with VividCortex.
performance development engineering team database db test optimization overview analysis question code query sql
MySQL EXPLAIN Output Format
Saved by uncleflo on April 18th, 2018.
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. MySQL resolves all joins using a nested-loop join method. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third table, and so on. When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. The next row is read from this table and the process continues with the next table.
explain explanation analysis mysql development administration query sql statement howto analyse optimize table method loop process row column output reference execution dbms innodb
Temporary tables in SQL query optimization
Saved by uncleflo on April 18th, 2018.
SQL queries can get complex in a big hurry. If you are querying multiple tables, and in particular if your query involves operations like UNION and INTERSECT, then you can find yourself in a big, messy pile of SQL. Worse, that big pile will often run slowly, sometimes to the point where a web application times out! I won’t inflict a real-world example on you; that would be cruel. So let’s look at a “toy” problem, keeping in mind that this won’t illustrate any time-savings, just the technique involved.
query complex temporary table operation union intersect problem description solution development database db howto sql optimize blog article
Painless HA failover with MariaDB
Saved by uncleflo on February 26th, 2018.
At work, we run a simple high-availability (HA) MariaDB setup that consists of an active master that handles all read and write queries from our applications, a passive master that can take over for the active master at any time, and a read-only replication slave (not shown) that we use for backups and analytics. Replication is configured so that the active master follows the passive master, the passive master follows the active master, and the analytics slave follows one of the masters. For the remainders of this post, I will refer to the active master as the master and the passive master as the standby. The benefits of this master-master configuration is that it allows us not only to failover from master to standby if the master becomes unhealthy, but also allows us to perform patching, reboots, lengthy migrations, and other kinds of database maintenance without impacting our users. Well, almost...
high availability mariadb master slave query db dbms backup replication failover painless administration configuration perform patch reboot application remain impact user configure maintain
PHP Mini SQL Admin
Saved by uncleflo on February 15th, 2018.
PHP Mini SQL Admin - Lightweight alternative to heavy phpMyAdmin. Extremely small (~30Kb) standalone php script. Easy to Install, simple to use. No SQL knowledge required for basic operations. Features: full MySQL support, extremely small (~30Kb), just in one php file.
php tool mysql interface connect light lightweight alternative small simple operation feature database file easy useful db dbms frontent mini query sql
MemberGate Subscription & Membership Web Site Software
Saved by uncleflo on February 7th, 2018.
MemberGate is the top of the line, membership site solution. With more than thousands of customers using MemberGate and 11+ years of experience, its simply the best. You benefit from the proven reliability of having a smooth running membership site. When you invest in MemberGate, you can concentrate on making your business profitable instead of trying to figure out how to make it run. When it comes to your membership site: We set it up for you. We do the graphics for you. We provide superior support to you.Typically within one business day, you can be logging in to your new, full featured membership site. With MemberGate you can quickly and easily build a professional membership site yourself, without needing a staff of trained professionals.
website online membership solution customer reliable business profitable money portal query subscription system crm software buy purchase howto administration
Full-Stack Cloud Native Monitoring Strategies
Saved by uncleflo on December 27th, 2017.
It is the weekend, late at night, or first thing Monday morning and you receive the dreaded phone call or SMS: “The application is down! We need all hands to figure this out!” After spending hours trying to track down the issue by reviewing logs, looking at the currently deployed code, and hundreds of IM exchanges, you finally find it – someone deployed a patch to production late Friday and it broke an important part of your application. You have probably been there. While tracking down issues can be difficult for any application, cloud native applications are particularly difficult. Applications are deployed to multiple servers across any number of zones. Servers have been created and destroyed. And the amount of traffic you must handle makes it hard to read log files (even centrally managed log files). So, how do you solve the need for monitoring in a cloud native architecture? While every application’s needs are different, we must first understand the options available to us. This article provides an overview of the goals of monitoring and the types of cloud native monitoring available, to help provide some insight into monitoring your Realscale applications.
monitor monitoring application application monitoring cloud code development administration architecture understand article overview realscale need zone deploy exchange production native explanation scaleble error handling performance server administrator developer operating system resource system query business security log
How to avoid many-to-one problems in SQL
Saved by uncleflo on May 15th, 2017.
It’s been a while since I’ve posted an abstract, theoretical article on a fine point of SQL. Today I want to bring your attention to two ways in which an RDBMS can allow you to do something that has no well-defined result. These involve queries where several values are eligible, but only one is chosen – and chosen in an undefined manner. I’ll show you the two blunders, tell you when they might occur, and explain how to avoid them.
sql blog article problem query database description relation involve eligible many-to-one one-to-many explanation mysql
Free Keyword Tools
Saved by uncleflo on July 23rd, 2016.
WordStream's free keyword tools are an integrated, actionable suite designed to help search marketers with keyword suggestion, keyword grouping, keyword analysis, long-tail keyword research and negative keyword discovery. Our fast, powerful tools draw from a trillion-keyword database and go beyond the capabilities that a typical free keyword tool can offer.
free keyword tools wordstream advice development administration marketing offer ppc online advertising howto easy suggestion niche negative tool seo campaign data pocket opportunity value structure discover query suite marketer search software service agency pay per click budget
performance - Mysql int vs varchar as primary key (InnoDB Storage Engine? - Database Administrators Stack Exchange
Saved by uncleflo on February 22nd, 2015.
I am build a web application (project management system) and I have been wondering about this when it come to performance. I have an Issues table an inside it there are 12 foreign keys linking to various other tables. of those, 8 of them I would need to join to get the title field from the other tables in order for the record to make any sense in a web application but then means doing 8 joins which seems really excessive especially since I am only pulling in 1 field for each of those joins.
performance database text varchar primary key storage engine test string query
MySQL :: MySQL 5.5 Reference Manual :: 11.9 Full-Text Search Functions
Saved by uncleflo on February 22nd, 2015.
MySQL has support for full-text indexing and searching. Full-text searching is performed using MATCH() ... AGAINST syntax. MATCH() takes a comma-separated list that names the columns to be searched. AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform. The search string must be a string value that is constant during query evaluation. This rules out, for example, a table column because that can differ for each row.
mysql search index fulltext database engine howto administration development function reference manual type collation performed query expand sql
Discover Greece
Saved by uncleflo on November 14th, 2014.
Join the campaign that celebrates the best of what Athens has to offer its visitors. Every destination has a wealth of discoveries. Let us suggest some top highlights and secrets from around Greece.
greece thessaloniki visit discover image digital athens beautiful destination beauty connect holiday plan trip stay travel season summer query discovery alliance member practical aegean feedback information type flight hotel ticket link subscribe media webdesign web design event calendar
Simon Whatley - Apache .htaccess query string redirects
Saved by uncleflo on October 11th, 2014.
One of the most common tasks performed by Apache and htaccess is the manipulation of a URL and configuring a redirect for a specific page. Creating a single page redirect in Apache is a simple task, which uses mod_alias module.
rewrite redirect query string pattern htaccess url server lamp linux guide article blog howto apache page web configuration
YQL Console: show tables
Saved by uncleflo on January 24th, 2014.
A complete Yahoo API query analyser that gets data from a large DB of tables on the Yahoo Developer Network. Queries are based on SQL syntax
network developer development html ajax json data xml editor solution query yql language yahoo online web
php - How to 'insert if not exists' in MySQL? - Stack Overflow
Saved by uncleflo on January 24th, 2014.
I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I want to insert does not already exist without using a pair of queries (ie, one query to check and one to insert is the result set is empty)? Does a unique constraint on a field guarantee the insert will fail if it's already there? It seems that with merely a constraint, when I issue the insert via php, the script croaks.
exist insert mysql php sql script javascript ignore development solution question query duplicate
