Viewing 15 posts - 1 through 15 (of 264 total)
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
Make sure that the necessary powershell modules are installed on the server where SSIS is running. We've encountered this before, and since our SQL servers do not have internet access,...
March 16, 2022 at 1:50 pm
Almost never is test/dev secured as well as production. This is a place where many data breaches have occurred.
While this isn't as much of an issue for you, Rod,...
March 2, 2022 at 8:19 pm
Biggest arguments I've had with developers :
Insistence on putting all of the logic in C#, with no consideration given to whether a stored procedure would be better. Debugging LINQ to...
January 20, 2022 at 6:16 pm
We just tell the infrastructure folks how many cores we need, how much memory, and how much disk, and the server name. They let us know when it's ready. We...
November 11, 2021 at 5:24 pm
My thanks to Jeff, Voldemar and Scott.
@jeff, I was thinking of getting the remote server name through some variable or a function in remote server while...
March 8, 2021 at 6:55 pm
Viewing 15 posts - 1 through 15 (of 264 total)