Viewing 15 posts - 346 through 360 (of 6,022 total)
I'd like to take a week long hike in the Appalachian mountains this fall after it gets cool.
May 15, 2020 at 12:59 pm
The following article is an overview of how Azure Function can be spun up to bulk load .csv files in parallel from Blob Storage to Azure SQL, how Blob Triggers...
May 14, 2020 at 8:53 pm
That sounds like workflow - you can move files around in Blob Storage using Azure Data Factory, REST API, PowerShell, etc.
May 14, 2020 at 8:44 pm
...
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
Viewing 15 posts - 346 through 360 (of 6,022 total)