ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. Tags
    3. database
    Log in to post
    • All categories
    • OksanaO

      Stop Copying Data You Don’t Need To

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind virtual machine snapshot database
      1
      0 Votes
      1 Posts
      227 Views
      No one has replied
    • scottalanmillerS

      Get Alert Whenever There is MS SQL Server Access

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion ms sql server database security
      6
      0 Votes
      6 Posts
      854 Views
      JaredBuschJ

      @scottalanmiller said in Get Alert Whenever There is MS SQL Server Access:

      It's a production database so there should be an email when the application connects and absolutely no user should ever, ever, ever be able to log in unless it's an admin doing an emergency backup and/or restore (likely alerts would be off during a restore.)

      I cannot imagine a MS SQL Server based client-server application that does not make a billion DB calls all day long. So you will have to exclude that system user from being audited.

      @scottalanmiller said in Get Alert Whenever There is MS SQL Server Access:

      There's no user ever authorized to just connect.

      The application user is always connecting. Repeatedly.

    • scottalanmillerS

      SAMIT: Why You Can't Share QuickBooks on Google Drive for Mutiuser

      Watching Ignoring Scheduled Pinned Locked Moved Self Promotion google drive nextcloud dropbox quickbooks database storage backup sharing samit youtube
      5
      1 Votes
      5 Posts
      886 Views
      scottalanmillerS

      @syko24 said in SAMIT: Why You Can't Share QuickBooks on Google Drive for Mutiuser:

      @scottalanmiller said in SAMIT: Why You Can't Share QuickBooks on Google Drive for Mutiuser:

      @syko24 said in SAMIT: Why You Can't Share QuickBooks on Google Drive for Mutiuser:

      There is a product out there called QBox that allows you to lock and sync the file with multiple locations. The downside is that remote users can only access the file when the local users have closed out of QuickBooks. Kind of a neat product but again not ideal when you need multiuser access all the time. The best solution in my opinion is an RDS server with the QuickBooks data file stored on the RDS for best performance.

      As the QuickBooks desktop products seem to be coming closer and closer to an end, I agree that the online version is likely the best way to go. Part of the problem is that users have been using the desktop version for so long that the online version becomes very foreign to them and most want to return back to the desktop version.

      https://www.coraltreetech.com/how-qbox-works

      Yeah, that's not multiuser but rather "rapidly changing and coordinated single user". Could be a useful solution for some, though. You can do this with most products. NextCloud for example.

      From the use case I've seen that is correct on being a single user product. I did watch the video on the link I posted and it does look like you can still do multiuser as long as the users are all on the same network. The remote user can only access once all the local users are out of the file and it has done it's sync. The file locking is automatic as well which is nice. It basically prevents the outside user from accidently overwriting your changes.

      Sure, you can always bypass the sync and do local multiuser, but the humans have to manage that.

    • scottalanmillerS

      SMBITJournal: Why QuickBooks Cannot Be Used with Google Drive for Multiple Users

      Watching Ignoring Scheduled Pinned Locked Moved Self Promotion quickbooks icloud google drive storage database
      2
      1 Votes
      2 Posts
      450 Views
      dbeatoD

      @scottalanmiller It makes sense they can't because of the nature of their static Database.

    • MC_BolM

      Avimark: Error Attempt to read a record from XXXXXX.P2$ that doesn´t exist

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion vet covetrus avimark database veterinary veterinarian
      2
      1 Votes
      2 Posts
      598 Views
      scottalanmillerS

      Thanks, seen this a few times recently.

    • scottalanmillerS

      How to Backup Patterson Dental EagleSoft Software

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion eaglesoft backup database
      12
      3 Votes
      12 Posts
      2k Views
      scottalanmillerS

      @Matthew-Grieve said in How to Backup Patterson Dental EagleSoft Software:

      https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-backup-dbs-5615940.html

      SQL Anywhere Volume Shadow Copy Service (VSS)
      SQL Anywhere is compatible with the Microsoft Volume Shadow Copy Service (VSS). You can use VSS to create point-in-time snapshots of entire disk volumes or volume sets and to make copies of files that are open for exclusive use by applications such as the SQL Anywhere database server. VSS is supported on 32-bit Windows XP operating systems and on 32-bit and 64-bit editions of Windows 2003 and later operating systems, including Windows Vista.

      By default, all SQL Anywhere databases can use the VSS service for backups if the SQL Anywhere VSS writer (dbvss12.exe) is running. You can use VSS without the SQL Anywhere VSS writer to back up databases. However, you might need to use the full SQL Anywhere recovery procedures to restore those databases. To prevent a database server from participating in the VSS service, include -vss- when starting the database server. Alternatively, you can use the Service utility (dbsvc) for Windows to specify when the VSS service is started.

      How VSS works with SQL Anywhere:

      Your backup application sends a command to VSS to take a snapshot.

      VSS issues an identify command to the SQL Anywhere VSS writer (dbvss12.exe).

      VSS issues a prepare to snapshot command to suspend all transactions and write all modified pages to disk on all databases on all database servers. If transactions are not suspended on a database within 10 seconds, the snapshot might contain uncommitted transactions and full recovery may be necessary.

      VSS issues a freeze command to checkpoint and then suspend all activity on all databases on all database servers. Each SQL Anywhere database server waits a maximum of 60 seconds for all databases to suspend all activity. Typically, this process takes a few seconds.

      VSS issues a thaw command to the SQL Anywhere VSS writer to resume all transactions on all databases on all database servers.

      In rare circumstances, SQL Anywhere might be unable to suspend transactions or complete a checkpoint within the maximum time allowed by VSS. If this occurs, you must use the transaction log file and the full recovery process to recover the backed up database.

      We use StorageCraft ShadowProtect with ImageManager to take hourly incrementals of our clients server volumes. Never had any issues.

      That's true when you have SQL Anywhere running as a service. But when embedded, there is nowhere for the VSS to link against. Are you sure that this process will work with EagleSoft and their implementation of SQL Anywhere? I know that a full blown SQL Anywhere can do it. But that's not the issue here.

    • scottalanmillerS

      What Database Does Patterson EagleSoft Use?

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion database eaglesoft sybase sap sql anywhere
      1
      1 Votes
      1 Posts
      359 Views
      No one has replied
    • scottalanmillerS

      MS SQL Server Error: No Process is on the other end of the pipe

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion database ms sql server
      3
      2 Votes
      3 Posts
      1k Views
      ITivan80I

      Thank you for the heads up @scottalanmiller

    • scottalanmillerS

      Database Decision Chart

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion rdbms database nosql
      1
      3 Votes
      1 Posts
      431 Views
      No one has replied
    • scottalanmillerS

      Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sql server 2012 sql server 2014 sql server 2016 sql server 2017 sql server 2019 ubuntu linux database t-sql
      3
      2 Votes
      3 Posts
      927 Views
      scottalanmillerS

      @jaredbusch said in Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD:

      @scottalanmiller I have not had to do that before with a normal backup to a .bak and then restore. Not some an place move like it seems you are doing.

      Happens if going to a space with a different storage layout. If you are coming from Linux you are probably fine. But Windows injects the drive letter into the path (obviously) and so going from one machine to another that doesn't keep identical storage path names causes the issue.

    • OksanaO

      How to Backup Microsoft 365 with Rubrik Polaris

      Watching Ignoring Scheduled Pinned Locked Moved Starwind starwind saas backup database microsoft 365 cloud
      1
      0 Votes
      1 Posts
      562 Views
      No one has replied
    • EddieJenningsE

      Multiple Virtual Disks and Application Performance

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion virtualization storage best practices performance tuning configuration manager database
      24
      0 Votes
      24 Posts
      2k Views
      EddieJenningsE

      @scottalanmiller said in Multiple Virtual Disks and Application Performance:

      Remember.... just because you are virtual does not imply that your storage is virtual, nor does virtual storage imply that the storage will be shared between workloads or VMs. None of that is implied or suggested in going virtual. You still maintain all proper storage management decision making when virtual as you did physical. You don't get to give any of that up.

      In restrospect, I probably ought not have included the System Center Dude stuff in the discussion, since it seemed to just cause confusion about what I was curious.

      You still maintain all proper storage management decision making when virtual as you did physical.

      I believe this is the greatest takeaway from the discussion. Regardless if the environment is like the one I'm in where ultimately one physical storage device is hosting all of the virtual storage within the VMs.

    • R

      Error After Firebird 2.5.9 Update

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion firebird database
      14
      1 Votes
      14 Posts
      2k Views
      scottalanmillerS

      @Romualadas said in Error After Firebird 2.5.9 Update:

      @scottalanmiller
      Tried your link. Results:
      yum install /tmp/FirebirdSS-2.5.9.rpm
      Loaded plugins: fastestmirror
      Examining /tmp/FirebirdSS-2.5.9.rpm: FirebirdSS-2.5.9.27139-0.amd64
      Cannot add package /tmp/FirebirdSS-2.5.9.rpm to transaction. Not a compatible architecture: amd64
      Error: Nothing to do
      Server architecture:
      Kernel and CPU Linux 3.10.0-1062.18.1.el7.x86_64 on x86_64

      Looks like their packages are bad at this point. You definitely have the right, matching architecture there. Seems that they are having a lot of problems these days. It's such a niche product, I'd be super wary of every using it in production or any software the depends on it. Using it as an option, sure, but requiring it I'd consider a non-starter. Absolutely no one supports it.

    • scottalanmillerS

      ERROR 1366 When Important MySQL Database for WordPress

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion wordpress mysql mariadb sql database rdbms
      2
      1 Votes
      2 Posts
      632 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.

    • scottalanmillerS

      How to Rename a Column in SQLite Database

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sqlite sqlite3 sql database
      10
      1 Votes
      10 Posts
      1k Views
      scottalanmillerS

      @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.

    • scottalanmillerS

      Intro to NoSQL from MangoCon 2019

      Watching Ignoring Scheduled Pinned Locked Moved MangoCon mangocon 2019 nosql nosql database database youtube scott alan miller
      3
      3 Votes
      3 Posts
      791 Views
      Emad RE

      @scottalanmiller

      I like your 53 mins intros, but that said you cover and reach all the important parts. I wonder what will be deep dive session how long will that video be.

    • scottalanmillerS

      UREs Strike InnoDB on MySQL

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion ure database storage innodb mysql centos centos 6 linux relational database rdbms
      9
      1 Votes
      9 Posts
      1k Views
      scottalanmillerS

      @Obsolesce said in UREs Strike InnoDB on MySQL:

      @scottalanmiller said in UREs Strike InnoDB on MySQL:

      @Pete-S said in UREs Strike InnoDB on MySQL:

      Step one is to remove the drives and clone them with dd or recovery tool to a new drive.
      You could probably recover 99.9% of the data - if you want.

      As you can guess from all of their previous issues, they don't want to pay for any recovery, they just want it magically fixed for free. They don't own any storage onto which to clone it, either.

      Then what is the point of any of it? It appears to have zero value to the business.

      I said that to them.

    • scottalanmillerS

      PATH Error with TimeScaleDB-Tune on Fedora 30

      Watching Ignoring Scheduled Pinned Locked Moved Solved IT Discussion timescaledb postgresql postgresql 11 fedora fedora 30 linux database nosql rdbms
      15
      0 Votes
      15 Posts
      2k Views
      scottalanmillerS

      @dafyre said in PATH Error with TimeScaleDB-Tune on Fedora 30:

      then why are you even using it?

      Capacity Planning, for example.

    • wrx7mW

      Zabbix on CentOS7 - MariaDB or PostgreSQL?

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion mariadb postgresql zabbix centos7 database db linux linux server monitoring
      7
      1 Votes
      7 Posts
      972 Views
      dafyreD

      I've done both. I tend to like MariaDB / MySQL better because that is what I'm more comfy with.

    • scottalanmillerS

      MariaDB Restore Needs Binary Mode for ASCII \0 Error

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion mysql mariadb database
      1
      0 Votes
      1 Posts
      771 Views
      No one has replied
    • 1
    • 2
    • 3
    • 4
    • 5
    • 1 / 5