Viewing 15 posts - 361 through 375 (of 6,034 total)
...
It's funny how people think that you don't need xp_CmdShell on managed systems like Azure.
Do they also not allow for OPENROWSET()?
You can OPENROWSET (or BULK INSERT) from CSV, Excel,...
May 14, 2020 at 4:54 pm
Azure SQL is still 99% the same familiar T-SQL we've been using for decades. Some features like Availability Groups and DBCC commands are gone, because they have been replaced with...
May 14, 2020 at 1:53 pm
What I'm talking about is a firewall on the PC that profiles executable for suspicious behaviour and then warns via a dialog - allowing user to whitelist or block the...
May 14, 2020 at 1:33 pm
It seems that modern malware detection / prevention should be more AI. It's highly unusual for an executable to traverse through \My Documents and network folders encrypting files, and that...
May 13, 2020 at 1:51 pm
...
Unless I flip the bill myself and do it on my own time, I’m stuck in a vintage world of DBA’s.
Any suggestions for someone like that?
The good news...
May 12, 2020 at 4:58 pm
As a DBA in the cloud era, there are many more technologies that we need to familiarize ourselves with (PowerBI, ML, Document databases) but we don't necessarily need to know...
May 11, 2020 at 4:05 pm
With that, I have to ask, since MD5 returns a 16 Byte result and you convert that to BIGINT, which is an 8 Byte result (which is a whopping...
May 7, 2020 at 9:13 pm
A recent database I created involves tables where the natural unique keys are several columns wide. Rather than using an IDENTITY or other incremental ID, for the surrogate key column...
May 6, 2020 at 9:45 pm
I don't know for sure either, but reading the FAQ, it seems like this wasn't a 3rd party hack but perhaps two employees abusing their privileges. I can picture a...
April 30, 2020 at 3:34 pm
Our company has a mobile app that allows customers to make payments, update contact info, look at purchase history, etc. We have an enterprise data warehouse that works great for...
April 23, 2020 at 3:19 pm
When we provision a instance, we will set SQL Server max mem so that at least 4 - 8 GB memory is free for both Widows and SSMS. If I'm...
April 21, 2020 at 7:28 pm
"Or maybe you've done it once or twice and forgotten about it."
Well, once you've deployed an Availability Group, it's impossible to just forget about about. It's an endless source of...
April 3, 2020 at 5:26 pm
Extremely good advise, Steve. I'll add just one thing and that's if you find you need to look for another job, it might mean relocating, if the opportunities aren't...
April 3, 2020 at 5:21 pm
Most of the organizations I've worked for were IT centric - where folks tend to be rational, competent, and focused on their job. The better employers will weed out individuals...
April 2, 2020 at 1:38 pm
Any candidate who fails to get the joke doesn't get a 2nd interview. 🙂
April 1, 2020 at 1:42 pm
Viewing 15 posts - 361 through 375 (of 6,034 total)