Viewing 15 posts - 1,441 through 1,455 (of 22,219 total)
At the most fundamental level, access to data & structures within a database, there are zero differences between a SQL login and a Windows login. You will map logins 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
February 10, 2021 at 12:13 pm
Yes, I work for them. Doesn't mean I'm not right.
SSMS Intellisense is weak, at best. Check out Redgate SQL Prompt. Not just wildly superior Intellisense, but code formatting, refactoring,...
"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, 2021 at 12:13 pm
Some combination of Extended Events, Change Data Capture and SQL Audit are what you're looking for. One thing to note, Change Data Capture modifies the data structure....
"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, 2021 at 12:03 pm
OK, I'm a little confused by how the question is phrased. It sounds like you & the security team are hesitant to use Windows Authentication? Don't be. Use it. It's...
"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, 2021 at 11:57 am
Overall, SQL Sever 2019 is a radically improved product over, pretty much all of them. Just using Query Store as an example, it was great in 2016 and I fell...
"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 8, 2021 at 6:27 pm
I agree with Johan, 2019 would be the way to go.
Just understand one thing though, going from 2008/R2/2012, you are hopping a bit of a gap at SQL Server 2014....
"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 8, 2021 at 1:02 pm
I've no idea what Brent had to say. Great guy, but he wasn't on the board or directly involved. I've no idea what cloud stuff is being referenced. No "cloud...
"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 3, 2021 at 1:36 pm
Yeah. You could. The search results will stay in one window and you can open the queries in another. However, this is the slow, tedious, error prone way to get...
"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 3, 2021 at 12:45 pm
And when those I/O operations take that long, the problem is not inside SQL Server. It's outside. The OS, disk controllers, network, switches, hubs, or the disks themselves. That's why...
"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 3, 2021 at 12:37 pm
xxx-593414 wrote:Hi Thanks for your reply
No. SqlServer is not under Source Control
It should be.
This. So very much, this.
Redgate has a free tool that can assist you searching inside your...
"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 3, 2021 at 12:36 pm
We are working out our plans, and that includes what to do with pass.org. Nothing to report at the moment, but please, keep the feedback coming.
What would you want 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
February 3, 2021 at 12:33 pm
No plans in any direction that I'm immediately aware of regarding naming anything. More to come on that. As to the technology, again, no plans just yet, but I'd put...
"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 1, 2021 at 11:20 pm
The rough plan at Redgate is, get all the PASS material out there, ASAP, and all of it for free. Now, devil is in the details, as always. But that's...
"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 1, 2021 at 9:00 pm
John, I still haven't presented a session anywhere in WV. Just sayin'.
"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 1, 2021 at 7:30 pm
Thanks for the feedback. Nothing personally to add here. Just letting you know that someone is reading this stuff.
"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 1, 2021 at 7:11 pm
Viewing 15 posts - 1,441 through 1,455 (of 22,219 total)