Viewing 15 posts - 2,011 through 2,025 (of 22,232 total)
Have you tried Azure Data Studio? I use that with containers all the time. It should work. You may have to use the IP address instead of just relying on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 3:11 pm
You can get information of the DBCC executions by querying the default trace file for the Audit DBCC Event. It will have login, host name, application name, etc.
Sue
Just...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:54 pm
Grant Fritchey wrote:Well nuts. Missed that one too. I stink.
Look at it this way, you're helping the rest of us deal with our imposter syndrome.
HA!
Yep. Just one of the many...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:53 pm
If you want to capture the commands without having to run sp_who2 (and oh boy, a ton of ways to get information out of the database better than that), just...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:28 pm
I'm not aware of any way of doing this.
Strong suggestion, have a copy of your database in source control so that you can easily restore columns after you find out...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:24 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:22 pm
Looks like the connection string isn't complete. Here's a blog post that might help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:19 pm
Well nuts. Missed that one too. I stink.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:15 pm
Thanks. This is a tough lesson to keep in mind. I forget it from time to time, even at Redgate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 9, 2020 at 1:23 pm
I really should read these more closely. I may even get some right.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2020 at 11:48 am
oops.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2020 at 9:07 am
A thousand likes on this editorial, Grant! WOW, I've never heard of juice jacking or the rest of it. In this case, ignorance although it may be bliss, it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2020 at 3:17 pm
Thanks for that posting - it was a good reminder that we have to be more cautious and less trusting when traveling. I'd like to thing everyone is as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2020 at 3:15 pm
If you were posting it to the water cooler, I think it's fine. Posting it to the forums could very easily be interpreted as spam (not by me, but by...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2020 at 10:24 am
Since you're not telling a declarative language exactly what you want it to do, you're counting on a behavior that you simply can't count on. I get it that it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 5, 2020 at 9:59 am
Viewing 15 posts - 2,011 through 2,025 (of 22,232 total)