sqlrockstar ✭✭✭✭✭

Ideally, the roads are widened for bike lanes, so as to not reduce traffic flow. But that's not always possible. I think that's why some cities are going to outright bans of cars in a central area, creating pedestrian areas. That way you can create new bike lanes and not worry about cars at all. I'm a huge fan of this type…

Oh, I think I've quoted Dalton a few times. Maybe not here, that could be the first for THWACK. I know I've used him a few times on my own blog. "Be nice", "saves time", "It'll get worse before it gets better", "you're too stupid to have a good time", "there's always barber college"...the list goes on and on. Roadhouse is…

Thank you!

Yes, I honestly believe Microsoft, because if they aren't being truthful it will come back to hurt them in their wallet. There is too much risk for them to play games with data privacy. I'm more concerned about the companies that aren't making an effort in this area.

It is never unreasonable to be paranoid about recovering data. What 'performance problems' are you referring to with regards to the VM backups? Is it because they are doing rolling snapshots and not deleting the older snapshots? I'd suggest that you keep doing your database backups and not worry about the server team…

Congrats to all the winners, and to all THWACK members for being full of awesome.

Yep. My point was to talk about creating something that engages others to participate in technology. The idea of creating a site to have people build and test models about disease cures is quite interesting, too. And if it helps some kid out there grow to become a better medical researcher, that's even better.

JFK is in Queens, so yeah, you can say you've been to NYC. But if you can get a chance to visit Manhattan, you should do so. Let me know when you go, I can offer some travel tips. I know adatole has some inside info on NYC as well.

The mask was enjoyed by all.

The recipe is a family secret, I couldn't possible share it with everyone: Whiskey Maple Bacon Popcorn Balls

Ha! You were great, I just tag along.

Everything old is new again.

A good DBA isn't going to have an issue with Linux. Now, if you are expecting your MSSQL DBA to also be an experienced Linux admin, you might struggle to find that combination. But I would then ask why you are having your DBA also be the O/S admin. Good DBAs are going to understand the basics (disk, network, CPU, memory)…

We should? I mean...YES...we should!

The person walked into traffic. It wasn't the car, or the software at fault. And there was a human in the car that could have hit the brakes. There was no time to react. And if there was time, I trust the reaction time of the software versus a human.

So much bacon goodness stuffed into this one release, so proud of what the team was able to get done!

Nope, they are in the shed, it's all good.

Yeah, it's almost as if criminals invented a way to exchange something of value for illegal activities to avoid getting in trouble with law enforcement, and then had to find ways to artificially raise the price in order to recover the amount of money they have spent on mining.

I was thinking the same thing. They would likely have dozens of these in place, and swap them out only when a percentage of drives were bad. Similar to how they manage a data center now.

Ah, yes. That sounds like a frustrating experience for everyone.

Oh, I could talk Patriots all day long, if you want.

I enjoy staying near Times Square every now and then. The trouble with that can be the noise and the lights depending on which way your hotel room faces.

We don't trap the literal values, but it is possible you may find the literals inside of the query execution plan. HTH

@"AdemirP" I think it is just math, but I am not certain. My understanding is that Storage I/O is tracking latency when it is exceeding a threshold. So, you could have busy disk, but if it never crosse a threshold then it doesn't get tagged as a storage wait event, and is just lumped into another bucket. Storage I/O is not…

@"AdemirP" Are you still having issues upgrading? Maybe try to stop/restart the service and see if that helps? You could also check the logs (IWC, Error, or Wizard logs) and see if there is any indication of an issue there. If you are still having issues, I would ask you open a support ticket so we can track any issues.…

@"tim_harkin" Can you help me understand what you mean by 'query history'? I can't recall back to version 10.2, but in the current version if you click on a hash value you will land on the query intelligence page like…

@"cuppadan" There does not seem to be a way to exclude machines from the default report page. So, I have two suggestions. 1. You can search for a similar customer report here, and modify the code as necessary. 2. You can build a report from the report page, for just the machines you want to exclude. Capture the SQL that is…

SQL Server licensing (and most of Microsoft products) is intentionally vague. Here's a link to their guide for SQL 2016: http://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US This entire thread is but one example of what I see whenever someone tries to…

Sorry, I'm still confused by this. If I create a table, load data, and then build my indexes I should have no fragmentation. Age of the table and index should not matter as much as how/when they are created. That being said, I can certainly understand the frustration of being alerted to something that you'd rather not be…

Yeah, I'd say that's the case here, you aren't getting full functionality. I don't know why that would be the case.