Viewing 15 posts - 1,846 through 1,860 (of 22,214 total)
So, before I comment on anything, remember, testing is your best friend in these situations. Anyone can have opinions on behavior. However, you should test those opinions and assumptions against...
April 13, 2020 at 10:51 am
First, tell your friend to simply be honest about their knowledge and experience. Next, some good news. To a large degree, SQL Server is SQL Server. Whether we're talking about...
April 13, 2020 at 10:33 am
It's a very good idea to have a second copy of your backups anyway. Not all of them every time, but, say, weekly or something. Just so, in the event...
April 13, 2020 at 10:27 am
Grant Fritchey wrote:I am the canary in your coal mine.
Rumor has it that the first people that will get axed are people that keep badmouthing SQL Profiler. 😀 😀 😀
HA!...
April 9, 2020 at 11:49 am
No company could have been prepared for this. And, because of that, I fear that real thought will not be put into the decision about who to get rid...
April 8, 2020 at 7:42 pm
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is getting...
April 8, 2020 at 7:40 pm
Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?
Yes!
General Data Protection Regulation, California Citizens Privacy...
April 8, 2020 at 6:06 pm
Sensitive data should absolutely not be in use in dev & test servers. So that shouldn't be a problem.
April 8, 2020 at 2:08 am
Pretty sure it was Jesus who said: You will always have the idiots with you. Or something like that. I'd just say that even with that... individual, better to be...
March 28, 2020 at 11:56 am
Nuts. I'm stuck. Have you compared the plans?
March 25, 2020 at 3:06 pm
Since you can't do a backup & restore locally, you're doing a BACPAC I assume? Since that rebuilds the indexes, it also resets all statistics. I'd focus there as the...
March 25, 2020 at 1:59 pm
You can't do that.
If you want to, you can:
SELECT @Result = a.SomeColumn
FROM dbo.ATable AS a
WHEREa.id=42;
March 24, 2020 at 11:51 am
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic
we all...
March 23, 2020 at 3:06 pm
If you can, post both execution plans. By and large, Azure SQL Database just works exactly the same as regular SQL Server. So, all things being equal, a good index...
March 23, 2020 at 10:23 am
maybe rather than live webinars, you could do what Microsoft virtual academy did... stick a 10 minute video up on line and we have it on demand. brent ozar...
March 23, 2020 at 10:15 am
Viewing 15 posts - 1,846 through 1,860 (of 22,214 total)