I have just started full time in IT and have been asked to upgrade software, servers and databases on a Sunday so that there are no disruptions to the global business.

I have talked to HR about this and they have told me that they are only willing to swap one of my weekdays for this Sunday with no additional compensation. Obviously, I feel that a Friday is not Equitable to a Sunday as my partner, friends and family work on Fridays and that I would be at a loss.

In Queensland, am I entitled to Penalty Rates by law? If so how much (2x)? And will I look stupid for asking for penalty rates or more fair compensation?

Do you guys have any advice of what I should be asking HR? Any advice is appreciated.

We are using SSRS 2016. We have several reports that use MySQL as the data source. We would like to create some data-driven subscriptions for these MySQL reports, but they don't appear to work. After I select the MySQL shared data source, enter my query, and click the Validate query button, I get a "Validation successful" message, but no dataset fields get returned. We have reports that work on this currently, so I know SSRS can communicate with MySQL without issue. I also tried adding a custom data source for MySQL to no avail. Is this just not supported? Thanks.

Hi,

I have a database which needs to scale-up before a pipeline run and scale-down when it's done. I'm unsure what would be a best practice?

Currently I'm doing it via Azure Automation Powershell scripts, which are exposed via an API through Logic Apps. It works, I like this approach because the person running the pipeline does not need any Azure access rights. What I don't like is that the Logic App times out after 2 min which is less than the time to scale up the database, which means the person running it does not know when it's done.

What would be my other options? What would be the best practice?

I'm new to Azure...

Flexible Server in Azure Database for PostgreSQL is a significant improvement over Azure Database for PostgreSQL single server.

It seems to be a default service for any PostgreSQL with Azure.

For example, Flexible Server supports version 13, while a single server is still on 11. There are a bunch of other improvements, like latency, etc, you can see it here:

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-is-flexible-server-in-azure-database-for-postgresql/ba-p/1741346

However, it is still in Public Preview.

Public Previews are not recommended for production.

I',m developing an application that should go live in a month or so.

Can I use Flexible Server now?

If I develop everything with a single server, and then the flexible server goes out of the public preview, I'm afraid I have to migrate everything manually.

If I go with the flexible server now, by the time my app goes live, it might still be in preview.

And I would really like to go with PG13 instead of PG11, and take advantage of other features as well...

What should I do?

Thanks

I have spent all day trying to figured out why I can not create a link server to bring a postgres database into microsoft sql server. The error above is what I am getting

The odbc driver test connection test if find.

I don't know if it has to with the fact that we are accessing via windows authentication to our sql server

I tried enabling the MSDASQL in progress option as I read this might do the job, but still nothing

Any support is highly appreciate it.

https://preview.redd.it/1h2fcrq90v671.png?width=986&format=png&auto=webp&s=c358f1adbbeec25d9f871aefa21b4d06a23a53fa

I have pulled data from a MYSQL DB into Excel using the ODBC driver after setting up a DSN. I disabled transactions, but the person who uses the DB to maintain a website is saying that the specific table that is being pulled from is being altered in ways that are bad for the website.

There are data manipulations being done and saved in the Excel file. I recognise that Excel is not the best way to manage the data from the MySQL server, but it's been set up for someone senior in the company who is not not comfortable with anything other than Excel, including the website that displays the same information as in Excel.

My question is: does altering the Excel file and saving it send changes to the server, even when transactions are disabled? If not, how would I prevent changes being made server-side?

Edit: Only one user is allowed by the DB host

Is the database stored within the public_html folder.

I’ve requested my hosting company restore my public_html folder to a previous backup but i’m now curious if this will or will not include the database files.

I’m not technically minded so a simple answer could be appreciated.

Thanks in advance.

Hello C++ Community!

I hope everyone is having a great week!!

I'm working on a hobby project that's written in C++ and some Perl. Our storage engine is powered by RocksDB.

The project is a NoSQL database called Beryl. I'm dedicating my free time for this, and is just to learn more about databases, which I happen to enjoy a lot!

The DB only works in Linux at the time..

I'd love to get some feedback, even if you're a database amateur like me. Also, feel free to open an issue or DM me. I'm open to collaborations!!

Docs: https://docs.beryl.dev/

Github: https://github.com/beryldb/beryldb

Client (for terminals): https://github.com/beryldb/beryldb-cli

We are using log shipping for years now to sync with a remote standby database... Is there any other ways now to do better with SQL engine?

I am stuck with the CI process for the database (MS SQLServer), I am using the AWS devops services so that the process there CI CD of our projects, I did it successfully on the Azure platform, but when I try to follow the same on the AWS platform, I can reach the process for the front-end and the middle Ware, but when it comes to the part of the database that I can not to achieve it, please, someone gives the best advice.

Do you know someone who can respond?

I need to clone large remote DBs (sizes between 250gb and 3tb) to one or more VMs often. Replication is not an option since the process is:

- clone DB to local VM

- make changes and run some tests

- add data and do more tests

- delete / empty DB

- repeat

Currently I'm using xtrabackup. But the decompression step is taking 30-40 mins for a DB with about 260 GB in size (90GB compressed size). System used: 8 core, 32gb ram, ssd. Command used for decompression:

xtrabackup --decompress --remove-original --compress-threads=24 --parallel=24 --target-dir=$LOCAL_PATH

Are there any other methods to do this? Or are there any options I can pass to xtrabackup to speed this up?

Recently we decided to downgrade our windows server from 2019 to 2016 for unrelated issues to the one I am reporting below.. The downgrade actually involved spinning up a new server and having the windows 2016 OS installed on it. We then migrated our data using Amazon S3 to the new server.

We raise a lot of letters, which are generated server side and saved as PDFs in container fields.

Since moving servers, all the PDFs we generate are now specially different and not laid out in the same way they used to be. The layout differs so much that lots of the text is horizontally cut off and now does not fit on the page.

We also noticed that although we have removed all the margins from each layout, the margins have been turned back on and set to default.

I reported this to FileMaker, who assure me that somehow I have edited all 200 layouts and caused the problem myself, despite admitting it is impossible to bulk edit layouts using FileMaker Pro.

As it stands they suggest I now manually adjust all 200 layouts I need to save as PDF so that they fit on the page (like I haven't already done that when I designed the system the first time back in 2016).

We are using FileMaker server 19 on windows server 2016 (having downgraded from widows server 2019).

Im not an expert at this, but am looking to avoid having to change 200 layouts and wondered if anyone had experienced this or if they had ay idea what could cause it and perhaps what to try to resolve it.

I have attached a before and after of a layout, one showing how the pdf is created in windows server 2019 and the other how it is not generated in windows server 2016. Personal information has been redacted from the PDF, but you get the idea with the layout. Also, the actual layout when viewed inside filemaker does not show this and looks perfect on screen, it only happens once the pdf is generated serve side and interred into a container field.

Any help would be brilliant!

We had to restore our SCCM server from tape backup. It appears to have been successful (the OS works anyway...)

We were able to restore the database but the actual database server had to be rebuilt from scratch. I am now unable to connect to SCCM with the management console. I have attempted to "Perform site maintenance or reset this site" / "Reset site with no configuration changes " and "Modify SQL Server configuration" from add/remove but I receive an error

"VIEW SERVER STATE permission was denied on object 'server', database 'master. The user does not have permission to perform this action.

The ConfigMgrSetup.log also has several errors relating to not having permission to perform actions.

I am guessing that there are some permissions that need to be applied to the SQL server that will allow SCCM to work with the database but I am not sure what those are. I did not set up our environment so I am kind of having to reverse-engineer this whole thing.

Any tips or pointers to documentation would be appreciated.

Thank you!!

Hi there! I'm really new to AWS, and I was wondering if there is any way to migrate an existent MSSQL Server RDS database system to Postgres.

Is this something that can -or should- be done using DMS? If so, any specific way to do it? If not, what tool or process should I take a look at?

Many thanks for any hint, advice, or suggestion you may have!

EDIT: I'm sorry, I left out a bunch of information in the original post. I can take care of the application code-side of the migration process. What I do not know how to do, is how to migrate what is already live in an RDS MSSQL Server database to a new RDS instance of a Postgres database.

The application is a .NET 5 API that uses Code First for building the database.

We are experiencing an issue with a simple .NET Core (3.1) console app connected to a SQL Server database and deployed in a container on AWS Fargate (ECS). SQL Server is a mirrored setup (principal/mirror, with a witness to allow for automatic failover).

The problem occurs when we (manually) failover the database; observing SQL Server Profiler, the SQL client appears to continue to repeatedly attempt to connect with the old principal (now the mirror and in restoring mode). There is no attempt to connect to the new principal post-failover. We are using System.Data.SqlClient.dll as the client. The following exception is logged:

System.Exception Cannot connect to SQL Server Browser. Ensure SQL Server Browser has been started.

• at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown ---

Despite the error suggesting that SQL Server Browser is not started (we are connecting to a named instance), we have confirmed that the service is started. We have also created a temporary security group to allow all traffic (all protocols/ports, e.g. UDP port 1434 for SQL browsing) between application and database, so there is no traffic being blocked at any point. When we manually fail back to the original principal (i.e. the server specified as 'data source' in the connection string), the application can successfully connect again.

The strange thing is that we have run the exact same application in the following A

Any feedback is welcome.

https://lapisai.com/

Update 04-12-2021_2143: Sale Pending.

Update 04-14-2021_1520: Sold

---------------------------------------------------------------------------------------------------

DISCLAIMER: I AM NOT SHIPPING THIS BEAST, YOU HAVE TO COME GET IT IN PERSON. IT IS HEAVY AND DETERMINED TO INJURE ME.

LOCATION: Northern Virginia, 20190.

Price is $100 with some conditions, see below.

Seriously, no way am I boxing this sucker up and shipping it, please don't ask me to.

As far as I can tell, it is this server described here: https://dogemicrosystems.ca/pub/Sun/System_Handbook/Sun_syshbk_V4.1/Systems/ODA/component.system_controller.html

And all the options shown in this picture of the back: https://dogemicrosystems.ca/pub/Sun/System_Handbook/Sun_syshbk_V4.1/Systems/ODA/component.rear.html

Photos: https://imgur.com/a/9r8iHMD (sorry, out of order)

TL;DR:

• 2x Intel 6-Core Xeon X5675 per blade.
• 20x Seagate Cheetah 600gb 15k rpm SAS drives
• 4x STEC Sun Oracle 73gb SAS SSD drives
• 4x Seagate Constellation 500gb 7200rpm SATA OS drives in the back (2 per blade).
• Each blade has 12x 8gb Samsung ddr3.
• There are 4gb USB drives, which I assume could have rescue software one them, plugged into each blade's motherboard, could likely be used to boot ESXI or Proxmox.
• Quad 1Gb Ethernet per blade, 10Gb Ethernet per blade
• Everything powers up and appears to be working, was able to boot from a flash drive on both blades.
• From what I can tell. all of the drives show less than 13500 hours of on time and less than 150 power toggles (several of those by me). So it appears it was barely used for whatever reason. Three of the drives (15k 600gb), in slots 0, 8, 16 (see photo of layout) are showing smartctl hard drive failure or imminent failure, but appear to function otherwise). Let me know if you want the "smartctl -a /dev/sd?" outputs.
• The outside of the case is slightly scuffed, but it has all the parts. The rails appear intact and I was able to put them in a rack at some point, but never tried to rack the server on them (too heavy to lift). They are missing 1-2 (?) small lock screws (not needed and not special, just a screw), and one latch/end of a rail slightly bent but still works.

I am trying to free up

I have read the rules

I have been aware of Shining Nikki since release but never really paid attention to it before the English Sever announcement. I would really like to know what events/outfits already exist so I know what to save for.

Edit2: SOLVED. Thank you to /u/xodusprime for getting me started in the right direction.

1. Initiating server must be DELEGATED for Kerberos Auth in AD! Reboot after setting this!
2. Use Type "SQL Server", not "Other Data Source".

NO, IT WASN'T DNS.

Edit: Almost There! When I select "SQL Server", rather than the OLE DB Provider, I get an "Access Denied" result UNLESS I specify the 'sa' account on the target server. However, it does display everything that it should. So... it's a role somewhere. That is a different problem than my post title, so I'll not continue to update this article until I get the problem fixed. Unless I go down the route of adjusting all the OLE DB parameters, which, I will hopefully figure that out & get it from here. If not, well.. you may see me back again!

Greetings! Running into an odd problem here. I'll try to provide as much info as possible.

I'm trying to create linked servers so that users can run queries on server A, to compare databases on Servers B and C. All servers are in the same AD, and on the same Subnet. They can ping & see each other in net view. The problem is, when I create the linked server on server A, the wizard completes with no errors, but then when I browse into server B under "Server Objects > Linked Servers > ServerB", I see the local databases!

Yes, I googled it; but the problem does not appear to be very common and only a couple of articles popped up. One mentioned dns. I created the linked server using the IP address and got the same issue. So.. here I am! :D

The connection was made using the "Microsoft OLE DB Provider for SQL Server". The security for the connection is "Be made using the login's current security context". I am sysadmin on all involved servers.

Server A has SQL 2019. The others have SQL 2012.

Any ideas, Gurus?

I can attach an obfuscated screen shot if necessary.

Quickbooks database server is ridiculously slow inside a VM. Works completely fine on some random old workstation just booting off a drive. I’ve tried everything under the sun and frankly this is my last ditch effort before nearly throwing myself off a cliff. Anyone have any ideas?

What is the difference between the Azure PostgreSQL server and flexible server? Because a create the PostgreSQL server but I noticed that it can't turn off but the flexible server it can turn off, so can I use the flexible server and it would work like the other one ?