Viewing 15 posts - 346 through 360 (of 6,025 total)
What I haven't seen in this conversation is any control for uniqueness.
... How will you control uniqueness assuming that you find it incorrect to have a line item billed...
July 24, 2020 at 2:30 pm
Inserting, updating, or deleting rows in a table shouldn't be a routine function of a database sysadmin. So, perhaps the all-powerful SYSADMIN role itself should be deprecated or DML permission...
July 23, 2020 at 5:20 pm
In a traditional on-prem IT department, compute and storage are a capitalized expense (CapEx), so if $500,000 is spent on a shiny new data warehouse server, then management wants to...
June 18, 2020 at 6:17 pm
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
Viewing 15 posts - 346 through 360 (of 6,025 total)