Navigation

    ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. sql
    Log in to post

    • How to Install Oracle Database 19c on Windows Server 2019
      Starwind • oracle sql oracle db k2 • • Oksana  

      2
      1
      Votes
      2
      Posts
      95
      Views

      Sometimes I forget that Oracle is still offering a database product, lol.
    • ERROR 1366 When Important MySQL Database for WordPress
      IT Discussion • wordpress database mysql mariadb sql rdbms • • scottalanmiller  

      2
      1
      Votes
      2
      Posts
      103
      Views

      M

      I've seen that a lot. When I import Drupal databases, I learnt to use its Backup and Migrate module instead, it works flawlessly. Downside is you need to do clean Drupal installation first, but that basically is just creating blank database and putting brick on enter key.
    • How to Rename a Column in SQLite Database
      IT Discussion • database sql sqlite sqlite3 • • scottalanmiller  

      10
      1
      Votes
      10
      Posts
      206
      Views

      @Pete-S said in How to Rename a Column in SQLite Database: There used to be a lot of databases like SQLite. Often called database engines. dBase was probably one of the first. Later Microsoft Jet engine (aka Microsoft Access) became popular when Visual Basic ruled the world. Basically it's a one user database. You can have more than one user but it's done by multiple users accessing the same database file. Or by having an application on top that accessing the file and shares it out. That thing can be called a "database management system" or any application, really. All databases use database engines. MySQL, for example, isn't a database. It's a database management system. It uses one or more database engines to talk to the files on disk. MyISAM and InnoDB are two database engine options for the MySQL platform. At the end of the day, all databases work like SQlite. You can easily build your own database management system that uses SQlite as the engine and it could work just like MySQL or Oracle or SQL Server. Those are all single users to a file, under the hood. They just have the "multi-access" management built into an extra layer, instead of letting an application handle it. But for most things, you only access a database from a single app anyway, so that extra layer is often unnecessary as it is redundant. Just adds overhead.
    • Building Apps in Ubuntu Using PostgreSQL
      Starwind • ubuntu sql postgresql django ubuntu server • • Oksana  

      1
      1
      Votes
      1
      Posts
      102
      Views

      No one has replied

    • Microsoft SQL Server FILESTREAM – Giving a bit of structure to your unstructured data
      Starwind • database sql microsoft sql sqlserver • • Oksana  

      1
      2
      Votes
      1
      Posts
      75
      Views

      No one has replied

    • J

      Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host
      IT Discussion • windows 10 hyper-v database windows server 2016 sql rdbms ms sql server ms sql server 2016 • • JasGot  

      27
      2
      Votes
      27
      Posts
      457
      Views

      J

      @pmoncho said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host: @JasGot said in Slow MS SQL Queries between Windows 10 VMs and MS SQL 2014 on same host: Winner Winner, Chicken Dinner. It was MDTC and Windows Firewall. (Which is frustrating, because the firewall is turned off for the domain!) Good job at troubleshooting. I'm wondering what led you down this path versus something related to Networking, hard drives or software drivers? Remembered it from several years ago with another SQL based application. Don't know what made me think of it at 1:30am. But I'm ok with it!
    • Migrate Windows-based vCenter to VCSA 6.7 U1 & ensure hardened safety right now
      Starwind • vmware vcenter sql vcsa • • Oksana  

      1
      3
      Votes
      1
      Posts
      72
      Views

      No one has replied

    • Windows Site Migration Tool: Migrate your IIS websites at a fast clip
      Starwind • microsoft starwind azure sql • • Oksana  

      3
      3
      Votes
      3
      Posts
      267
      Views

      @dbeato said in Windows Site Migration Tool: Migrate your IIS websites at a fast clip: The new thing with Microsoft Azure is SiteCore, that is the new trend and people are already on that. Not sure but we might want to discuss that on ML one of this days. @scottalanmiller Overreaching of user information https://www.sitecore.com/products/sitecore-experience-platform
    • Looking for method to backup Azure SQL database to another location or service
      IT Discussion • backup azure sql backup and disaster recovery • • JaredBusch  

      2
      4
      Votes
      2
      Posts
      331
      Views

      What account the sql account or the azure login?!
    • How to back up your SQL Server databases to Azure without a hassle
      Starwind • azure database sql server sql microsoft sql azure backup • • Oksana  

      1
      1
      Votes
      1
      Posts
      277
      Views

      No one has replied

    • Learn how to build a disaster recovery site with SQL Server AlwaysOn AGs
      Starwind • microsoft sql sqlserver • • Oksana  

      1
      1
      Votes
      1
      Posts
      236
      Views

      No one has replied

    • osTicket: Basic Ticket Report of All Tickets with Subject
      IT Discussion • mysql mariadb sql osticket osticket 1.10 query report • • scottalanmiller  

      7
      3
      Votes
      7
      Posts
      1643
      Views

      @bbigford said in osTicket: Basic Ticket Report of All Tickets with Subject: Since there is no inner or outter join specified, inner join is obviously being used where 'join' is specified (outter join having to be explicitly defined where an outter join is needed). How come you explicitly specify 'inner join' at the bottom when you could just use 'join' again as your inner join? Obviously join and inner join accomplish the same thing, just curious why one is not explicitly defined and the other is. I expanded on something done by someone from the osTicket team. it was some weird stylistic choice that they made and I just followed.
    • osTicket: How to Query a Ticket Subject for a Report
      IT Discussion • mysql mariadb sql osticket osticket 1.10 query report • • scottalanmiller  

      1
      3
      Votes
      1
      Posts
      599
      Views

      No one has replied

    • Getting a grasp of what Always On is and how it works
      Starwind • microsoft sql ha highavailability sqlserver disasterrecovery hadr • • Oksana  

      1
      1
      Votes
      1
      Posts
      326
      Views

      No one has replied

    • How to create developer and test environments in minutes with Azure DevTest Labs
      Starwind • microsoft azure sql server sql • • Oksana  

      1
      1
      Votes
      1
      Posts
      382
      Views

      No one has replied

    • Using In-Memory Databases, Anyone?
      IT Discussion • database sql server sql performance databases apache geode in-memory databases • • NetworkNerd  

      18
      0
      Votes
      18
      Posts
      1664
      Views

      We have plans to add an in memory database to ML in the future when more performance is needed, as well.
    • Snipe-IT Shell Commands and Backing up
      IT Discussion • backup sql shell snipe-it cron • • DustinB3403  

      4
      1
      Votes
      4
      Posts
      1714
      Views

      @hobbit666 no this is just for the mysql database.
    • Pronunciations of SQL Derived Database Names and Terms
      IT Discussion • database mysql sql postgresql databases ms sql server sequel pronunciation • • scottalanmiller  

      77
      3
      Votes
      77
      Posts
      5001
      Views

      @matteo-nunziati said in Pronunciations of SQL Derived Database Names and Terms: we have a company in my town: second quadrant. the provide professional postgresql support worldwide and they pronunce it "postgres". omitting the final "ql" That's the official pronunciation and it was originally spelled that way. The PostgreSQL spelling was added when it went open source.
    • Bootleg T-shirts for MangoCon 2017
      Water Closet • sql mangocon 2017 fun minionarmyunite • • RojoLoco  

      15
      6
      Votes
      15
      Posts
      1295
      Views

      @Tim_G said in Bootleg T-shirts for MangoCon 2017: Actually, it's not! http://patorjk.com/blog/2012/01/26/pronouncing-sql-s-q-l-or-sequel/ You know if you go to that post and look on the comments, I'm on there from before.
    • SQL mirroring advise
      IT Discussion • sql replication mirroring sql server 2012 sql 2012 standard sql mirroring • • Ambarishrh  

      16
      1
      Votes
      16
      Posts
      2534
      Views

      @scottalanmiller said in SQL mirroring advise: @Ambarishrh said in SQL mirroring advise: @scottalanmiller said in SQL mirroring advise: @Ambarishrh said in SQL mirroring advise: @scottalanmiller said in SQL mirroring advise: @Ambarishrh said in SQL mirroring advise: @Dashrender said in SQL mirroring advise: Are the two SQL servers sitting side by side? If not, shared storage and low latency for it's use would be super expensive. Though I do wonder how their DR plan works if there isn't a cluster for the DB, what purpose does the second server serve? Warm spare? Yes the servers are side by side, basically just sits there, and when a new site is created on SP side, run the script which mirrors the new DB created on server 1 to server 2. Eventually they were planning to introduce the witness server once our testing is complete and then enable auto failover. The downside here is that someone need to manually run the script for db mirroring of new databases So the big thing here is that the databases are not mirrored, just the framework (schema) is at creation time. Very different from mirroring or clustering at that aspect level. Yes, we've told them this won't work and asked them to look at a clustered setup. Since the licenses are already in place and is SQL standard no option for Always-On. I want to know what would be the drawbacks for the clustered setup, as for sure there are some more advantages on Always-ON compared to the clustered setup. Won't work... for what? What's the end goal? Won't work: Current stage its 2 separate DB servers and mirroring needs to be done by executing a script whenever there is a new db is created by SP. End Goal: A fully automated failover setup giving high availability for the SharePoint solution What they are doing is unrelated to their end goal. How does mirroring database creation help with failover. There isn't even a first step in preparing for a failover here. What is going on is totally something different. Exactly what i was asking earlier.
    • SOLVED Help with SQL query
      IT Discussion • database mysql mariadb sql • • thegillion  

      24
      1
      Votes
      24
      Posts
      3286
      Views

      @scottalanmiller said in Help with SQL query: @BRRABill said in Help with SQL query: @scottalanmiller said in Help with SQL query: If you expect this product to explode Possible poor choice of words. Or... intentional. Knowing you, intentional.
    • Need to Extract PostgreSQL Schema for Clean Database
      IT Discussion • database sql postgresql • • StrongBad  

      5
      1
      Votes
      5
      Posts
      1551
      Views

      @StrongBad said in Need to Extract PostgreSQL Schema for Clean Database: This is what I get... postgres@~ 2$ pg_dump -p 5023 -n portaltest pg_dump: specified schema "portaltest" does not exist http://orig01.deviantart.net/eb26/f/2011/145/e/2/portal_2___error_by_half_dude-d3h8bys.jpg
    • Veeam backup VmWare & Linux
      IT Discussion • linux windows veeam mysql sharepoint sql • • Ambarishrh  

      18
      0
      Votes
      18
      Posts
      4483
      Views

      I am currently working on the storage planning for Veeam and found this site http://rps.dewin.me/
    • Periscope for SQL Reports
      IT Discussion • database sql reports periscope • • scottalanmiller  

      7
      2
      Votes
      7
      Posts
      1610
      Views

      Holy crap, yeah, that's not useful at all. No wonder they do not publish the prices anywhere. The old rule of thumb applies: if the price isn't public, the price isn't good.
    • ?

      SQL Management learning
      IT Discussion • sql video learn book • • A Former User  

      6
      1
      Votes
      6
      Posts
      1710
      Views

      C

      I'm a fan of Brent Ozar http://www.brentozar.com/blog/ though my knowledge of SQL Server is very limited. He sounds like he knows what he's talking about but I wouldn't know if he does or not. I haven't paid for any of their training videos, but I've watched a few of the free ones.
    • Can I Join You?
      Water Closet • time waster sql • • mlnews  

      4
      4
      Votes
      4
      Posts
      2994
      Views

      ** Sorry this parser doesn't support joins
    • A

      SQL Client for Mac
      Developer Discussion • mac sql • • amytabor  

      6
      1
      Votes
      6
      Posts
      2161
      Views

      ?

      Postgres has one as well http://phppgadmin.sourceforge.net/doku.php
    • Google BigQuery
      IT Discussion • google database sql ruby on rails programing • • Kyle  

      2
      0
      Votes
      2
      Posts
      1176
      Views

      Kinda like a hosted Hadoop cluster.
    • SQL Question - Removing Part Of A Field
      IT Discussion • sql server sql lightswitch t-sql • • garak0410  

      18
      0
      Votes
      18
      Posts
      3136
      Views

      @NetworkNerd said: If I understand correctly, that code snippet is only for a validation that will be run against the Phone1 field. Are you just trying to throw up a validation error on a web page or within an application if a proper phone number is not entered in the PHONE1 field? He wants to extract out the first 10 digits of the PHONE1 field and present them to the application / page as the phone number so that the native regional formatting of 10 digit TN handles it correctly.