Viewing 15 posts - 7,906 through 7,920 (of 59,072 total)
also object level recovery from a .sqb file without needing to restore is cool (by the way - I don't work for Redgate - I just bug their...
January 10, 2020 at 1:57 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Is Redgate backup able...
January 10, 2020 at 1:52 pm
Things like CI need to be quick, so we want a limited data set.
Gosh... I absolutely cringe when I hear things like that. That's one of the reasons...
January 10, 2020 at 6:50 am
Getting kind of back on topic, has anyone tried the demo I provided?
I have, brilliant work my friend
😎
But as I'm ACE'phobic and I do not trust the black-box...
January 10, 2020 at 5:55 am
Getting kind of back on topic, has anyone tried the demo I provided?
January 9, 2020 at 6:39 pm
From what I understand, DTU is not based on RAM alone. Please see the following article.
https://sqlperformance.com/2017/03/azure/what-the-heck-is-a-dtu
January 8, 2020 at 10:00 pm
If you TRUNCATE all tables, you better have a script handy to repopulate ALL your necessary reference tables. 😉
January 8, 2020 at 9:50 pm
Phil... where do you hail from? I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 and...
January 8, 2020 at 9:14 pm
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
I was thinking the same and there...
January 8, 2020 at 8:02 pm
I know I don't have to check on the CLR thing... I don't use them. 😀
January 8, 2020 at 7:59 pm
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
Just to be sure, my solution didn't include...
January 8, 2020 at 5:06 pm
This is why I moved away from SSIS and ACE for spreadsheets with mixed data (ie numeric and alphanumeric) in the same column,...
January 8, 2020 at 5:02 pm
Jeff, thank you for taking the time to write all of this stuff out.
Importing from Excel using SSIS is almost always a massive pain, so I am going to...
January 8, 2020 at 4:56 pm
Heh... can you put the Create Table statement back in?
January 8, 2020 at 5:02 am
Your test data only has one person per group.
January 8, 2020 at 4:52 am
Viewing 15 posts - 7,906 through 7,920 (of 59,072 total)