Viewing 15 posts - 2,461 through 2,475 (of 22,219 total)
You're all still here?
Go home.
(btw, hate that movie, but it's a good quote)
"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
July 22, 2019 at 12:35 pm
You're all still here?
Go home.
(btw, hate that movie, but it's a good quote)
"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
July 22, 2019 at 12:34 pm
If I misunderstood, I apologize.
What you're saying you want is a separate database to use for reporting. That separate database will consist of data from a bunch of other databases...
"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
July 22, 2019 at 12:28 pm
This is a problem I am going to have to deal with soon. In most of our dev data, it doesn't need to be realistic data and our options...
"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
July 11, 2019 at 5:19 pm
Have you looked at Dynamic Data Masking in SQL Server? https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-2016 Not sure what you mean by "custom built scripts". You don't need to write any extra scripts 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
July 11, 2019 at 1:15 pm
My vote is for Redgate Data Masker. It's an amazing tool. Also, great integration with SQL Clone. Together, they make a provisioning tool for non-production environments.
"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
July 11, 2019 at 12:36 pm
This question got asked in two places (btw, please don't do that). I answered on the other one with this:
Here is one article and here is another. Between...
"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
July 11, 2019 at 11:20 am
With nothing to go on but the description you've provided, I have no idea. It could be so many different things that it's hard to say. Differences in the ANSI...
"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
July 11, 2019 at 11:08 am
So, I work for Redgate. Bias may play a factor here.
Static data masking may be OK in production environments where you have a degree of control. However, it won't work...
"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
July 11, 2019 at 11:03 am
My experience with, and knowledge, filestream is somewhat limited, so I'm hesitant to pronounce too strongly on this approach. I do know that files within databases leads to all sorts...
"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
July 10, 2019 at 6:17 pm
Yep. It'll do exactly what you're asking. All seven instances in one view.
"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
July 10, 2019 at 4:52 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
July 10, 2019 at 10:38 am
Most of the major tools have mechanisms for monitoring replication in one way or another. Redgate Software's SQL Monitor (I work for Redgate by the way) uses custom metrics...
"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
July 10, 2019 at 10:15 am
Here is one article and here is another. Between the two, we outline a bunch of ways to solve the versioned data approach. The core of it is,...
"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
July 10, 2019 at 10:09 am
The issue is that internal developers can seem to get the script to work and there investigations point to the OPENROWSET Function part of the script as after...
"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
July 9, 2019 at 5:11 pm
Viewing 15 posts - 2,461 through 2,475 (of 22,219 total)