Viewing 15 posts - 31 through 45 (of 6,041 total)
Also, remember that it makes no difference how complex your service account passwords are, if they ultimately get stored in configuration files or source code.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 19, 2025 at 3:23 pm
We have Ola Hallengren index/statistics maintenance deployed on each of our servers. I created a custom Grafana dashboard to analyze the CommandLog table, so I can get a report of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 10, 2025 at 2:02 pm
SSN can be used as a reliable primary key for a table called Customer_SSN. It should be linked to a CustomerID, just like phone number(s) and email address. But I...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 3, 2025 at 8:42 pm
So, what do you think of the advice? Is it that much different than you'd get from a colleague? Likely it depends.
Regarding asking CoPilot to analyze an execution plan,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 28, 2025 at 7:02 pm
Copilot, if I paste the XML for a query plan, can you give advice?
Copilot
Absolutely, I'd be happy to help analyze the XML for your query plan and provide advice!
Please go...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 28, 2025 at 5:05 pm
I have started using CoPilot a lot lately, and I find it very useful for quickly writing the first draft for tasks like PowerShell scripting or creating an Extended Event...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 27, 2025 at 9:30 pm
Most AI chatbots keep the conversations sandboxed, so even if we convince it that it's wrong on some specific topic, it won't remember outside the context of that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 24, 2025 at 2:43 pm
Maybe I'm an optimist, but I think what's also happening is that corporations are learning from past mistakes - getting smarter and better when it comes to employee training, security...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2025 at 4:38 pm
Regarding "unreliable narration", that just makes LLMs more human.
+1000! I've said that it has the "being human" part pretty much down pat. I very confidently provides the wrong...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2025 at 4:26 pm
If they are passing in a collection IDs like CustomerID or SKU, then they should consider using a table valued parameter.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2025 at 2:22 pm
SSMS could benefit from an integrated extension marketplace similar to what is in ADS and VSCode.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 12, 2025 at 6:22 pm
By default on each server, I keep a handful of Extended Event sessions running continuously for occasional performance events like deadlocks, timeouts, CPU pressure, T-SQL errors, long running queries, etc....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 10, 2025 at 2:32 pm
Regarding "unreliable narration", that just makes LLMs more human.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 7, 2025 at 8:51 pm
First, "data debt" smells a lot like "technical debt".
Regarding data warehouses (not to be confused with data lakes), if it's architected based on something like the Kimball dimensional method, then...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 31, 2025 at 6:31 pm
...
Early 2000's, someone reviewing .NET observed that "This is going to kill all the cowboy coders"!
Remember when Hadoop was going to kill off all the data warehouses?
Remember when...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 30, 2025 at 3:37 pm
Viewing 15 posts - 31 through 45 (of 6,041 total)