Viewing 15 posts - 1 through 15 (of 269 total)
I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it would...
July 5, 2024 at 3:01 pm
There is no column ZZZZ in table a. The only column in table a is a
create table a (a int) would need to change to create table a (ZZZZ int)
June 11, 2024 at 4:24 pm
Now things in your post that mildly concern me are creating new tables. Are you creating new tables from the app? If so, that feels like it MAY...
May 23, 2024 at 5:38 pm
I prefer having two monitors. At home, I used a single 27 inch 4k monitor for a few years because that was all I had room for. I recently bought...
May 10, 2024 at 3:54 pm
I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I...
May 8, 2024 at 10:37 pm
Some older queries that worked fine in the past do not do well on SQL Server 2014 and up due to changes in the cardinality estimator. You can force a...
April 19, 2024 at 11:04 pm
This is SAP data. EBELN is the purchasing document number which in my experience is always 10 characters long, assuming the transfer to SQL Server doesn't strip the leading zeroes....
April 16, 2024 at 8:33 pm
I am fortunate to have worked my entire career in organizations where admitting to and owning your mistakes is respected, and failing to do so gets you fired. My first...
March 15, 2024 at 3:02 pm
Do you have an outbound firewall from where you are connecting? That has been the single most frequent reason for errors like this in my experience. The folks configuring the...
March 15, 2024 at 2:55 pm
I am late to this party, but am reminded of a company where I worked as a contractor in 1995. They ran their accounting on a System 36 they had...
March 5, 2024 at 4:58 pm
Another great book on early computing and testing is Turing's Cathedral by George Dyson. Highly recommended.
February 12, 2024 at 6:30 pm
Awesome! If the article is correct, I can install SSMS, skip the whole SQL Server backend piece, and still build great databases to run my business. Think of the money...
December 30, 2022 at 2:24 pm
I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy fashion.
Cyberark...
December 7, 2022 at 7:25 pm
When I worked at a Fortune 100 company, passwords that were used by machines only, and not people, had a 12 month password change cycle. Changing machine only passwords every...
December 5, 2022 at 5:12 pm
Some random thoughts on what we've learned since moving to scaled agile at my work:
April 9, 2022 at 2:26 pm
Viewing 15 posts - 1 through 15 (of 269 total)