Join 3,551 readers in helping fund MetaFilter (Hide)

243 posts tagged with sql. (View popular tags)
Displaying 1 through 50 of 243. Subscribe:

Related tags:
+ (78)
+ (44)
+ (42)
+ (34)
+ (28)
+ (17)
+ (16)
+ (16)
+ (12)
+ (12)
+ (10)
+ (9)
+ (9)
+ (8)
+ (8)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


Users that often use this tag:
desjardins (6)
DakotaPaul (6)
odinsdream (6)
arrowhead (3)
inigo2 (3)
iamkimiam (3)
Just this guy, y'know (2)
Dr Dracator (2)
jfricke (2)
Mrs. Pterodactyl (2)
Glendale (2)
omnipotentq (2)
maxwelton (2)
adipocere (2)
bleucube (2)
apark (2)
mark7570 (2)
Wild_Eep (2)
Four Flavors (2)
AllesKlar (2)
Anonymous (2)
derbs (2)
eas98 (2)
benjh (2)
dnash (2)
Nothing (2)
Jimbob (2)

Best resources for learning SQL for database newbies

I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within… [more inside]
posted by JimBJ9 on Aug 20, 2014 - 15 answers

How can I summarize quantities by ranges in Access 2010?

I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this: PIPE_PLR_Y MILES 1912 0.06 1914 0.48 1930 1.43 1942 1.32 1929 0.85 1925 2.00 1914 0.95 1929 0.42 ... The table has many, many values between about 1900 and today. I would like to make a table like this: Year_Range MILES 1900 - 1909 23.6 1910 - 1919 64.3 1920 - 1929 73.1 ... Again, I'm using Access 2010. Any help would be massively appreciated.
posted by rybreadmed on Aug 1, 2014 - 4 answers

Help me get a Microsoft DB certification

I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
posted by Mrs. Pterodactyl on Jul 15, 2014 - 3 answers

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

Connecting to Postgres through Powershell/Changing Username

I'm trying to log on to Postgres using Powershell and it's not working. I did this before a little while ago and now I can't remember how I did it and it's driving me crazy. [more inside]
posted by Mrs. Pterodactyl on Jun 4, 2014 - 8 answers

What format is this timestamp: 2456799.87848174 ?

I have an excel sheet of data extracted from a SQL database. A column in the table is headed "time" and has the following format: 2456799.87848174. How do I convert this to a human readable date and time, or even a unix timestamp? [more inside]
posted by Morsey on May 24, 2014 - 4 answers

Where do I learn SQL Basics?

I am starting a new job in about a month and need to brush up\learn SQL so that I can "hit the ground running" It's a testing role, so QA focused sites would be ideal. I used SQL everyday, but manipulating queries others have written. I think I need now how to write my own.
posted by MarvinJ on May 19, 2014 - 15 answers

SQL Trace: How to aggregate data by stored procedure without ClearTrace

I'm trying to put together an automated SQL server monitoring and diagnostics solution, including SQL Trace data. I want to be able to group RPC:Completed event data by stored procedure. Unfortunately, the formatting and parameter values in each specific call make this kind of aggregation impossible. For instance "Select * From qryLinksByNewsletterID Where NewsletterID=19" and "Select * From qryLinksByNewsletterID Where NewsletterID=234" would be considered different remote procedure calls. ClearTrace does that for you. But, ClearTrace can't run as an automated SQL job. Some kind of script would be ideal, and someone by the name of Andrew Zanevsky made a post describing one back in 2004, but the link to the actual script is dead. I could create my own with Regexes and such, but it seems like someone out there must have done it already. [more inside]
posted by UrbanEye on Feb 23, 2014 - 1 answer

Large scale web applications running on Windows

As a long time Linux Engineer I enjoy reading about the technologies used by sites like Twitter, Facebook, Etsy, Yahoo (for things like Flickr) and other large sites to build things out to scale. I often lend a hand with Windows customers at work and it recently occurred to me that I've never seen a website or blog posts that relate to scaling on Windows. [more inside]
posted by togdon on Dec 17, 2013 - 6 answers

Document-Oriented Database for Non-Programmers?

Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
posted by dylan_k on Dec 3, 2013 - 20 answers

Hourly contract rate for SQL in the UK?

I'm an American in the UK and have been hired to do some freelance work for a tech company in Northern England. I'm not sure what to charge for my hourly rate. I am working in SQL, writing queries and turning them into data visualizations for the web (using Ruby and Javascript/HTML). I am very junior, although quite competent at SQL; I'm coming up (and quickly) in the other areas. [more inside]
posted by anonymous on Nov 23, 2013 - 3 answers

SQL Teaching Game

I remember coming across a game that represented rows in a database as stars in a galaxy, and gave the player visual feedback for the queries they entered. What was that called?
posted by phrontist on Aug 1, 2013 - 2 answers

How can I do... anything? with this JSON file?

So, I've found the source of all the data I need in my database, but it is in a JSON file. MSSQL cannot read JSON and the entire internet seems devoted to telling me how brilliant and easy JSON is and then giving me 20 pages of code to deal with it. I don't have time to implement a JSON parse in C or anything like that. I just need to put this perfectly simple bit of data into a database. Can you help? [more inside]
posted by Just this guy, y'know on Jun 27, 2013 - 11 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

Fixing an unreasonably slow MySQL query

Query and Explain output here. Query must be executed 4022 times, each with a different Strip_ID, while the script processes, adding 4+ minutes to what would otherwise be a ~90-second task. I have (separate) indices defined @ Parent_Table and Parent_ID, in addition to the table's primary key on an auto-incrementing ID. Adding combined indices for those two fields (in each order, just to be safe) did not change MySQL's analysis of the query or improve execution speed. [more inside]
posted by The Confessor on May 24, 2013 - 9 answers

Some weird SQL code appeared unexpectedly in my browser's address bar

I know it's some sort of SQL injection, but I didn't type it in, it just appeared briefly. I just want to know more about it and how it works. [more inside]
posted by zorro astor on May 23, 2013 - 7 answers

Training courses for MCSA?

Please recommend training courses for certifications related to Microsoft server and SQL administration, such as MCSA. [more inside]
posted by odinsdream on Apr 4, 2013 - 2 answers

How can I merge only the relevant results in SQL

I have a table in my database. It has a bunch of 4 digit codes representing a location (as well as other data). The problem is that some of these locations need to be replaced with an updated code. I have a second table with the substitutions that need to be made, but it is only a small minority of codes that need updating. How do I format my SQL statement to produce me a list of all records, with the new location code if it has a new code and the old code if there is no update needed. [more inside]
posted by Just this guy, y'know on Feb 21, 2013 - 12 answers

Data Driven Clinical Care - Dynamic Graphing Website

I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality hates the MS Access solution that is being built. [more inside]
posted by rosswald on Jan 16, 2013 - 4 answers

model.where(:name => "string) INTERNAL ERROR!!! No attribute exists!

In Rails, I'm using a model to represent a database view. I'm getting an error when I try to search on an attribute. (gist). [more inside]
posted by czytm on Dec 17, 2012 - 8 answers

Help this Mac user learn PC software for job hunt

How can I improve my computer skills for job hunt when I use a Mac and the software is for PC? [more inside]
posted by hrj on Aug 9, 2012 - 24 answers

How to share many pdf files with our many customers?

How to share many pdf files with our many customers? [more inside]
posted by monkey_toes on Jun 11, 2012 - 6 answers

Am I SQL to the task?

I'm a full-time freelance web designer and developer for a wide variety of clients. One of my clients just asked me to build a web site them but it turns out that what they really want instead is a user registration system that has a rewards component. Can I beg, borrow or steal something that's already built, or should I get out now before I get in too deep? [more inside]
posted by lgandme0717 on May 14, 2012 - 1 answer

Web front end for SQL Server?

Are there really no web front end design environments that are as stupid simple as MS Access form design for a SQL Server back end? I can write a real clever stored procedure for SQL Server and assign cute and short aliases to every element of the result set and crank out an Access form or forms in no time and distribute it as a light weight front end with only execute permission required. Is there some analog for a web front end? [more inside]
posted by Rafaelloello on Apr 24, 2012 - 4 answers

SQL Query to find unique combinations

SQLNoobFilter: I am trying to find all unique combinations on a table. Does my simple query do the trick or is there more to it? [more inside]
posted by amazingstill on Mar 14, 2012 - 5 answers

Better Living Through Queries

Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
posted by bluejayway on Mar 1, 2012 - 11 answers

How do I go from MAMP to champ?

How do I transfer my locally-created Wordpress site (using MAMP) to my live Dreamhost site? [more inside]
posted by This_Will_Be_Good on Feb 12, 2012 - 13 answers

SQL: How do I increment an alphanumeric field by + 1?

I'm a bit of a SQL novice but learning at a decent clip. I'm using SQL (Aqua Data Studio, if that matters to you) to update a couple of fields in an Oracle database table. I'd like to do this across a range of one of the fields. One field is a numeric field (trans_id - a transaction id) that I need to increase by 1 -- I think have that part licked. The next field is alphanumeric (calendar_name - represents the name of a week) and also needs to be incremented by one. The doozy (for me) is the alphanumeric field. Who's the guru? [more inside]
posted by brokeaspoke on Feb 4, 2012 - 11 answers

Is there a way to visually organize database tables (and saved queries and views)?

I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
posted by iamkimiam on Feb 2, 2012 - 4 answers

Help me phone screen interview candidates more effectively?

Help me do a better job of phone screening candidates for largely-technical/programming positions. [more inside]
posted by ish__ on Jan 21, 2012 - 8 answers

How do I move this database online?

What's the easiest, most secure way to move this SQL database and its browser-based front end online? [more inside]
posted by infinitywaltz on Jan 18, 2012 - 17 answers

Mac file manipulation for power users?

Is there a SQL-like way to interact with the Mac filesystem? Failing that, what's better than the Finder for batch copies/moves/deletions? [more inside]
posted by ripley_ on Dec 22, 2011 - 12 answers

Improving my knowledge of SQL and PostgreSQL

Free or creative-commons books to help me improve my knowledge of SQL. [more inside]
posted by a womble is an active kind of sloth on Dec 16, 2011 - 3 answers

Why is Goldmine so sluggish?

Help, SQL connectivity issues are driving me batty! [more inside]
posted by griphus on Dec 12, 2011 - 8 answers

Learning Oracle and SQL

Hey all. I need to learn the basic principles of SQL and Oracle databases. I'm looking for web resources and books. Got any favorites? What's out there? Thanks in advance.
posted by Stagger Lee on Dec 5, 2011 - 12 answers

puzzling over a query

I'm trying to write a SQL query on an 8 year old broken Access database that I didn't build, now on Access 2007. It's fun, I tell you what. I'm having trouble with a left outer join. [more inside]
posted by hotelechozulu on Oct 28, 2011 - 5 answers

SELECT careerhelp FROM much better informer mefites.

It is time to refine my career. Help me become an excellent database administrator. [more inside]
posted by munchingzombie on Oct 23, 2011 - 7 answers

What should I charge to build a mobile app?

How much should I charge for developing a mobile/web app? And, should I charge hourly, weekly, or ask for a fulltime position? [more inside]
posted by Earl the Polliwog on Sep 20, 2011 - 8 answers

How to write an SQL query in unix?

I'd like to perform an SQL query with outer joins, from text files on my PC, using only a unix emulator. Is this possible on my PC? How would I write and execute it? [more inside]
posted by RobinFiveWords on Sep 13, 2011 - 16 answers

i need a database!

[Python/database filter] I wrote a script in python for a class and I want to challenge myself now to make it attached to a database... [more inside]
posted by handbanana on Aug 26, 2011 - 8 answers

What do I need to know to fill in the gaps?

Looking for books and articles on programming, design patterns, information architecture, and whatever else. Clear information on Things To Do and Things To Avoid, with a smattering of theory and opinion, would be great. [more inside]
posted by jsturgill on Aug 23, 2011 - 5 answers

Best practices for MSSQL off-site backup?

What's the smartest way to keep regular backups of Microsoft SQL Server databases stored remotely? [more inside]
posted by odinsdream on Aug 6, 2011 - 2 answers

How do I get data from multiple other entries in a database?

SQL help: I'm very new to SQL, and need to update one field with the maximum value of all entries in another field selected based on a shared value in a third field. [more inside]
posted by agentofselection on Jul 17, 2011 - 12 answers

SELECT TOP 10 blogs FROM blagosphere WHERE type = 'SQL Server'

Best blogs for SQL Server? [more inside]
posted by bfranklin on Jul 1, 2011 - 5 answers

Help me write this SQL job

What's the best way to write this SQL job? I have a table with browser session information collected. I want to clear this table and store the information in another table. [more inside]
posted by zephyr_words on May 31, 2011 - 7 answers

Looking for a good book to help me brush up on my database skills

I've been working with SQL and RDBMSes for a number of years, but my most recent job involved no DB work at all. Understandably, I'm a bit rusty. So I'd like to get a good book to help me brush up, and also to learn a bit more about RDBMS technology. What would you recommend? [more inside]
posted by Sloop John B on May 3, 2011 - 3 answers

SQL Alter statement

SQL SERVER: Need help creating new column in a table with unformatted SSN. [more inside]
posted by fozzie33 on Apr 6, 2011 - 6 answers

[hɛlp mi si junikod ɪn maɪ deɪtəbeɪs, ɔr maɪ dætəbeɪs ivɛn]

I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols? [more inside]
posted by iamkimiam on Mar 8, 2011 - 2 answers

Crystal Reports

Help with using Crystal Reports to report on an Oracle database [more inside]
posted by toenail on Feb 15, 2011 - 3 answers

Page: 1 2 3 4 5