Comments
Sort by recent activity
Going one step past Alex's statement, I will ask were you putting a lot of data into source control that didn't NEED to be there? The ONLY thing I would think would change over time (certainly by any reasonable amount) would be #3, the most recent rows. What was your business case for storing that data as "static" in a source control system?? I sure as heck couldn't think of one off the top of my head. / comments
Going one step past Alex's statement, I will ask were you putting a lot of data into source control that didn't NEED to be there? The ONLY thing I would think would change over time (certainly by a...
I am curious if Microsoft has released any sales/implementation data for SQL Server running on Linux. I don't move in circles that use Linux. / comments
I am curious if Microsoft has released any sales/implementation data for SQL Server running on Linux. I don't move in circles that use Linux.
I am personally VERY excited about the SQL Provision Kit recently announced! I have given many hundreds of presentations, and the majority of them were from content created in some measure by others (that I received permission to use). As much as I really enjoy GIVING presentations, I equally dislike both reinventing the wheel and creating content. So I would LOVE to see more such "here's presentation material for Redgate Product XYZ" that I can use to spread the word!! / comments
I am personally VERY excited about the SQL Provision Kit recently announced! I have given many hundreds of presentations, and the majority of them were from content created in some measure by other...
I hope I finally get the chance to take a crack at this automated deployment stuff! :-) Thanks! / comments
I hope I finally get the chance to take a crack at this automated deployment stuff! :-) Thanks!
My laptop has 32GB of RAM. [image] If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have enough RAM. Having said that, with clones you need some serious low-latency-high-throughput networking for it to be successful if the image files are not local. Does your server have a single 1Gb network card by any chance? Oh, and the storage that the images are on needs to be fast as well. Also, what is your server's storage comprised of? / comments
My laptop has 32GB of RAM. If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have ...
I just had my first experience with Data Masker, and I have some significant suggestions. I would LOVE to have a chat with the people leading the charge on the next edition!! Please have them reach out to me if they are interested. I hope I am not too late for the V-Next release, but better late than never. 1) Wildcards or multiple schemas on initial grab of tables? 2) I am rather jet-lagged (just arrived in Europe yesterday), but the interface didn't feel intuitive to me at all. I don't yet have specific suggestions because I am rushing through to complete what is needed so I can move on to other things. 3) It looks like you are doing RBAR individual updates, apparently without even a BEGIN TRAN/COMMIT TRAN wrapped around some number of those. That is a CRUSHINGLY-BAD thing to do to SQL Server, especially from an IO write perspective. 4) You are updating the same table N times each, where N is the number of columns that have some operation on them. So you can immediately reduce transactions by N-1/N by updating all columns for each row just once. I note this may not be possible if "don't do NULL fields" is a thing, but you can possibly know about if still valid a few different ways. 5) Everything seems to be serial. Multi-threaded operations would seem an obvious need. 6) Is there an option to make the database SIMPLE recovery mode to avoid tlog bloat? 7) Is there an option to check tlog percent full and fire off backup? 8) Batching row updates with transactioning could provide a HUGE performance boost due to several factors. / comments
I just had my first experience with Data Masker, and I have some significant suggestions. I would LOVE to have a chat with the people leading the charge on the next edition!! Please have them reach...
Helping with product development, especially UX, is one of my favorite things to do for Redgate. / comments
Helping with product development, especially UX, is one of my favorite things to do for Redgate.
ben_b said:
Just tried figleaf - really nice interface and really easy to use. the only problem is that when I went to apply the mask it pointed out that the devs who created the database I've inherited didn't concern themselves with adding primary keys!
Well, the first problem is that developers created the database schema!! LOL After that are you saying that FigLeaf requires primary keys to function or just that it helpfully points out the lack of them? / comments
ben_b said:
Just tried figleaf - really nice interface and really easy to use. the only problem is that when I went to apply the mask it pointed out that the devs who created the database I'...
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a different client? / comments
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a diff...
If we are logged into the redgate site, shouldn't we be able to download the white papers and other material without having to go through the "tell us who you are" stuff? / comments
If we are logged into the redgate site, shouldn't we be able to download the white papers and other material without having to go through the "tell us who you are" stuff?