Viewing 15 posts - 1,336 through 1,350 (of 22,227 total)
Generally, I use a combination of Active Directory groups (assuming Windows), and roles to define security.
As shown above, you can grant specific actions to a role. So, do that. Least...
"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
May 11, 2021 at 11:34 am
So, I really love Policy Based Management. However, you need to know, Microsoft doesn't share my feelings. They have given that technology almost zero attention since it was originally released....
"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
May 11, 2021 at 11:31 am
MSDN is the only way I know to have a renewable set of time in Azure for less cost. You can get a free trial, but it runs out and...
"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
May 10, 2021 at 3:05 pm
There may be a million details on this, but I'd start with two general concepts.
For emptying the table in order to reload it, TRUNCATE is your best bet. There are...
"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
May 7, 2021 at 11:36 am
One thing I would strongly suggest for your career, don't get hung up on labels or titles. I was working as a database developer, and by that I mean, designing,...
"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
May 7, 2021 at 11:15 am
For learning Synapse, also look up Azure Data Warehouse. That's the old name. So there's a lot more documentation there. I have a few blog posts. I used to teach...
"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
May 7, 2021 at 10:47 am
Synapse is really cool, and worth your time. It also doesn't change that much at the core. At the edges though, hoo boy.
"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
May 6, 2021 at 12:19 pm
I've been working with Azure for over 10 years now (and I've added AWS in the last year, along with some other stuff). Fact is, it's hard. Take Azure SQL...
"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
May 6, 2021 at 10:50 am
Availability Groups are generally considered to be the modern, safe, approach to high availability. At the very least, they get a lot more love & attention from Microsoft than any...
"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
May 5, 2021 at 11:55 am
Yeah, what jeff said.
"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
May 5, 2021 at 11:27 am
Ooh, yeah, PowerBI. Another vote for exploring that space as a possible solution. In fact, it might work for you and not require a lot of data movement. Maybe.
"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
May 5, 2021 at 11:24 am
Happy to 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
May 4, 2021 at 3:09 pm
Nope. It's almost two years old. It was a wildly successful release with very few bugs or issues. What it did have (nothing is perfect) has largely been addressed 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
May 4, 2021 at 12:29 pm
The key to deadlocks is usually, but not always, that you have multiple different queries, not the same query, that are accessing the various tables in different orders. Meaning, one...
"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
May 4, 2021 at 12:28 pm
This might not be real simple. Microsoft lists a bunch of ways you can do it though. Probably the easiest is using the SQL Server Import/Export Wizard in Excel....
"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
May 4, 2021 at 12:22 pm
Viewing 15 posts - 1,336 through 1,350 (of 22,227 total)