Viewing 15 posts - 106 through 120 (of 22,219 total)
2100 parameters for a sproc? If you think that is a problem, you have far larger real problems.
Ha! Yeah, no kidding. However, someone, with a bunch of money, went...
"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 17, 2025 at 2:11 pm
Your best bet is to use the Azure Pricing Calculator or directly contact support. And remember, it's not just storage costs. Are you moving data OUT of Azure? That...
"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, 2025 at 1:08 pm
Export, backup, whatever. It's going to look & act like a drive inside the VM.
"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
January 27, 2025 at 12:36 pm
If you create a container inside your storage account, you can then use the mount command to mount it as NFS storage inside the VM.
Something like this (example code from...
"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
January 15, 2025 at 1:19 pm
I couldn't agree more about being prepared ahead of time. When I read your post, what immediately came to mind were two words: Crowdstrike 🙂 That horrible morning...
"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
January 14, 2025 at 5:07 pm
Grant Fritchey wrote:The universe is actively out to get us.
This made me laugh.
It's not paranoia if it's true, right!? 😉
Exactly.
"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
January 13, 2025 at 8:42 pm
There's a connection to the database. That's what that error is telling you. I'll bet money it's SSMS. However, to find out, just open a query window, not connected to...
"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
January 13, 2025 at 3:51 pm
You're a pretty strong candidate for moving that database to the cloud. As you say, you don't have expertise in hardware or operating systems in house. Moving the database to...
"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
January 13, 2025 at 2:38 pm
You can check the encryption status of your databases:
SELECT
db.name AS database_name,
db.is_encrypted,
dm.encryption_state,
dm.percent_complete,
dm.key_algorithm,
dm.key_length
FROM
sys.databases db
LEFT OUTER JOIN
sys.dm_database_encryption_keys dm
ON
db.database_id...
"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
January 13, 2025 at 2:33 pm
Hey Rod,
I do not have a good answer.
Probably, especially considering we're talking security, you'd be better off migrating out of the existing thing, whether it works or not. However, I...
"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
January 13, 2025 at 2:30 pm
There can be no other connections to the database when you run a restore. That includes SSMS. So, if you have that database open in front of you and you...
"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
January 13, 2025 at 2:26 pm
In the real world, one has to hope for the best, plan for the worst and insure for anything else! 😎 Weather is just one of the many factors,...
"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
January 13, 2025 at 1:41 pm
Most of us know Murphy's law that 'anything that can go wrong will go wrong', but fewer of us realise that Murphy was an optimist.
...
Good gosh. That's incredible. Well...
"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
January 13, 2025 at 1:40 pm
You've described the scenario, but I don't see much in the way of solutions. Do you have a question? If not, expand this out, provide some solutions, and submit 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
January 9, 2025 at 1:28 pm
Not a clue. I haven't seen something like this before. However, I'd suggest not bothering to look at the proc cache any more. Look elsewhere. What the heck is using...
"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
January 9, 2025 at 1:25 pm
Viewing 15 posts - 106 through 120 (of 22,219 total)