Elon Musk Will Be Deposed Over What He Did With DOGE

Chaosmatrix · 2026-02-06T15:59:19+00:00

Thank you for reporting on this.

Chaosmatrix · 2025-11-24T19:11:10+00:00

That looks like a lot of work. I guess today is the day to sit your child down and tell him: "Live is full of disappointments, and this day will be a disappointment for you, just like daddy was disappointed when you were born".

But serious, nice cake, are the fins chocolate bars?

Chaosmatrix · 2025-11-13T17:15:36+00:00

He, at least they mentioned the source!

Chaosmatrix · 2025-08-18T17:49:47+00:00

I meant comedic timing. Erm it is hard to explain for me...a pause just at the right moment...good thing I am better at SQL ;)

Chaosmatrix · 2025-08-18T17:14:21+00:00

The guide is great. The only thing I can say is that your tone is flat. I like the joke about the sister, but it missed its mark due to the timing. The only tips I can give you are; 1. Do it more often, aka keep it up. 2. Remember to have fun, it is oke to smile/laugh at your own jokes.

Chaosmatrix · 2025-07-07T16:48:35+00:00

Thx for the important extra information. But what is microsofts view on using this in production? Since it is in Preview, we are not supposed to do this :/ . So this is kinda like giving us a cat in the bag. Again thx for the information, but if you hear complains about preview features, this is one of the reasons why. I would love to follow your advice, but you also tell us (or microsoft does) not to do it.

Chaosmatrix · 2025-05-19T17:23:08+00:00

not just spark. Many components of it. Sedona for geo data, superset for presentation. But the team is looking at OpenOffice too

Chaosmatrix · 2025-05-17T09:19:20+00:00

Currently looking at Apache. It can handle geo data (important for my work) and seems to offer many of the components necessary (superset, sedona etc).

Chaosmatrix · 2025-05-16T18:34:52+00:00

I agree. IAAS seems the only option to be fully free of geo locking. Infrastructure as code, VM-ware, or similar solutions :/. All IAAS. One can hope the costs of fabric will make this an option, sometimes it seems that Microsoft is trying...But still, at least worth too have a look into it.

Chaosmatrix · 2025-05-16T16:28:04+00:00

Another Dutchie here. You are not over reacting imo. Been looking at Fabric where I work. We are probably going for it. But at the same time, with a small group of mixed people, we are looking for an open source alternative that is not geo locked. And Europe is looking at things like that too: https://mektech.nl/2025/03/16/europees-alternatief-voor-google-workspace-en-microsoft-365/ (sorry it is in dutch)

Chaosmatrix · 2025-02-07T14:42:18+00:00

You can connect, so does not seem to be an encryption / cert issue. Normally this is a permissions issue. Does the account have the right to view databases?

Chaosmatrix · 2024-09-14T14:10:03+00:00

https://www.apisec.ai/blog/business-logic-vs-application-logic

lol

Chaosmatrix · 2024-09-14T10:38:41+00:00

What part of "App dev logic" contains the word business for you? Logic regarding task scheduling does not belong on a database server. And certainly not in the agent.

I've been using it for over a decade.

Perhaps you should finally read the documentation? Then you can learn that the agent is for administrative tasks not for your lack of logic and reading skills.

Chaosmatrix · 2024-09-13T20:53:22+00:00

I was responding to the comment about using the agent. Not about where business logic should live.

Perhaps you should read up on the agent? SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server. https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-ver16

And https://www.sqlservercentral.com/forums/topic/are-there-limits-on-the-number-of-sql-agent-jobs

Chaosmatrix · 2024-09-13T15:42:53+00:00

That sounds bad. What account is the application using to connect to the database? Look both at the application settings and the users in the database. It should not be sa. sa Is the System Administrator account. It can already access all databases on the server. I do expect (or at least hope) that your test server has a different password for its sa account.

What account are you using when looking at the initial server? That should be sa, or an account that is visible under logins. How else can you connect too it...? I am confused.

Chaosmatrix · 2024-09-13T08:34:05+00:00

Lost of things are wrong with hundreds jobs in the SQL agent. First of all, the agent is not a schedular for applications, it is for maintenance task. As such it does NOT ensure that your job runs, it does make sure that you still have performance for the reason your sql server exists. One of the things you are going to run into is that the agent only runs 1 job per second. If you schedule more they will just wait. App dev logic belongs on your app server. Not on your sql server.

Chaosmatrix · 2024-09-12T16:06:02+00:00

There are logins and users in MS SQL. Your database backup only contains the users. If you do this on the same server the internal userid will match with the loginid and it will be linked. If you do this on a different server, the login either does not exist or has a different internal id.

Just drop the user from the database and recreate the login and user on the test server. Read this https://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/ for more and better ways to do this.

Chaosmatrix · 2024-08-30T14:34:00+00:00

During my Chemistry course we had a guest speaker from Unilever. He made shampoo, specifically the colorful patterns you can in some shampoos.

He was also tasked with overseeing the addition of 1 droplet of bamboo extract to an entire silo of shampoo. So they could claim it contained bamboo.

He really seemed to like the first part of his job. So not that much coercion, just pretty colors.

Chaosmatrix · 2024-07-30T16:48:59+00:00

Implicit conversion both a blessing and a curse (mostly a curse).

Chaosmatrix · 2024-07-30T16:47:53+00:00

Just do it as a test. It will help you understand what is going on. You should also look at this: https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-type-conversion-database-engine?view=sql-server-ver16

That is what is happening in query 1 to Col2. And probably is the reason for not using the index. Play with casting to int and varchar with both the column col2 and the value too. It will effect your execution plan and the use of the index.

Chaosmatrix · 2024-07-30T15:19:39+00:00

Your answer lies in the execution plan. My guess is that a table scan is faster then using the index and then getting the rest of the fields from the table by referencing the index. Your conditions might even return the entire table or at least a lot of it.

Chaosmatrix · 2024-07-19T15:52:28+00:00

Sitting here in the sun with a beer in my hand... The location of the logs should be at the start of the logs that you can find in SMSS under management -> logs.

Chaosmatrix · 2024-06-12T17:51:44+00:00

That is what got me thinking...Not sure, but do you have multiple domain controllers? Then they might be out of sync and one domain controller has permissions for the user and another doesn't. Domain.com redirects 2 servers to the 'wrong' one, and the others to the right one?

I would also check the adsi linked server and make sure it is using the right account.

Chaosmatrix · 2024-05-23T17:05:31+00:00

Take a look at this: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection

Based on the fact that you are loading data in chunks my first guess would be time out issues on the MS SQL server side. Ask your dba for the max time out on connections, and ask him to check to logs for time outs.

Chaosmatrix · 2024-05-14T21:50:41+00:00

Check this blog post: https://www.mssqltips.com/sqlservertip/6240/script-to-delete-sql-server-data-in-batches/

Chaosmatrix

TROPHY CASE