The Heap™ – Consultancy ©®

« first day (2849 days earlier) ← previous day next day → last day (2016 days later) »

ypercubeᵀᴹ

7:06 AM

@A_V what was the bug?

1 hour later…

Colin 't Hart

8:09 AM

Morning

Philᵀᴹ

Apple fixed a bug I reported in under a week. I am quite impressed for once. I always assumed their bug reporter was a big black hole

Colin 't Hart

sqlite.org/codeofconduct.html

@Philᵀᴹ Wow! Which bug?

Philᵀᴹ

@Colin'tHart I found an unhappy SSL certificate. I guess security problems like that are actually quite important :P

Colin 't Hart

(Y)

ypercubeᵀᴹ

8:26 AM

@Colin'tHart holy shit.

ConcernedOfTunbridgeWells

9:02 AM

@Colin'tHart I wonder if someone has shares in a popcorn manufacturer.

Marian

9:39 AM

@Colin'tHart wow :)

2 hours later…

hot2use

11:30 AM

Good afternoon

ConcernedOfTunbridgeWells

Good afternoon

A_V

12:19 PM

@ypercubeᵀᴹ For some reason temp tables don't play well with their JSON_TABLE function. It's unclear why, which is why I think it's a bug.

A_V

12:32 PM

Q: Mysql temp table insert from json can't handle null values

The MySql-8 JSON_TABLE function allows you to handle JSON data as if it was a table. I'm trying to use it to populate a temporary table using the generated table but I believe I'm hitting a bug. When a null value is inserted into an INT NULL column, the following error is thrown : Invalid JSON ...

@Colin'tHart Well, I think I'll ditch mysql for MySqlite then

hot2use

1:19 PM

Are there any SQL Server Analysis Services (SSAS) experts in here?

Tom V

@hot2use depends on the question

hot2use

Q: Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (SSRS) will only pick up requests on the instance-specific IP, in order to allow the SQL Server Brow...

sql-server sql-server-2014 sql-server-2016 configuration ssas

Tom V

Hmm, it's a long read I'll look into it later today

hot2use

Thanks.

Tom V

@hot2use cisco.com/c/en/us/support/docs/conferencing/…

doesn't that work?

just add the port number in the client

I would have to test on my vm

hot2use

1:34 PM

That's only half the job.

All connections would then be via 10.2.0.1 (server IP) and some port I define for the Analysis services. However, I'd prefer the connections be made via the instance-specific IP address. This would remove traffic from the server's IP address. The SQL Server instances are already running without the Windows Server's IP address. It would also allow for transportabiity of the IP address to a different server. :-)

The CNAME servername-ins01 could then be transferred to a different server, should we require better hardware.

hot2use

1:57 PM

^--- better: the IP address and the instance(s) of that address could be transferred to a different server.

Tom V

Hmm, I'm not good enough on the networking stuff to help you with that

maybe @ConcernedOfTunbridgeWells

@hot2use I don't see what's so special about CNAME in this situation

Ah ok I get it now

ConcernedOfTunbridgeWells

2:13 PM

@TomV I'd have considered investing in popcorn futures if I'd known that was coming.

Marian

@hot2use I call "bullshit" regarding that security consideration

never had a production env where this service is stopped due to "security issues"

hot2use

2:28 PM

98% of our SQL Server installations are up and running without the SQL Server Browser service running. We don't require the service, because each SQL Server service picks up the direct calls from the clients or application servers.

We also don't have to tell the users to connect to

servername\HR_Instance' , because they don't need to know that it is an **HR** instance. They only know it is the (CNAME)

servername-ins01` SQL Server.

Tom V

I think connecting the alias to the correct port is going to be difficult

hot2use

That's why we would like to keep it that way. The users would connect to the servername-ins01 Analysis Services instance, and shouldn't be required to know that it is in fact the servername\important_instance SQL Server. :-)

Tom V

yes but I don't know of anything like the aliasses in the sql client for SSAS

You probably don't want them to connecto to servername-inst1:4567 either

hot2use

Right :-)

Put differently: If I install Analysis Services on that one Windows Server (servername) for all instances, then I would have to configure individual rules on the firewall each with different ports.

Tom V

Could you get away with an SRV record?

hot2use

2:35 PM

If I can get AS to run on a specific IP (well the instance-specific SQL Server IP) on port 2382/2383 then I can simplify the firewall configuration, by standardizing the AS port.

@TomV I don't know the specifics of the SRV record.

Had a quick glance. Probably not, as the AS will still start up using the IP address of the Windows Server and not the SQL Server instance-specific IP address.

In a normal private sector environment, I wouldn't care Jack. Being it a government environment, I do have to firewall rules and the likes.

@JackDouglas No offence meant

Jack Douglas

ha :)

I think I've got Oracle 18c XE working

hot2use

@Marian the quote in my question is from the official microsoft documentation.

Jack Douglas

so nothing can offend me at the moment ;)

hot2use

:-)

.. no it isn't

Jack Douglas

what's your favourite new feature since 11.2?

hot2use

2:43 PM

That's a horrible question to ask at the moment, because we had to switch from IBM AIX running Oracle 11.2, to Windows Server 2016 running Oracle 12.2.

Marian

@hot2use saw that, I wasn't questioning your quote, but their content

hot2use

Nothing but issues with 12c on W1nD0ze.

I don't like the new qopatch.bat procedure that kicks off in the middle of the night and if you have a multi-instance environment, produces up to 4'000 to 6'000 processes consuming all your Windows resources. (BTW, I can provide a fix)

Jack Douglas

I haven't run Oracle on Windows for years

hot2use

There is a fix for the "*nix / Oracle" environments.

@JackDouglas lucky you.

Jack Douglas

what's the reason to do so?

hot2use

2:53 PM

MKB

Management Knew Better

@Marian Ah, ok. Thanks for the feedback.

I just don't want to have to have firewall rules like:

10.2.0.1:2353 <-> 10.2.0.213:ANY
10.2.0.1:2354 <-> 10.2.0.214:ANY
10.2.0.1:2355 <-> 10.2.0.215:ANY
10.2.0.1:2356 <-> 10.2.0.216:ANY
...

I'd prefer:

10.1.0.1:SQLAS <-> 10.2.0.213:ANY
10.1.0.2:SQLAS <-> 10.2.0.214:ANY
10.1.0.3:SQLAS <-> 10.2.0.215:ANY
10.1.0.4:SQLAS <-> 10.2.0.216:ANY
...

Where SQLAS then be 2383 or 2382

Marian

mssqltips.com/sqlservertip/1946/…

"If there are more than one instances running on the same machine, in that case either you have to start SQL Server Browser service or provide the port number along with IP (or server name) and instance name, to access any other instance than default.
If SQL Server Browser service is stopped and IP along with port number is not provided then connection will be refused.
If SQL Server instance is configured using dynamic ports then browser service is required to connect to correct port number."

hot2use

3:14 PM

@Marian Not quite relevant in my case, as I have an environment with one Windows Server containing 10 SQL Server instances all running on dedicated IP addresses, and I don't have to specify the port when connecting, because each instances has been configured to run on a dedicated IP with the standard 1433 port as per my post.

I have a working multi-instance SQL Server environment without the the SQL Server Browser service running.

The service only recently started, because I installed SQL Server Analysis Services for one of those instances.

Tom V

3:35 PM

@hot2use To be fair, with SSAS memory management you are unable to set hard limits like you can with the database engine, so I'm not sure that's a very good idea

I mean you can set a hard limit but unlike SQL Server SSAS will just start killing sessions in a rather ungrateful way

2 hours later…

Jack Douglas

5:27 PM

Polymorphic table functions on Oracle 18c: dbfiddle.uk/… (courtesy of lad2025)

Marian

6:16 PM

@hot2use that is correct, one of my prod clusters is configured exactly this way

but it doesn't have SSAS enabled

the boxes with SSAS enabled and in use all have the Browser service running

"Only one TCP port can be used by an Analysis Services instance. On computers having multiple network cards or multiple IP addresses, Analysis Services listens on one TCP port for all IP addresses assigned or aliased to the computer."

"If you have specific multi-port requirements, consider configuring Analysis Services for HTTP access. You can then set up multiple HTTP endpoints on whatever ports you choose. See Configure HTTP Access to Analysis Services on Internet Information Services (IIS) 8.0."

docs.microsoft.com/en-us/sql/analysis-services/instances/…

does this look useful?

hot2use

6:37 PM

@Marian I‘ll have a look. Thanks.

« first day (2849 days earlier) ← previous day next day → last day (2016 days later) »

all rooms